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-05-18','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-11-01' AND DATE_ADD('2024-11-30', INTERVAL 1 DAY) OR end_date BETWEEN '2024-11-01' AND DATE_ADD('2024-11-30', INTERVAL 1 DAY) OR (end_date>='2024-11-30' AND start_date<='2024-11-30') ) AND (start_date>='2024-05-18' OR end_date>='2024-05-18 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC512 172 254 970 125 670 617 372 63 11 396 182 755 592 120 390 693 114 274 41 185 61 737 452 544 218 629 126 828 943 0 143 65 6 149 265 975 183 66 74 361 193 961 812 876 75 614 213 184 247 187 186 //

include: 0.003397

page: -0.304182

dist: 8.000000000008E-6

evt: 0.214535

reg: 0.027041

cat: 0.156968

lab: 0.037511

month: -0.910639