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-16','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-16' OR end_date>='2025-12-16 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 184 390 835 586 158 932 232 207 914 440 577 323 199 127 228 255 657 252 398 250 871 366 194 883 1048 180 254 0 528 587 667 747 321 422 545 233 589 213 189 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.004624

page: -0.772226

dist: 4.000000000004E-6

evt: 0.178821

reg: 0.104026

cat: 0.245984

lab: 0.068276

month: -0.114879