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-01','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-01' OR end_date>='2024-05-01 06:00:00') ORDER BY ordre_expo ASC, ordre_tri ASC, start_date, event_title ASC512 265 945 11 186 182 65 0 652 667 903 68 272 390 558 323 678 84 33 526 232 254 541 309 419 322 747 228 207 184 153 19 957 452 951 973 210 49 396 255 690 456 321 172 687 274 976 895 250 66 208 703 311 720 992 593 883 422 784 196 114 698 962 69 213 970 515 991 670 122 132 654 974 821 369 372 943 48 198 607 340 986 1 264 872 180 218 220 528 391 755 807 202 158 575 555 187 378 581 191 365 938 215 448 597 465 185 828 12 742 717 693 71 194 655 451 125 793 245 449 692 983 361 596 259 95 570 183 737 227 249 518 41 664 111 23 617 975 149 6 2 544 246 919 90 376 561 639 400 882 370 971 787 565 818 53 503 211 126 809 73 629 498 199 216 927 46 863 580 932 799 40 20 237 61 244 876 74 745 64 62 645 952 632 920 511 3 193 478 519 457 533 195 812 75 614 247 58
//
include: 0.004459
page: -0.868759
dist: 1.6999999999934E-5
evt: -0.77245
reg: 0.007253
cat: 0.197739
lab: 0.046075
month: -0.127872
