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-05-01' AND DATE_ADD('2025-05-31', INTERVAL 1 DAY) OR end_date BETWEEN '2025-05-01' AND DATE_ADD('2025-05-31', INTERVAL 1 DAY) OR (end_date>='2025-05-31' AND start_date<='2025-05-31') ) 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 11 193 512 252 742 65 1010 419 255 258 69 232 194 49 158 396 172 70 66 311 68 251 189 180 20 114 254 970 62 95 903 19 400 265 138 452 63 422 210 292 41 73 43 259 0 374 714 1 182 184 202 23 163 215 77 883 343 376 448 122 951 1075 185 274 183 932 213 737 569 280 558 323 211 246 199 784 297 687 699 6 120 957 565 237 61 221 693 216 348 654 187 2 33 361 186 555 104 788 10 228 406 465 580 207 3 136 818 191 703 125 1059 617 808 919 64 720 85 440 390 220 998 927 656 971 544 433 227 131 12 863 46 799 478 793 143 149 74 1035 1051 325 876 782 218 745 920 40 511 34 645 961 628 245 519 379 261 372 75
//
include: 0.003391
page: -0.21093
dist: 4.000000000004E-6
evt: 0.305128
reg: 0.034393
cat: 0.235182
lab: 0.042019
month: -0.281412
