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-05','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-05' OR end_date>='2024-05-05 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 172 390 569 970 670 617 882 185 274 565 449 361 544 73 41 61 23 980 125 791 126 737 396 11 818 693 123 642 186 65 6 149 244 975 183 66 74 372 919 193 195 57 961 788 0 812 876 75 614 213 184 247 187 58
//
include: 0.003349
page: -0.544518
dist: 5.9999999999505E-6
evt: 0.210394
reg: 0.0039769999999999
cat: -0.835465
lab: 0.052736
month: -0.113085
