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-09-01' AND DATE_ADD('2025-09-30', INTERVAL 1 DAY) OR end_date BETWEEN '2025-09-01' AND DATE_ADD('2025-09-30', INTERVAL 1 DAY) OR (end_date>='2025-09-30' AND start_date<='2025-09-30') ) 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 297 821 172 65 807 114 390 224 273 70 693 68 970 512 125 617 882 656 823 182 207 202 809 185 752 149 565 1030 0 654 834 396 218 49 818 629 41 760 254 452 737 2 61 63 11 120 186 73 143 6 975 183 74 325 66 361 919 628 1110 195 246 111 1 701 1035 788 40 20 1127 261 75 187 //

include: 0.00395

page: -0.28703

dist: 1.000000000001E-5

evt: 0.318263

reg: 0.093135

cat: -0.706552

lab: 0.073439

month: 0.095755