Problem: The client is experiencing an issue where a SQL query sorts posts by a custom meta field 'trainings_display_date_start' on the homepage. This works correctly on the non-translated (English) page, but not on the translated page, resulting in no posts being returned. Solution: 1. Ensure that the 'trainings_display_date_start' is copied over to the translated posts so there is meta data to sort by. 2. Include a meta query that returns only posts with a start date and then sort by that start date. 3. Verify that the posts are translated and published in the second language. 4. Test the issue with the WP default theme and only WPML plugins enabled to see if the issue is caused by something else.
If this solution does not resolve your issue or seems irrelevant due to being outdated or not applicable to your case, we recommend opening a new support ticket. We also highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. For further assistance, please contact our support forum at WPML support forum.
