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-04-26','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-04-01' AND DATE_ADD('2024-04-30', INTERVAL 1 DAY) OR end_date BETWEEN '2024-04-01' AND DATE_ADD('2024-04-30', INTERVAL 1 DAY) OR (end_date>='2024-04-30' AND start_date<='2024-04-30') ) AND (start_date>='2024-04-26' OR end_date>='2024-04-26 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC512 311 372 254 185 692 252 309 218 274 541 565 33 322 452 640 1 0 818 654 64 478 2 957 593 210 693 883 656 207 77 194 237 321 43 61 705 232 396 114 558 419 69 962 983 714 515 398 68 264 66 202 220 95 120 246 555 265 805 903 205 19 528 215 583 285 858 833 167 184 969 12 10 527 872 49 390 762 245 642 186 182 187 422 149 90 20 40 104 863 259 399 228 448 569 667 272 65 6 244 975 876 213 183 828 216 74 745 737 361 62 645 255 533 919 261 952 11 196 632 920 498 511 3 193 519 544 812 75 614 247 58
//
include: 0.003223
page: -0.969753
dist: 5.9999999999505E-6
evt: -0.777995
reg: 0.01203
cat: 0.157433
lab: 0.053587
month: -0.170118
