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-12-19','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 '2026-04-01' AND DATE_ADD('2026-04-30', INTERVAL 1 DAY) OR end_date BETWEEN '2026-04-01' AND DATE_ADD('2026-04-30', INTERVAL 1 DAY) OR (end_date>='2026-04-30' AND start_date<='2026-04-30') ) AND (start_date>='2025-12-19' OR end_date>='2025-12-19 06:00:00') AND zones_id = ( SELECT id FROM zones WHERE slug='neuchatel') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC1108 932 232 215 158 390 656 321 403 1159 254 448 252 512 274 297 207 580 747 221 237 366 422 239 1051 182 701 183 265 187
//
include: 0.003146
page: -0.390678
dist: 5.0000000000328E-6
evt: 0.184473
reg: 0.032275
cat: 0.182976
lab: 0.085855
month: 0.617531
