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-18','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-06-01' AND DATE_ADD('2024-06-30', INTERVAL 1 DAY) OR end_date BETWEEN '2024-06-01' AND DATE_ADD('2024-06-30', INTERVAL 1 DAY) OR (end_date>='2024-06-30' AND start_date<='2024-06-30') ) AND (start_date>='2024-05-18' OR end_date>='2024-05-18 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC512 265 182 994 799 69 33 970 114 793 208 544 422 259 325 670 0 617 202 125 875 232 821 917 228 808 890 426 903 187 593 626 452 692 948 264 655 209 563 189 858 207 396 393 977 254 370 218 1 64 390 220 391 755 184 365 376 448 297 11 185 65 699 570 213 172 882 323 541 747 122 49 158 969 183 456 205 336 95 198 12 237 419 515 19 449 212 66 538 693 210 20 340 687 353 974 788 478 709 274 255 569 68 754 181 301 727 131 565 10 63 753 720 629 599 378 932 351 111 656 652 980 199 760 233 703 120 211 242 258 138 143 48 863 62 186 104 6 149 244 975 876 216 74 245 361 372 919 196 511 193 654 519 3 457 250 745 195 498 561 915 993 952 632 261 57 812 75 614 247 58 //

include: 0.002524

page: -0.110599

dist: 5.000000000005E-6

evt: 0.259581

reg: 0.032912

cat: 0.162818

lab: 0.040552

month: 0.018736