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-18','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-12-01' AND DATE_ADD('2025-12-31', INTERVAL 1 DAY) OR end_date BETWEEN '2025-12-01' AND DATE_ADD('2025-12-31', INTERVAL 1 DAY) OR (end_date>='2025-12-31' AND start_date<='2025-12-31') ) AND (start_date>='2025-12-18' OR end_date>='2025-12-18 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 323 835 207 199 127 228 158 1161 255 657 252 398 1149 250 259 871 366 194 883 1048 180 254 0 528 587 667 747 321 422 390 545 233 589 440 213 189 544 183 1035 1051 216 631 245 211 182 202 246 244 701 711 1140 723 745 274 412 1158 926 302 915 265 193 187 //

include: 0.003663

page: -0.804266

dist: 6.9999999999792E-6

evt: -0.804616

reg: 0.307726

cat: 0.188268

lab: 0.071074

month: 0.01688