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='2025-06-03','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 '2025-11-01' AND DATE_ADD('2025-11-30', INTERVAL 1 DAY) OR end_date BETWEEN '2025-11-01' AND DATE_ADD('2025-11-30', INTERVAL 1 DAY) OR (end_date>='2025-11-30' AND start_date<='2025-11-30') ) AND (start_date>='2025-06-03' OR end_date>='2025-06-03 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC193 265 274 970 617 11 396 218 182 172 656 390 693 186 903 41 592 297 65 185 818 68 73 61 254 737 512 63 33 143 6 149 975 183 74 66 628 1035 40 573 246 1037 478 75 187
//
include: 0.0053099999999999
page: -0.988651
dist: 9.0000000000368E-6
evt: -0.736694
reg: 0.026357
cat: 0.26824
lab: 0.076312
month: -0.516259
