culturoscoPe

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-05','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-05-05' OR end_date>='2024-05-05 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC512 265 65 6 149 244 975 876 213 182 183 216 187 66 186 74 745 245 737 361 64 62 218 202 274 255 372 919 952 11 196 632 920 12 40 498 528 511 272 565 3 193 555 654 1 478 519 0 544 812 75 614 184 247 58 //

include: 0.00395

page: -0.855918

dist: 6.9999999999792E-6

evt: -0.759632

reg: 0.027264

cat: 0.184426

lab: 0.047337

month: -0.293232