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-08','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-04-01' AND DATE_ADD('2025-04-30', INTERVAL 1 DAY) OR end_date BETWEEN '2025-04-01' AND DATE_ADD('2025-04-30', INTERVAL 1 DAY) OR (end_date>='2025-04-30' AND start_date<='2025-04-30') ) AND (start_date>='2025-04-08' OR end_date>='2025-04-08 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 287 205 193 184 403 0 1096 232 321 1075 185 297 228 158 277 274 932 213 399 569 737 182 293 1097 323 541 254 783 194 207 667 586 305 183 249 983 309 202 251 883 656 1043 221 253 390 591 245 585 339 179 919 651 448 218 465 246 198 398 807 259 882 440 252 741 361 1073 265 285 1099 762 186 187 555 211 965 127 255 227 1035 1051 325 745 250 645 632 216 961 244 369
//
include: 0.003901
page: -0.089171
dist: 8.000000000008E-6
evt: 0.166568
reg: 0.039857
cat: 0.232977
lab: 0.054879
month: 0.346243
