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='2024-05-21','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 '2024-05-01' AND DATE_ADD('2024-05-31', INTERVAL 1 DAY) OR end_date BETWEEN '2024-05-01' AND DATE_ADD('2024-05-31', INTERVAL 1 DAY) OR (end_date>='2024-05-31' AND start_date<='2024-05-31') ) AND (start_date>='2024-05-21' OR end_date>='2024-05-21 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC512 265 19 372 182 297 561 0 114 452 255 465 639 125 185 713 95 186 213 274 183 608 62 691 194 439 400 1 207 882 754 541 370 654 655 593 249 456 69 692 994 132 971 787 172 565 398 3 322 818 122 53 503 211 747 158 228 126 396 858 962 63 983 101 544 208 793 361 254 809 230 264 65 180 821 353 232 85 73 629 422 390 259 340 11 498 199 245 216 927 66 974 339 68 46 834 863 309 720 448 184 580 903 828 740 932 799 40 218 687 198 698 419 189 20 237 61 977 143 6 149 244 975 876 74 64 202 919 196 920 12 511 193 555 478 519 457 311 250 533 48 632 745 195 429 915 993 952 812 75 614 247 187 58
//
include: 0.007171
page: -0.460582
dist: 8.9999999999812E-6
evt: 0.225182
reg: 0.005589
cat: 0.150261
lab: 0.053366
month: 0.042282
