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-07-27','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-07-01' AND DATE_ADD('2024-07-31', INTERVAL 1 DAY) OR end_date BETWEEN '2024-07-01' AND DATE_ADD('2024-07-31', INTERVAL 1 DAY) OR (end_date>='2024-07-31' AND start_date<='2024-07-31') ) AND (start_date>='2024-07-27' OR end_date>='2024-07-27 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC512 265 182 1 274 472 588 821 0 372 541 545 481 1002 478 245 186 187 820 305 815 828 962 555 143 65 6 149 244 975 876 213 183 246 66 74 361 218 202 919 193 11 974 195 920 34 626 301 205 57 980 745 1006 64 1016 457 62 92 48 353 311 40 95 644 645 511 544 812 75 614 184 247 58
//
include: 0.00283
page: -0.114076
dist: 8.9999999999812E-6
evt: 0.275311
reg: 0.007404
cat: 0.2324
lab: 0.046104
month: -0.179062
