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 (58970) 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) >= '20250105' )
OR
( wor3967_postmeta.meta_key = 'data_di_fine' AND CAST(wor3967_postmeta.meta_value AS DATE) >= '20250105' )
)
) 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