Problem: You are trying to list all of your pages and posts that have not been translated from English using SQL. Solution: We recommend referring to our documentation on WPML tables and language information: WPML Tables Documentation. To find posts that have not been translated, you can use the following SQL code:
1
SELECT *<br />FROM wp_icl_translations<br />WHERE trid IN (SELECT trid<br />FROM wp_icl_translations GROUP BY trid having count(trid) = 1)
If you need to filter by a specific post type, such as 'Pages', modify the SQL like this:
1
SELECT *<br />FROM wp_icl_translations<br />WHERE trid IN (SELECT trid<br />FROM wp_icl_translations GROUP BY trid having count(trid) = 1) andelement_type LIKE 'post_page'
Remember to prefix the post type with 'post_'.
If this solution does not apply to your case, or if it seems outdated, we highly recommend checking related known issues at WPML Known Issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If further assistance is needed, please open a new support ticket at WPML Support Forum.
