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-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-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-06' OR end_date>='2025-04-06 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC747 193 265 69 1 0 184 202 68 452 228 448 274 172 255 11 213 932 821 65 569 512 183 1010 211 12 210 297 95 70 199 198 292 73 6 419 396 33 125 970 617 66 19 693 440 254 863 185 810 187 182 207 49 45 703 565 10 1074 1059 370 654 63 656 788 62 687 406 232 20 816 258 580 64 272 927 699 2 390 186 104 1045 834 143 149 74 1035 1051 325 876 218 40 361 34 216 961 919 628 245 246 3 372 261 75
//
include: 0.0037
page: -0.163609
dist: 5.000000000005E-6
evt: 0.295092
reg: 0.031318
cat: -0.763738
lab: 0.045856
month: 0.069307
