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-04-07','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-04-07' OR end_date>='2025-04-07 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 193 0 184 202 228 448 274 255 213 932 821 569 183 1010 211 210 512 297 199 198 292 440 254 185 187 182 207 1074 656 687 406 232 125 258 580 272 927 699 390 186 1045 1035 1051 325 218 216 961 919 245 265 246 //

include: 0.005935

page: -0.018452

dist: 6.0000000000025E-6

evt: 0.163155

reg: 0.041528

cat: 0.20015

lab: 0.062362

month: -0.569253