INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) INNER JOIN r2b5Y_postmeta AS mt1 ON ( r2b5Y_posts.ID = mt1.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)