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-06','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-07-01' AND DATE_ADD('2025-07-31', INTERVAL 1 DAY) OR end_date BETWEEN '2025-07-01' AND DATE_ADD('2025-07-31', INTERVAL 1 DAY) OR (end_date>='2025-07-31' AND start_date<='2025-07-31') ) AND (start_date>='2025-06-06' OR end_date>='2025-06-06 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 ASC193 274 184 821 807 254 390 1010 228 267 230 182 202 637 401 213 919 440 186 183 325 216 232 245 265 1110 205 195 246 438 701 1035 187
//
include: 0.0034540000000001
page: -0.791828
dist: 5.0000000000328E-6
evt: 0.164242
reg: 0.026986
cat: 0.210244
lab: 0.059069
month: 0.081508
