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-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')AND (SELECT COUNT(evenements_to_evenements_categories.id) FROM evenements_to_evenements_categories, evenements_categories WHERE evenements_categories_id=evenements_categories.id AND evenements_categories.slug='musique' AND evenements_id=evenements.id) > 0 ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC19 114 691 541 456 69 692 0 971 787 398 322 122 53 503 211 249 126 396 858 962 63 208 254 809 230 180 85 73 629 90 422 207 259 340 199 927 68 834 863 580 828 799 698 713 654 419 228 237 61 977 //

include: 0.002301

page: -0.575355

dist: 5.0000000000328E-6

evt: 0.261031

reg: -0.841802

cat: 0.172273

lab: 0.040907

month: 0.290933