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-04-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-05-01' AND DATE_ADD('2025-05-31', INTERVAL 1 DAY) OR end_date BETWEEN '2025-05-01' AND DATE_ADD('2025-05-31', INTERVAL 1 DAY) OR (end_date>='2025-05-31' AND start_date<='2025-05-31') ) AND (start_date>='2025-04-06' OR end_date>='2025-04-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 ASC747 193 252 541 1010 255 258 232 194 158 251 189 180 254 422 210 292 259 182 0 184 202 215 883 376 448 1075 185 274 183 932 213 737 569 280 323 211 246 199 297 687 699 957 237 221 216 348 187 186 555 228 406 465 580 207 191 919 440 390 220 927 656 125 544 227 863 1035 1051 325 218 745 645 961 245 265 379
//
include: 0.003434
page: -0.591847
dist: 6.9999999999792E-6
evt: 0.212711
reg: 0.03555
cat: 0.229201
lab: 0.072759
month: -0.588829
