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-01','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-06-01' OR end_date>='2025-06-01 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC193 66 265 372 274 69 1009 233 472 182 1 1086 184 202 821 264 654 541 719 68 452 0 655 678 228 73 398 448 172 95 114 255 1075 11 183 213 699 932 661 65 194 569 512 390 737 1010 33 438 254 437 211 827 997 12 1048 297 741 70 199 517 1087 343 439 198 747 292 40 6 478 61 419 396 125 970 544 793 440 1092 617 90 230 19 693 962 360 863 245 185 186 810 187 207 342 323 49 216 301 45 703 565 10 1012 62 1059 370 1110 232 63 656 48 599 122 788 158 687 406 760 67 218 20 816 580 586 64 272 258 143 927 882 1117 848 2 714 743 629 720 823 104 1116 809 1045 834 149 975 74 1035 1051 325 876 361 34 961 919 628 1022 246 3 1055 205 745 250 353 457 498 195 516 555 511 632 111 261 75
//
include: 0.004792
page: -0.036264
dist: 8.0000000000011E-6
evt: 0.29728
reg: 0.025934
cat: 0.246609
lab: 0.06886
month: 0.126226
