select i.* from ( select e.id id, e.title title, e.alias alias, STR_TO_DATE( JSON_UNQUOTE(JSON_EXTRACT(extra_fields, REPLACE(JSON_UNQUOTE(JSON_SEARCH(extra_fields, 'one', '11', null, '$[*].id')), '.id', '.value'))), '%Y-%m-%d') as 'event_date', STR_TO_DATE( JSON_UNQUOTE(JSON_EXTRACT(extra_fields, REPLACE(JSON_UNQUOTE(JSON_SEARCH(extra_fields, 'one', '14', null, '$[*].id')), '.id', '.value'))), '%Y-%m-%d') as 'event_end_date', GROUP_CONCAT(t.name) tags FROM `h9ynh_k2_items` e left join `h9ynh_k2_tags_xref` tx on e.id = tx.itemID left join `h9ynh_k2_tags` t on tx.tagID = t.id WHERE catid = '16' and e.trash = 0 and e.published = 1 GROUP BY e.id ) i WHERE ( i.event_date > STR_TO_DATE('2024-03-25', '%Y-%m-%d') AND i.event_date < STR_TO_DATE('2024-05-08', '%Y-%m-%d') AND (i.event_end_date is null OR i.event_end_date = '0000-00-00') ) OR ( i.event_end_date > STR_TO_DATE('2024-03-25', '%Y-%m-%d') AND i.event_date < STR_TO_DATE('2024-05-08', '%Y-%m-%d') AND i.event_end_date is not null AND i.event_end_date != '0000-00-00' )