culturoscoPe

SELECT evenements.*, evenements.id eID, evenements_dates.start_date, evenements_dates.end_date, evenements_dates.date_status, evenements_dates.comment, zones.code zCode, IF((date_hidden<>'YES' OR ISNULL(date_hidden)), '0', IF(start_date='2024-09-08','1','2') ) ordre_expo, IF( (SELECT COUNT(evenements_categories.id) FROM evenements_categories, evenements_to_evenements_categories WHERE evenements_categories_id = evenements_categories.id AND evenements_id = evenements.id AND est_periode='YES') > 0, 1, 0) ordre_tri FROM evenements_dates, evenements, zones WHERE zones.id = zones_id AND evenements.id = evenements_dates.evenements_id AND event_status='PUBLIC' AND (is_hidden<>'YES' OR ISNULL(is_hidden)) AND ( start_date BETWEEN '2024-07-01' AND DATE_ADD('2024-07-31', INTERVAL 1 DAY) OR end_date BETWEEN '2024-07-01' AND DATE_ADD('2024-07-31', INTERVAL 1 DAY) OR (end_date>='2024-07-31' AND start_date<='2024-07-31') ) AND (start_date>='2024-09-08' OR end_date>='2024-09-08 06:00:00')AND (SELECT COUNT(evenements_to_evenements_categories.id) FROM evenements_to_evenements_categories, evenements_categories WHERE evenements_categories_id=evenements_categories.id AND evenements_categories.slug='exposition' AND evenements_id=evenements.id) > 0 ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC143 65 6 149 265 975 182 183 246 66 186 74 361 218 202 274 372 919 193 11 195 34 187 626 57 980 472 1006 64 1016 457 62 245 511 0 544 812 876 75 614 213 184 247 58 //

include: 0.003544

page: -0.160887

dist: 8.000000000008E-6

evt: 0.370322

reg: 0.006686

cat: 0.255846

lab: 0.044207

month: 0.233423