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') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC193 66 265 274 69 821 398 172 95 68 1075 114 255 11 183 213 1 699 932 184 661 65 194 569 512 452 655 73 390 737 1010 541 33 438 254 437 211 827 997 12 1048 297 741 70 199 517 1087 228 343 439 654 198 747 292 40 6 478 61 419 396 125 970 544 793 440 1092 617 90 0 372 230 233 264 19 693 962 472 360 182 863 245 185 186 810 187 207 342 323 49 216 301 45 703 565 10 1012 62 1059 370 1110 232 63 656 202 48 599 122 365 788 678 448 158 687 406 760 67 218 20 667 816 580 586 64 272 258 143 927 882 1117 848 2 714 743 629 720 823 104 1116 809 1045 834 149 975 74 1035 325 876 361 34 961 919 628 1022 246 3 205 745 250 353 457 498 195 516 555 511 644 632 111 261 75 //

include: 0.004211

page: -0.379924

dist: 4.000000000004E-6

evt: 0.287698

reg: 0.08116

cat: 0.270204

lab: 0.06415

month: 0.616004