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-06','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-08-01' AND DATE_ADD('2025-08-31', INTERVAL 1 DAY) OR end_date BETWEEN '2025-08-01' AND DATE_ADD('2025-08-31', INTERVAL 1 DAY) OR (end_date>='2025-08-31' AND start_date<='2025-08-31') ) AND (start_date>='2025-06-06' OR end_date>='2025-06-06 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC193 265 274 182 230 821 970 617 807 0 36 919 184 202 204 390 2 1010 873 823 396 690 997 512 23 351 127 1018 186 834 73 120 864 565 419 12 654 422 693 788 440 562 11 125 185 819 498 111 143 6 65 149 975 183 74 325 876 66 361 34 216 628 245 1110 195 246 301 40 1 701 1035 49 20 1127 261 75 187 //

include: 0.003919

page: -0.479426

dist: 8.000000000008E-6

evt: 0.302458

reg: 0.119449

cat: 0.3153

lab: 0.069845

month: 0.018789