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