SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id) INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id) INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id) JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type = 'post_documentcenter' JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1 WHERE 1=1 AND wp_posts.post_type = 'documentcenter' AND (wp_posts.post_status = 'publish') AND ( (wp_postmeta.meta_key = 'doc_isonline' AND CAST(wp_postmeta.meta_value AS CHAR) LIKE '%1%') AND (mt1.meta_key = 'doc_isnews' AND CAST(mt1.meta_value AS CHAR) LIKE '%1%') AND ((mt2.meta_key = 'doc_date_start_news' AND CAST(mt2.meta_value AS CHAR) <= '20240520') OR (mt2.meta_key = 'doc_date_start_news' AND CAST(mt2.meta_value AS CHAR) = '')) AND ((mt3.meta_key = 'doc_date_end_news' AND CAST(mt3.meta_value AS CHAR) >= '20240520') OR (mt3.meta_key = 'doc_date_end_news' AND CAST(mt3.meta_value AS CHAR) = '')) ) AND t.language_code='fr' GROUP BY wp_posts.ID