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-06-03','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-06-01' AND DATE_ADD('2025-06-30', INTERVAL 1 DAY) OR end_date BETWEEN '2025-06-01' AND DATE_ADD('2025-06-30', INTERVAL 1 DAY) OR (end_date>='2025-06-30' AND start_date<='2025-06-30') ) AND (start_date>='2025-06-03' OR end_date>='2025-06-03 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 ASC193 274 821 398 1075 255 183 213 932 184 194 569 655 390 737 1010 541 438 254 437 211 827 997 1048 512 297 741 199 228 198 747 292 544 440 0 233 264 182 245 185 699 186 187 207 342 323 216 1012 1110 232 656 202 599 365 448 158 687 406 125 218 667 580 586 272 258 927 882 1117 629 1116 809 1045 1035 325 961 919 1022 265 246 205 745 250 353 457 498 195 555 644 632 //

include: 0.005467

page: -0.382776

dist: 7.0000000000348E-6

evt: 0.171685

reg: 0.027197

cat: -0.775706

lab: 0.058375

month: 0.447191