WPML and language condition | WordPress.org

Hello @kreattivo

Thank you very much for using our plugin. In this case, you can read the posts associated to a language directly from the database with a query similar to:

SELECT * FROM {wpdb.posts} as posts
INNER JOIN {wpdb.prefix}icl_translations post_trans
ON posts.ID = post_trans.element_id
WHERE post_trans.language_code="The language code here";

Learn more about the WPML database structure by visiting the following link:

https://wpml.org/documentation/support/wpml-tables/

If you have other questions about the WPML database structure, you can contact the WPML developers team.

Best regards.