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-02','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-04-01' AND DATE_ADD('2025-04-30', INTERVAL 1 DAY) OR end_date BETWEEN '2025-04-01' AND DATE_ADD('2025-04-30', INTERVAL 1 DAY) OR (end_date>='2025-04-30' AND start_date<='2025-04-30') ) AND (start_date>='2025-04-02' OR end_date>='2025-04-02 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC747 287 205 11 193 370 932 1 183 274 184 213 541 440 185 23 95 399 828 65 158 452 114 6 68 232 478 390 558 1097 297 1010 323 419 33 321 69 165 66 19 211 169 194 396 651 215 305 189 255 690 2 49 172 0 70 720 565 517 259 818 447 1098 1089 73 1018 1083 656 883 210 180 1088 257 857 10 221 254 237 693 1038 793 970 216 617 246 591 186 295 555 187 654 20 599 873 242 63 885 890 251 285 1085 43 249 962 670 64 220 182 163 77 1090 592 448 403 1096 499 1075 228 569 737 122 293 743 783 207 667 586 903 983 309 202 12 1043 253 252 120 628 245 585 339 179 85 919 218 465 34 198 311 398 594 512 1065 882 125 361 1059 1073 265 1086 53 1099 762 48 227 143 149 74 1035 1051 325 876 62 782 745 920 457 40 511 3 250 1055 645 632 961 369 244 75
//
include: 0.004394
page: -0.835492
dist: 6.0000000000615E-6
evt: -0.722405
reg: 0.029651
cat: 0.242557
lab: 0.043366
month: 0.280246