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-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 '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-26' OR end_date>='2025-04-26 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC747 287 11 193 69 213 125 361 512 288 95 1059 439 1073 66 254 720 194 541 265 516 321 1086 68 264 53 49 1092 285 1099 63 12 43 77 527 962 396 228 33 440 762 0 903 202 245 186 182 187 555 19 48 163 390 678 211 883 217 448 1 114 297 965 122 608 127 586 667 452 158 255 1075 465 246 274 23 741 597 65 232 227 973 143 6 149 183 74 218 1035 1051 325 876 62 782 745 920 40 511 34 250 1055 645 64 216 961 654 919 626 244 628 1022 369 478 75
//
include: 0.00493
page: -0.480306
dist: 6.000000000006E-6
evt: 0.274953
reg: 0.03092
cat: 0.255635
lab: 0.068738
month: -0.172838