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-08-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-08-01' AND DATE_ADD('2025-08-31', INTERVAL 1 DAY) OR end_date BETWEEN '2025-08-01' AND DATE_ADD('2025-08-31', INTERVAL 1 DAY) OR (end_date>='2025-08-31' AND start_date<='2025-08-31') ) AND (start_date>='2025-08-03' OR end_date>='2025-08-03 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='animation' AND evenements_id=evenements.id) > 0 ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC193 265 274 187 440 919 182 146 945 184 202 23 821 245 95 204 807 1010 895 65 997 512 218 541 351 517 165 617 186 73 687 66 297 565 170 1127 516 693 788 1096 6 562 1051 11 185 1014 809 819 822 125 498 111 323 232 57
//
include: 0.003474
page: -0.227724
dist: 6.000000000006E-6
evt: 0.460925
reg: -0.670448
cat: 0.267528
lab: 0.081526
month: -0.087048
