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-08-01' AND DATE_ADD('2024-08-31', INTERVAL 1 DAY) OR end_date BETWEEN '2024-08-01' AND DATE_ADD('2024-08-31', INTERVAL 1 DAY) OR (end_date>='2024-08-31' AND start_date<='2024-08-31') ) 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 544 821 629 670 687 218 202 974 204 390 120 449 183 351 323 127 274 738 186 297 185 244 265 213 919 193 195 626 205 980 0 812 184 247 187 //

include: 0.003416

page: -0.034138

dist: 7.0000000000001E-6

evt: 0.134461

reg: 0.00596

cat: 0.15399

lab: 0.044569

month: 0.224284