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-09-01' AND DATE_ADD('2024-09-30', INTERVAL 1 DAY) OR end_date BETWEEN '2024-09-01' AND DATE_ADD('2024-09-30', INTERVAL 1 DAY) OR (end_date>='2024-09-30' AND start_date<='2024-09-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 265 127 218 182 138 755 821 202 114 828 11 172 390 569 970 670 617 882 185 274 565 23 449 361 544 73 41 61 980 125 791 126 737 396 818 693 123 629 642 186 143 65 6 149 244 975 183 66 74 372 919 193 195 626 57 961 788 0 812 876 75 614 213 184 247 187 58 //

include: 0.003454

page: -0.262692

dist: 6.9999999999792E-6

evt: 0.216129

reg: 0.026808

cat: 0.177882

lab: 0.038209

month: 0.739195