michaelB-212

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:

If you need to filter by a specific post type, such as 'Pages', modify the SQL like this:

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.