culturoscoPe

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-17','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-02-01' AND DATE_ADD('2026-02-28', INTERVAL 1 DAY) OR end_date BETWEEN '2026-02-01' AND DATE_ADD('2026-02-28', INTERVAL 1 DAY) OR (end_date>='2026-02-28' AND start_date<='2026-02-28') ) AND (start_date>='2025-12-17' OR end_date>='2025-12-17 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 213 184 182 0 208 215 158 228 747 448 403 932 232 293 390 252 656 207 221 237 321 239 254 274 225 323 699 440 580 422 1180 180 406 220 297 1131 544 366 1163 183 1035 1051 245 202 701 265 187 //

include: 0.003951

page: -0.277953

dist: 5.0000000000328E-6

evt: 0.239537

reg: -0.698652

cat: 0.249623

lab: 0.075459

month: 0.434626