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='2024-05-21','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 '2024-05-01' AND DATE_ADD('2024-05-31', INTERVAL 1 DAY) OR end_date BETWEEN '2024-05-01' AND DATE_ADD('2024-05-31', INTERVAL 1 DAY) OR (end_date>='2024-05-31' AND start_date<='2024-05-31') ) AND (start_date>='2024-05-21' OR end_date>='2024-05-21 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 ASC182 297 561 255 465 185 713 639 186 213 274 183 608 194 207 882 0 541 655 593 249 692 994 398 322 503 211 747 158 228 983 544 208 254 809 264 180 821 353 232 629 422 390 259 498 199 245 216 927 974 339 863 309 448 184 580 740 932 218 687 198 698 189 237 244 265 202 919 196 193 555 457 250 533 632 745 195 915 993 812 247 187 //

include: 0.0036619999999999

page: -0.958473

dist: 5.0000000000328E-6

evt: -0.880683

reg: 0.005774

cat: 0.115537

lab: 0.041295

month: 0.241036