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-22','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-22' OR end_date>='2024-05-22 06:00:00')AND (SELECT COUNT(evenements_to_evenements_labels.id) FROM evenements_to_evenements_labels, evenements_labels WHERE evenements_labels_id=evenements_labels.id AND evenements_labels.slug='artistes-regionaux' AND evenements_id=evenements.id) > 0 ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC372 297 691 882 541 370 655 593 249 692 787 565 53 503 211 126 858 793 809 264 353 232 90 498 927 339 932 198 654 189 962 149 64 62 920 40 511 519 457 250 95 745 429 561 915 993 0 58 //

include: 0.0046390000000001

page: -0.531107

dist: 5.0000000000328E-6

evt: 0.219007

reg: 0.098092

cat: -0.842409

lab: 0.038701

month: 0.739179