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='2025-06-03','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-06-01' AND DATE_ADD('2025-06-30', INTERVAL 1 DAY) OR end_date BETWEEN '2025-06-01' AND DATE_ADD('2025-06-30', INTERVAL 1 DAY) OR (end_date>='2025-06-30' AND start_date<='2025-06-30') ) AND (start_date>='2025-06-03' OR end_date>='2025-06-03 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 ASC265 1075 699 569 655 1010 541 437 827 1048 297 95 70 198 292 40 793 90 0 372 233 962 472 810 45 703 565 370 1110 232 599 788 199 760 654 67 586 64 848 714 816 629 809 1045 149 961 246 745 250 353 457 498 555 511 644 632 //

include: 0.003831

page: -0.227265

dist: 4.000000000004E-6

evt: 0.30615

reg: 0.160767

cat: -0.710543

lab: 0.069065

month: -0.159578