SELECT SQL_CALC_FOUND_ROWS wor3967_posts.ID FROM wor3967_posts LEFT JOIN wor3967_term_relationships ON (wor3967_posts.ID = wor3967_term_relationships.object_id) INNER JOIN wor3967_postmeta ON ( wor3967_posts.ID = wor3967_postmeta.post_id ) JOIN wor3967_icl_translations wpml_translations ON wor3967_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wor3967_posts.post_type) WHERE 1=1 AND wor3967_posts.ID NOT IN (0) AND ( wor3967_term_relationships.term_taxonomy_id IN (125) ) AND ( ( ( wor3967_postmeta.meta_key = 'data_di_inizio' AND CAST(wor3967_postmeta.meta_value AS DATE) >= '20260726' ) OR ( wor3967_postmeta.meta_key = 'data_di_fine' AND CAST(wor3967_postmeta.meta_value AS DATE) >= '20260726' ) ) ) AND wor3967_posts.post_type = 'eventi' AND ((wor3967_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wor3967_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','acf-field-group','wpcf7_contact_form','search-filter-widget','eventi','residenze','persone','edifici','spazi360','press','toast','nam','superblast','maker','factory-spaces','piu-cascine','temporaneo' ) ) OR wor3967_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','acf-field-group','wpcf7_contact_form','search-filter-widget','eventi','residenze','persone','edifici','spazi360','press','toast','nam','superblast','maker','factory-spaces','piu-cascine','temporaneo' ) ) GROUP BY wor3967_posts.ID ORDER BY wor3967_posts.post_date DESC LIMIT 0, 3