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-18','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-06-01' AND DATE_ADD('2024-06-30', INTERVAL 1 DAY) OR end_date BETWEEN '2024-06-01' AND DATE_ADD('2024-06-30', INTERVAL 1 DAY) OR (end_date>='2024-06-30' AND start_date<='2024-06-30') ) AND (start_date>='2024-05-18' OR end_date>='2024-05-18 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 994 208 544 422 259 325 670 0 202 875 232 821 228 890 187 593 626 692 264 655 209 189 207 393 254 218 390 220 184 365 376 448 297 185 699 570 213 882 323 541 747 158 969 183 205 336 198 237 449 212 210 687 353 974 709 274 255 569 181 629 599 932 351 656 652 980 199 211 242 258 863 186 244 265 216 245 919 196 193 457 250 745 195 498 561 915 993 632 812 247 //

include: 0.002088

page: -0.90106

dist: 4.000000000004E-6

evt: -0.887038

reg: 0.006323

cat: 0.120385

lab: 0.040304

month: 0.167075