1
0.28 ms
SELECT idperson FROM persons WHERE url_clean = 'Jean-Luc-Lagarce'
SELECT idperson FROM persons WHERE url_clean = 'Jean-Luc-Lagarce' ;
Copy
2
0.56 ms
SELECT p0_ . idperson AS idperson_0 , p0_ . lastname AS lastname_1 , p0_ . firstname AS firstname_2 , p0_ . sexe AS sexe_3 , p0_ . datestart AS datestart_4 , p0_ . dateend AS dateend_5 , p0_ . language AS language_6 , p0_ . language2 AS language2_7 , p0_ . email AS email_8 , p0_ . comment AS comment_9 , p0_ . cname AS cname_10 , p0_ . caddress AS caddress_11 , p0_ . czip AS czip_12 , p0_ . ccity AS ccity_13 , p0_ . ccountry AS ccountry_14 , p0_ . cphone AS cphone_15 , p0_ . cfax AS cfax_16 , p0_ . cemail AS cemail_17 , p0_ . cmobile AS cmobile_18 , p0_ . url_redirect AS url_redirect_19 , p0_ . url_clean AS url_clean_20 , p0_ . url_mav AS url_mav_21 , p0_ . dateupdate AS dateupdate_22 , p0_ . dateinsert AS dateinsert_23 , p0_ . publish AS publish_24 , p0_ . valid AS valid_25 , p0_ . idcorvin AS idcorvin_26 , p0_ . country AS country_27 , p0_ . idrole AS idrole_28 , p0_ . idextranetuser AS idextranetuser_29 FROM persons p0_ WHERE p0_ . idperson = ?
SELECT p0_ . idperson AS idperson_0 , p0_ . lastname AS lastname_1 , p0_ . firstname AS firstname_2 , p0_ . sexe AS sexe_3 , p0_ . datestart AS datestart_4 , p0_ . dateend AS dateend_5 , p0_ . language AS language_6 , p0_ . language2 AS language2_7 , p0_ . email AS email_8 , p0_ . comment AS comment_9 , p0_ . cname AS cname_10 , p0_ . caddress AS caddress_11 , p0_ . czip AS czip_12 , p0_ . ccity AS ccity_13 , p0_ . ccountry AS ccountry_14 , p0_ . cphone AS cphone_15 , p0_ . cfax AS cfax_16 , p0_ . cemail AS cemail_17 , p0_ . cmobile AS cmobile_18 , p0_ . url_redirect AS url_redirect_19 , p0_ . url_clean AS url_clean_20 , p0_ . url_mav AS url_mav_21 , p0_ . dateupdate AS dateupdate_22 , p0_ . dateinsert AS dateinsert_23 , p0_ . publish AS publish_24 , p0_ . valid AS valid_25 , p0_ . idcorvin AS idcorvin_26 , p0_ . country AS country_27 , p0_ . idrole AS idrole_28 , p0_ . idextranetuser AS idextranetuser_29 FROM persons p0_ WHERE p0_ . idperson = 3 ;
Copy
3
0.72 ms
SELECT COUNT (DISTINCT (t . idtext ))
FROM text_author ta , texts t
WHERE t . idtext = ta . idtext AND t . textfictif = 0
AND ta . idperson = 3 AND t . publish = 1 AND t . type IN (0 , 2 )
SELECT COUNT (DISTINCT (t . idtext ))
FROM text_author ta , texts t
WHERE t . idtext = ta . idtext AND t . textfictif = 0
AND ta . idperson = 3 AND t . publish = 1 AND t . type IN (0 , 2 ) ;
Copy
4
0.25 ms
SELECT COUNT (DISTINCT (tt . idtext )) as total
FROM text_translator tt , texts t
WHERE 1
AND t . idtext = tt . idtext
AND t . textfictif = 0
AND tt . idperson = 3 AND t . publish = 1
SELECT COUNT (DISTINCT (tt . idtext )) as total
FROM text_translator tt , texts t
WHERE 1
AND t . idtext = tt . idtext
AND t . textfictif = 0
AND tt . idperson = 3 AND t . publish = 1 ;
Copy
5
0.42 ms
SELECT COUNT (DISTINCT (sp . idspectacle )) as total
FROM spectacle_person sp , spectacles s
WHERE 1
AND sp . idspectacle = s . idspectacle
AND sp . idperson = 3
AND sp . idrole = 1 AND s . publish = 1
SELECT COUNT (DISTINCT (sp . idspectacle )) as total
FROM spectacle_person sp , spectacles s
WHERE 1
AND sp . idspectacle = s . idspectacle
AND sp . idperson = 3
AND sp . idrole = 1 AND s . publish = 1 ;
Copy
6
0.04 ms
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
7
0.03 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
8
0.40 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j2 . idoffice , j2 . date_start , j2 . date_end , j3 . idperson FROM theatreok_dev . contacts j1 , theatreok_dev . contact_person j2 , theatreok_dev . persons j3
WHERE j3 . idperson = j2 . idperson
AND j1 . idcontact = j2 . idcontact
AND j3 . idperson = 3 AND j2 . idoffice = 1
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j2 . idoffice , j2 . date_start , j2 . date_end , j3 . idperson FROM theatreok_dev . contacts j1 , theatreok_dev . contact_person j2 , theatreok_dev . persons j3
WHERE j3 . idperson = j2 . idperson
AND j1 . idcontact = j2 . idcontact
AND j3 . idperson = 3 AND j2 . idoffice = 1 ;
Copy
9
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotxt' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotxt' ))) AND persons = 1 ;
Copy
10
6.01 ms
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '3'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_biotxt' ))) ORDER BY c . `range` , c . idcontent
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '3'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_biotxt' ))) ORDER BY c . `range` , c . idcontent ;
Copy
11
0.34 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1 ;
Copy
12
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_photo_person' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_photo_person' ))) AND persons = 1 ;
Copy
13
1.26 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '3'
AND of . object = 'persons'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_photo_person' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '3'
AND of . object = 'persons'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_photo_person' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
14
0.49 ms
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (3 )
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (3 ) ;
Copy
15
0.64 ms
SELECT tad . `idtextadaptation`
FROM text_adaptation tad
JOIN texts t ON t . `idtext` = tad . `idtext`
JOIN text_author ta ON t . `idtext` = ta . `idtext`
WHERE ta . `idperson` IN (3 )
SELECT tad . `idtextadaptation`
FROM text_adaptation tad
JOIN texts t ON t . `idtext` = tad . `idtext`
JOIN text_author ta ON t . `idtext` = ta . `idtext`
WHERE ta . `idperson` IN (3 ) ;
Copy
16
0.31 ms
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (3 )
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (3 ) ;
Copy
17
0.72 ms
SELECT tt . `idtexttraduction`
FROM text_traduction tt
JOIN text_author ta ON tt . `idtext` = ta . `idtext`
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (3 )
SELECT tt . `idtexttraduction`
FROM text_traduction tt
JOIN text_author ta ON tt . `idtext` = ta . `idtext`
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (3 ) ;
Copy
18
0.93 ms
SELECT DISTINCT (multimedias . idmultimedia )
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND object_multimedia . `idrole` = 25 AND multimedias . `publish` = 1 AND object_multimedia . `object` = 'persons' AND object_multimedia . `idobject` = 3 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . dateinsert
DESC
LIMIT 0 , 10
SELECT DISTINCT (multimedias . idmultimedia )
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND object_multimedia . `idrole` = 25 AND multimedias . `publish` = 1 AND object_multimedia . `object` = 'persons' AND object_multimedia . `idobject` = 3 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
19
32.78 ms
SELECT COUNT (DISTINCT (ct . `idcontent` ))
FROM spectacles s
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND cc . `idclassification` = 101
AND s . `idspectacle` IN (4 , 5 , 6 , 7 , 8 , 9 , 10 , 12 , 13 , 16 , 17 , 18 , 22 , 23 , 24 , 25 , 27 , 28 , 31 , 33 , 43 , 44 , 48 , 49 , 51 , 72 , 73 , 75 , 76 , 78 , 79 , 87 , 89 , 98 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 115 , 116 , 118 , 124 , 132 , 142 , 143 , 146 , 218 , 243 , 253 , 255 , 257 , 263 , 264 , 265 , 266 , 267 , 268 , 269 , 271 , 273 , 274 , 277 , 278 , 279 , 282 , 368 , 378 , 382 , 385 , 386 , 390 , 391 , 392 , 393 , 394 , 395 , 396 , 397 , 398 , 400 , 401 , 402 , 403 , 423 , 443 , 452 , 455 , 457 , 460 , 463 , 464 , 465 , 466 , 467 , 468 , 469 , 470 , 471 , 472 , 473 , 475 , 476 , 477 , 483 , 567 , 568 , 569 , 572 , 573 , 584 , 585 , 586 , 588 , 589 , 594 , 595 , 699 , 701 , 702 , 703 , 705 , 706 , 707 , 709 , 710 , 712 , 737 , 738 , 741 , 746 , 754 , 755 , 756 , 757 , 758 , 759 , 760 , 763 , 765 , 778 , 780 , 795 , 825 , 828 , 885 , 890 , 891 , 895 , 897 , 902 , 933 , 946 , 953 , 957 , 981 , 982 , 983 , 984 , 987 , 988 , 989 , 995 , 1001 , 1003 , 1008 , 1011 , 1014 , 1015 , 1020 , 1022 , 1028 , 1168 , 1170 , 1181 , 1203 , 1222 , 1228 , 1229 , 1230 , 1267 , 1268 , 1275 , 1276 , 1277 , 1278 , 1280 , 1281 , 1283 , 1294 , 1305 , 1306 , 1307 , 1311 , 1312 , 1317 , 1338 , 1340 , 1341 , 1342 , 1343 , 1344 , 1345 , 1349 , 1350 , 1352 , 1353 , 1354 , 1356 , 1361 , 1451 , 1460 , 1543 , 1580 , 1654 , 1690 , 1699 , 1724 , 1744 , 1745 , 1747 , 1868 , 1928 , 1929 , 1990 , 2096 , 2129 , 2146 , 2147 , 2149 , 2152 , 2153 , 2159 , 2160 , 2163 , 2164 , 2166 , 2167 , 2168 , 2169 , 2171 , 2215 , 2216 , 2217 , 2218 , 2220 , 2255 , 2315 , 2445 , 2446 , 2447 , 2466 , 2482 , 2547 , 2553 , 2554 , 2560 , 2573 , 2574 , 2616 , 2650 , 2651 , 2653 , 2654 , 2662 , 2693 , 2694 , 2695 , 2709 , 2712 , 2719 , 2720 , 2721 , 2737 , 2744 , 2748 , 2750 , 2757 , 2781 , 2785 , 2786 , 2788 , 2796 , 2797 , 2803 , 2804 , 2813 , 2814 , 2824 , 2831 , 2832 , 2833 , 2834 , 2840 , 2856 , 2874 , 2875 , 2887 , 2891 , 2892 , 2895 , 2900 , 2901 , 2902 , 2912 , 2913 , 2969 , 2971 , 2976 , 2983 , 3036 , 3048 , 3089 , 3094 , 3095 , 3097 , 3098 , 3117 , 3118 , 3119 , 3126 , 3217 , 3224 , 3226 , 3234 , 3259 , 3410 , 3412 , 3445 , 3447 , 3451 , 3491 , 3492 , 3493 , 3495 , 3501 , 3518 , 3542 , 3583 , 3587 , 3596 , 3628 , 3636 , 3637 , 3731 , 3760 , 3762 , 3821 , 3834 , 3836 , 3852 , 3944 , 4000 , 4008 , 4009 , 4014 , 4027 , 4031 , 4032 , 4056 , 4075 , 4090 , 4092 , 4101 , 4104 , 4111 , 4123 , 4124 , 4132 , 4133 , 4134 , 4138 , 4168 , 4194 , 4229 , 4367 , 4368 , 4382 , 4429 , 4478 , 4559 , 4570 , 4571 , 4572 , 4592 , 4627 , 4629 , 4646 , 4660 , 4671 , 4690 , 4718 , 4749 , 4750 , 4753 , 4757 , 4774 , 4778 , 4795 , 4797 , 4799 , 4800 , 4803 , 4806 , 4811 , 4814 , 4925 , 4947 , 4984 , 5015 , 5020 , 5035 , 5048 , 5050 , 5052 , 5091 , 5106 , 5129 , 5131 , 5161 , 5162 , 5163 , 5199 , 5207 , 5208 , 5399 , 5401 , 5549 , 5586 , 5646 , 5757 , 5785 , 5820 , 5834 , 6137 , 6482 , 6649 , 6655 , 6808 , 7858 , 8145 , 8340 , 8431 , 8433 , 8779 , 8986 , 9106 , 9708 , 9748 , 10741 , 11286 , 11342 , 11496 , 12996 , 12997 , 13022 , 13358 , 13451 , 13845 , 14006 , 14559 , 15675 , 16644 , 16813 , 16859 , 16998 , 17408 , 18099 , 18473 , 19138 , 19168 , 19216 , 19483 , 19613 , 19638 , 19793 , 20030 , 20108 , 20273 , 20323 , 20533 , 20666 , 20943 , 20981 , 21124 , 21145 , 22067 , 22476 , 22479 , 22515 , 22676 , 22911 , 22914 , 23156 , 23240 , 23307 , 23500 , 23596 , 23609 , 23666 , 23671 , 23997 , 24799 , 24800 , 25582 , 25788 , 26092 , 26404 , 26539 , 27069 , 27082 , 27299 , 27635 , 28700 , 28857 , 29335 , 29384 , 29429 , 29824 , 30283 , 30324 , 30448 , 30808 , 30837 , 31709 , 31749 , 31773 , 31883 , 31903 , 32051 , 33275 , 33287 , 33589 , 33662 , 34647 , 35581 , 35582 , 35720 , 35740 , 36130 , 36335 , 36541 , 36569 , 36611 , 36875 , 36933 , 37020 , 37091 , 37310 , 37311 , 37312 , 37313 )
SELECT
COUNT (
DISTINCT (ct . `idcontent` )
)
FROM
spectacles s
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE
s . `publish` = 1
AND s . `valid` = 1
AND ct . `publish` = 1
AND ct . `valid` = 1
AND cc . `idclassification` = 101
AND s . `idspectacle` IN (
4 ,
5 ,
6 ,
7 ,
8 ,
9 ,
10 ,
12 ,
13 ,
16 ,
17 ,
18 ,
22 ,
23 ,
24 ,
25 ,
27 ,
28 ,
31 ,
33 ,
43 ,
44 ,
48 ,
49 ,
51 ,
72 ,
73 ,
75 ,
76 ,
78 ,
79 ,
87 ,
89 ,
98 ,
105 ,
106 ,
107 ,
108 ,
109 ,
110 ,
111 ,
115 ,
116 ,
118 ,
124 ,
132 ,
142 ,
143 ,
146 ,
218 ,
243 ,
253 ,
255 ,
257 ,
263 ,
264 ,
265 ,
266 ,
267 ,
268 ,
269 ,
271 ,
273 ,
274 ,
277 ,
278 ,
279 ,
282 ,
368 ,
378 ,
382 ,
385 ,
386 ,
390 ,
391 ,
392 ,
393 ,
394 ,
395 ,
396 ,
397 ,
398 ,
400 ,
401 ,
402 ,
403 ,
423 ,
443 ,
452 ,
455 ,
457 ,
460 ,
463 ,
464 ,
465 ,
466 ,
467 ,
468 ,
469 ,
470 ,
471 ,
472 ,
473 ,
475 ,
476 ,
477 ,
483 ,
567 ,
568 ,
569 ,
572 ,
573 ,
584 ,
585 ,
586 ,
588 ,
589 ,
594 ,
595 ,
699 ,
701 ,
702 ,
703 ,
705 ,
706 ,
707 ,
709 ,
710 ,
712 ,
737 ,
738 ,
741 ,
746 ,
754 ,
755 ,
756 ,
757 ,
758 ,
759 ,
760 ,
763 ,
765 ,
778 ,
780 ,
795 ,
825 ,
828 ,
885 ,
890 ,
891 ,
895 ,
897 ,
902 ,
933 ,
946 ,
953 ,
957 ,
981 ,
982 ,
983 ,
984 ,
987 ,
988 ,
989 ,
995 ,
1001 ,
1003 ,
1008 ,
1011 ,
1014 ,
1015 ,
1020 ,
1022 ,
1028 ,
1168 ,
1170 ,
1181 ,
1203 ,
1222 ,
1228 ,
1229 ,
1230 ,
1267 ,
1268 ,
1275 ,
1276 ,
1277 ,
1278 ,
1280 ,
1281 ,
1283 ,
1294 ,
1305 ,
1306 ,
1307 ,
1311 ,
1312 ,
1317 ,
1338 ,
1340 ,
1341 ,
1342 ,
1343 ,
1344 ,
1345 ,
1349 ,
1350 ,
1352 ,
1353 ,
1354 ,
1356 ,
1361 ,
1451 ,
1460 ,
1543 ,
1580 ,
1654 ,
1690 ,
1699 ,
1724 ,
1744 ,
1745 ,
1747 ,
1868 ,
1928 ,
1929 ,
1990 ,
2096 ,
2129 ,
2146 ,
2147 ,
2149 ,
2152 ,
2153 ,
2159 ,
2160 ,
2163 ,
2164 ,
2166 ,
2167 ,
2168 ,
2169 ,
2171 ,
2215 ,
2216 ,
2217 ,
2218 ,
2220 ,
2255 ,
2315 ,
2445 ,
2446 ,
2447 ,
2466 ,
2482 ,
2547 ,
2553 ,
2554 ,
2560 ,
2573 ,
2574 ,
2616 ,
2650 ,
2651 ,
2653 ,
2654 ,
2662 ,
2693 ,
2694 ,
2695 ,
2709 ,
2712 ,
2719 ,
2720 ,
2721 ,
2737 ,
2744 ,
2748 ,
2750 ,
2757 ,
2781 ,
2785 ,
2786 ,
2788 ,
2796 ,
2797 ,
2803 ,
2804 ,
2813 ,
2814 ,
2824 ,
2831 ,
2832 ,
2833 ,
2834 ,
2840 ,
2856 ,
2874 ,
2875 ,
2887 ,
2891 ,
2892 ,
2895 ,
2900 ,
2901 ,
2902 ,
2912 ,
2913 ,
2969 ,
2971 ,
2976 ,
2983 ,
3036 ,
3048 ,
3089 ,
3094 ,
3095 ,
3097 ,
3098 ,
3117 ,
3118 ,
3119 ,
3126 ,
3217 ,
3224 ,
3226 ,
3234 ,
3259 ,
3410 ,
3412 ,
3445 ,
3447 ,
3451 ,
3491 ,
3492 ,
3493 ,
3495 ,
3501 ,
3518 ,
3542 ,
3583 ,
3587 ,
3596 ,
3628 ,
3636 ,
3637 ,
3731 ,
3760 ,
3762 ,
3821 ,
3834 ,
3836 ,
3852 ,
3944 ,
4000 ,
4008 ,
4009 ,
4014 ,
4027 ,
4031 ,
4032 ,
4056 ,
4075 ,
4090 ,
4092 ,
4101 ,
4104 ,
4111 ,
4123 ,
4124 ,
4132 ,
4133 ,
4134 ,
4138 ,
4168 ,
4194 ,
4229 ,
4367 ,
4368 ,
4382 ,
4429 ,
4478 ,
4559 ,
4570 ,
4571 ,
4572 ,
4592 ,
4627 ,
4629 ,
4646 ,
4660 ,
4671 ,
4690 ,
4718 ,
4749 ,
4750 ,
4753 ,
4757 ,
4774 ,
4778 ,
4795 ,
4797 ,
4799 ,
4800 ,
4803 ,
4806 ,
4811 ,
4814 ,
4925 ,
4947 ,
4984 ,
5015 ,
5020 ,
5035 ,
5048 ,
5050 ,
5052 ,
5091 ,
5106 ,
5129 ,
5131 ,
5161 ,
5162 ,
5163 ,
5199 ,
5207 ,
5208 ,
5399 ,
5401 ,
5549 ,
5586 ,
5646 ,
5757 ,
5785 ,
5820 ,
5834 ,
6137 ,
6482 ,
6649 ,
6655 ,
6808 ,
7858 ,
8145 ,
8340 ,
8431 ,
8433 ,
8779 ,
8986 ,
9106 ,
9708 ,
9748 ,
10741 ,
11286 ,
11342 ,
11496 ,
12996 ,
12997 ,
13022 ,
13358 ,
13451 ,
13845 ,
14006 ,
14559 ,
15675 ,
16644 ,
16813 ,
16859 ,
16998 ,
17408 ,
18099 ,
18473 ,
19138 ,
19168 ,
19216 ,
19483 ,
19613 ,
19638 ,
19793 ,
20030 ,
20108 ,
20273 ,
20323 ,
20533 ,
20666 ,
20943 ,
20981 ,
21124 ,
21145 ,
22067 ,
22476 ,
22479 ,
22515 ,
22676 ,
22911 ,
22914 ,
23156 ,
23240 ,
23307 ,
23500 ,
23596 ,
23609 ,
23666 ,
23671 ,
23997 ,
24799 ,
24800 ,
25582 ,
25788 ,
26092 ,
26404 ,
26539 ,
27069 ,
27082 ,
27299 ,
27635 ,
28700 ,
28857 ,
29335 ,
29384 ,
29429 ,
29824 ,
30283 ,
30324 ,
30448 ,
30808 ,
30837 ,
31709 ,
31749 ,
31773 ,
31883 ,
31903 ,
32051 ,
33275 ,
33287 ,
33589 ,
33662 ,
34647 ,
35581 ,
35582 ,
35720 ,
35740 ,
36130 ,
36335 ,
36541 ,
36569 ,
36611 ,
36875 ,
36933 ,
37020 ,
37091 ,
37310 ,
37311 ,
37312 ,
37313
)
Copy
SELECT COUNT (DISTINCT (ct . `idcontent` ))
FROM spectacles s
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND cc . `idclassification` = 101
AND s . `idspectacle` IN (4 , 5 , 6 , 7 , 8 , 9 , 10 , 12 , 13 , 16 , 17 , 18 , 22 , 23 , 24 , 25 , 27 , 28 , 31 , 33 , 43 , 44 , 48 , 49 , 51 , 72 , 73 , 75 , 76 , 78 , 79 , 87 , 89 , 98 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 115 , 116 , 118 , 124 , 132 , 142 , 143 , 146 , 218 , 243 , 253 , 255 , 257 , 263 , 264 , 265 , 266 , 267 , 268 , 269 , 271 , 273 , 274 , 277 , 278 , 279 , 282 , 368 , 378 , 382 , 385 , 386 , 390 , 391 , 392 , 393 , 394 , 395 , 396 , 397 , 398 , 400 , 401 , 402 , 403 , 423 , 443 , 452 , 455 , 457 , 460 , 463 , 464 , 465 , 466 , 467 , 468 , 469 , 470 , 471 , 472 , 473 , 475 , 476 , 477 , 483 , 567 , 568 , 569 , 572 , 573 , 584 , 585 , 586 , 588 , 589 , 594 , 595 , 699 , 701 , 702 , 703 , 705 , 706 , 707 , 709 , 710 , 712 , 737 , 738 , 741 , 746 , 754 , 755 , 756 , 757 , 758 , 759 , 760 , 763 , 765 , 778 , 780 , 795 , 825 , 828 , 885 , 890 , 891 , 895 , 897 , 902 , 933 , 946 , 953 , 957 , 981 , 982 , 983 , 984 , 987 , 988 , 989 , 995 , 1001 , 1003 , 1008 , 1011 , 1014 , 1015 , 1020 , 1022 , 1028 , 1168 , 1170 , 1181 , 1203 , 1222 , 1228 , 1229 , 1230 , 1267 , 1268 , 1275 , 1276 , 1277 , 1278 , 1280 , 1281 , 1283 , 1294 , 1305 , 1306 , 1307 , 1311 , 1312 , 1317 , 1338 , 1340 , 1341 , 1342 , 1343 , 1344 , 1345 , 1349 , 1350 , 1352 , 1353 , 1354 , 1356 , 1361 , 1451 , 1460 , 1543 , 1580 , 1654 , 1690 , 1699 , 1724 , 1744 , 1745 , 1747 , 1868 , 1928 , 1929 , 1990 , 2096 , 2129 , 2146 , 2147 , 2149 , 2152 , 2153 , 2159 , 2160 , 2163 , 2164 , 2166 , 2167 , 2168 , 2169 , 2171 , 2215 , 2216 , 2217 , 2218 , 2220 , 2255 , 2315 , 2445 , 2446 , 2447 , 2466 , 2482 , 2547 , 2553 , 2554 , 2560 , 2573 , 2574 , 2616 , 2650 , 2651 , 2653 , 2654 , 2662 , 2693 , 2694 , 2695 , 2709 , 2712 , 2719 , 2720 , 2721 , 2737 , 2744 , 2748 , 2750 , 2757 , 2781 , 2785 , 2786 , 2788 , 2796 , 2797 , 2803 , 2804 , 2813 , 2814 , 2824 , 2831 , 2832 , 2833 , 2834 , 2840 , 2856 , 2874 , 2875 , 2887 , 2891 , 2892 , 2895 , 2900 , 2901 , 2902 , 2912 , 2913 , 2969 , 2971 , 2976 , 2983 , 3036 , 3048 , 3089 , 3094 , 3095 , 3097 , 3098 , 3117 , 3118 , 3119 , 3126 , 3217 , 3224 , 3226 , 3234 , 3259 , 3410 , 3412 , 3445 , 3447 , 3451 , 3491 , 3492 , 3493 , 3495 , 3501 , 3518 , 3542 , 3583 , 3587 , 3596 , 3628 , 3636 , 3637 , 3731 , 3760 , 3762 , 3821 , 3834 , 3836 , 3852 , 3944 , 4000 , 4008 , 4009 , 4014 , 4027 , 4031 , 4032 , 4056 , 4075 , 4090 , 4092 , 4101 , 4104 , 4111 , 4123 , 4124 , 4132 , 4133 , 4134 , 4138 , 4168 , 4194 , 4229 , 4367 , 4368 , 4382 , 4429 , 4478 , 4559 , 4570 , 4571 , 4572 , 4592 , 4627 , 4629 , 4646 , 4660 , 4671 , 4690 , 4718 , 4749 , 4750 , 4753 , 4757 , 4774 , 4778 , 4795 , 4797 , 4799 , 4800 , 4803 , 4806 , 4811 , 4814 , 4925 , 4947 , 4984 , 5015 , 5020 , 5035 , 5048 , 5050 , 5052 , 5091 , 5106 , 5129 , 5131 , 5161 , 5162 , 5163 , 5199 , 5207 , 5208 , 5399 , 5401 , 5549 , 5586 , 5646 , 5757 , 5785 , 5820 , 5834 , 6137 , 6482 , 6649 , 6655 , 6808 , 7858 , 8145 , 8340 , 8431 , 8433 , 8779 , 8986 , 9106 , 9708 , 9748 , 10741 , 11286 , 11342 , 11496 , 12996 , 12997 , 13022 , 13358 , 13451 , 13845 , 14006 , 14559 , 15675 , 16644 , 16813 , 16859 , 16998 , 17408 , 18099 , 18473 , 19138 , 19168 , 19216 , 19483 , 19613 , 19638 , 19793 , 20030 , 20108 , 20273 , 20323 , 20533 , 20666 , 20943 , 20981 , 21124 , 21145 , 22067 , 22476 , 22479 , 22515 , 22676 , 22911 , 22914 , 23156 , 23240 , 23307 , 23500 , 23596 , 23609 , 23666 , 23671 , 23997 , 24799 , 24800 , 25582 , 25788 , 26092 , 26404 , 26539 , 27069 , 27082 , 27299 , 27635 , 28700 , 28857 , 29335 , 29384 , 29429 , 29824 , 30283 , 30324 , 30448 , 30808 , 30837 , 31709 , 31749 , 31773 , 31883 , 31903 , 32051 , 33275 , 33287 , 33589 , 33662 , 34647 , 35581 , 35582 , 35720 , 35740 , 36130 , 36335 , 36541 , 36569 , 36611 , 36875 , 36933 , 37020 , 37091 , 37310 , 37311 , 37312 , 37313 ) ;
Copy
20
0.29 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_article' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_article' ))) AND persons = 1 ;
Copy
21
7.70 ms
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '3'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '3'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent ;
Copy
22
0.33 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1324
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1324 ;
Copy
23
3.00 ms
SELECT c . title , c . idcontent , c . link , c . writer_group , c . writer , c . date_article , c . writer_group_url , c . dateinsert ,
oc . idclassification as group_idclassification , cloc . classification as group_classification ,
c . is_link , c . deck , c . idextranetuser , c . display_media , c . language , cl . classification , cl . idclassification , e . login FROM contents c
LEFT JOIN extranetusers e ON c . idextranetuser = e . idextranetuser
, content_classification cc , classifications cl , object_content oc
LEFT JOIN classifications cloc ON oc . idclassification = cloc . idclassification WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND cc . idclassification = cl . idclassification
AND oc . object = 'persons' AND c . publish = 1 AND oc . idobject = 3 AND cl . classification = 'class_article' ORDER BY c . `range` , c . dateinsert ASC
SELECT c . title , c . idcontent , c . link , c . writer_group , c . writer , c . date_article , c . writer_group_url , c . dateinsert ,
oc . idclassification as group_idclassification , cloc . classification as group_classification ,
c . is_link , c . deck , c . idextranetuser , c . display_media , c . language , cl . classification , cl . idclassification , e . login FROM contents c
LEFT JOIN extranetusers e ON c . idextranetuser = e . idextranetuser
, content_classification cc , classifications cl , object_content oc
LEFT JOIN classifications cloc ON oc . idclassification = cloc . idclassification WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND cc . idclassification = cl . idclassification
AND oc . object = 'persons' AND c . publish = 1 AND oc . idobject = 3 AND cl . classification = 'class_article' ORDER BY c . `range` , c . dateinsert ASC ;
Copy
24
0.05 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1324
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1324 ;
Copy
25
1.36 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1324'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1324'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
26
0.05 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
27
0.04 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
28
0.12 ms
SELECT classification
FROM classifications
WHERE idclassification = 25
SELECT classification
FROM classifications
WHERE idclassification = 25 ;
Copy
29
0.52 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 5487
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 5487 ;
Copy
30
1.16 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '5487'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '5487'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
31
0.47 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 5488
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 5488 ;
Copy
32
1.08 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '5488'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '5488'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
33
0.30 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 5489
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 5489 ;
Copy
34
1.06 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '5489'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '5489'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
35
0.34 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1320
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1320 ;
Copy
36
1.18 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1320'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1320'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
37
0.04 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
38
0.58 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 15744
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 15744 ;
Copy
39
1.29 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '15744'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '15744'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
40
0.34 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89154
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89154 ;
Copy
41
1.15 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89154'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89154'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
42
0.31 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 84854
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 84854 ;
Copy
43
1.58 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '84854'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '84854'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
44
0.15 ms
SELECT classification
FROM classifications
WHERE idclassification = 166
SELECT classification
FROM classifications
WHERE idclassification = 166 ;
Copy
45
0.08 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
46
0.44 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89152
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89152 ;
Copy
47
1.07 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89152'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89152'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
48
0.30 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89275
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89275 ;
Copy
49
1.05 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89275'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89275'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
50
0.33 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 105153
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 105153 ;
Copy
51
1.11 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '105153'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '105153'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
52
0.30 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 84956
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 84956 ;
Copy
53
1.05 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '84956'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '84956'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
54
0.29 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89148
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89148 ;
Copy
55
1.04 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89148'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89148'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
56
0.31 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 2306
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 2306 ;
Copy
57
1.05 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '2306'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '2306'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
58
0.28 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 84955
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 84955 ;
Copy
59
1.03 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '84955'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '84955'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
60
0.34 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 25775
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 25775 ;
Copy
61
1.48 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '25775'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '25775'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
62
0.87 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89195
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89195 ;
Copy
63
3.12 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89195'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89195'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
64
0.76 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 106263
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 106263 ;
Copy
65
2.49 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '106263'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '106263'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
66
0.40 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1209
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1209 ;
Copy
67
1.64 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1209'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1209'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
68
0.05 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
69
0.51 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1969
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1969 ;
Copy
70
1.40 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1969'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1969'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
71
0.40 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1210
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1210 ;
Copy
72
1.43 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1210'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1210'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
73
0.06 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
74
0.28 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1979
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1979 ;
Copy
75
1.16 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1979'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1979'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
76
0.31 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1211
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1211 ;
Copy
77
1.58 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1211'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1211'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
78
0.05 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
79
0.64 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1975
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1975 ;
Copy
80
1.84 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1975'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1975'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
81
0.67 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1215
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1215 ;
Copy
82
2.52 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1215'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1215'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
83
0.06 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
84
0.92 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1218
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1218 ;
Copy
85
1.68 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1218'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1218'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
86
0.05 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
87
1.08 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1219
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1219 ;
Copy
88
3.22 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1219'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1219'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
89
0.10 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
90
0.71 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89155
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 89155 ;
Copy
91
3.10 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89155'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '89155'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
92
0.23 ms
SELECT fr FROM languages WHERE id = 'es'
SELECT fr FROM languages WHERE id = 'es' ;
Copy
93
0.28 ms
SELECT fr FROM languages WHERE id = 'en'
SELECT fr FROM languages WHERE id = 'en' ;
Copy
94
0.51 ms
SELECT fr FROM languages WHERE id = 'de'
SELECT fr FROM languages WHERE id = 'de' ;
Copy
95
0.08 ms
SELECT fr FROM languages WHERE id = 'pt'
SELECT fr FROM languages WHERE id = 'pt' ;
Copy
96
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
97
0.09 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
98
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
99
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
100
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
101
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
102
0.14 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
103
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
104
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
105
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
106
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
107
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
108
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
109
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
110
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
111
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
112
0.27 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
113
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
114
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
115
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
116
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
117
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
118
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
119
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
120
0.88 ms
SELECT c . * , cl . classification , c . `range` as `range` , e . idextranetuser , e . login
FROM contents c
LEFT JOIN extranetusers e ON c . idextranetuser = e . idextranetuser , classifications cl , content_classification cc
WHERE cc . idcontent = c . idcontent AND cc . idclassification = cl . idclassification
AND c . idcontent = 1215
SELECT c . * , cl . classification , c . `range` as `range` , e . idextranetuser , e . login
FROM contents c
LEFT JOIN extranetusers e ON c . idextranetuser = e . idextranetuser , classifications cl , content_classification cc
WHERE cc . idcontent = c . idcontent AND cc . idclassification = cl . idclassification
AND c . idcontent = 1215 ;
Copy
121
0.50 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url , j1 . type , j1 . city , j3 . idcontent FROM theatreok_dev . contacts j1 , theatreok_dev . content_contact j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idcontact = j2 . idcontact
AND j3 . idcontent = 1215
SELECT j1 . idcontact , j1 . organisation , j1 . url , j1 . type , j1 . city , j3 . idcontent FROM theatreok_dev . contacts j1 , theatreok_dev . content_contact j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idcontact = j2 . idcontact
AND j3 . idcontent = 1215 ;
Copy
122
0.55 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j3 . idcontent FROM theatreok_dev . persons j1 , theatreok_dev . content_person j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idperson = j2 . idperson
AND j3 . idcontent = 1215
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j3 . idcontent FROM theatreok_dev . persons j1 , theatreok_dev . content_person j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idperson = j2 . idperson
AND j3 . idcontent = 1215 ;
Copy
123
0.29 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1215
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1215 ;
Copy
124
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
125
0.13 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1215'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1215'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
126
0.07 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
127
0.40 ms
SELECT fichier FROM content_template dbo_tpl , templates tpl
WHERE dbo_tpl . idtemplate = tpl . idtemplate
AND dbo_tpl . idcontent = 1215
SELECT fichier FROM content_template dbo_tpl , templates tpl
WHERE dbo_tpl . idtemplate = tpl . idtemplate
AND dbo_tpl . idcontent = 1215 ;
Copy
128
0.16 ms
SELECT c . * , cl . classification , c . `range` as `range` , e . idextranetuser , e . login
FROM contents c
LEFT JOIN extranetusers e ON c . idextranetuser = e . idextranetuser , classifications cl , content_classification cc
WHERE cc . idcontent = c . idcontent AND cc . idclassification = cl . idclassification
AND c . idcontent = 1215
SELECT c . * , cl . classification , c . `range` as `range` , e . idextranetuser , e . login
FROM contents c
LEFT JOIN extranetusers e ON c . idextranetuser = e . idextranetuser , classifications cl , content_classification cc
WHERE cc . idcontent = c . idcontent AND cc . idclassification = cl . idclassification
AND c . idcontent = 1215 ;
Copy
129
0.21 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1215'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '1215'
AND of . object = 'contents'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND 1 AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
130
0.07 ms
SELECT classification
FROM classifications
WHERE idclassification = 22
SELECT classification
FROM classifications
WHERE idclassification = 22 ;
Copy
131
0.07 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url , j1 . type , j1 . city , j3 . idcontent FROM theatreok_dev . contacts j1 , theatreok_dev . content_contact j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idcontact = j2 . idcontact
AND j3 . idcontent = 1215
SELECT j1 . idcontact , j1 . organisation , j1 . url , j1 . type , j1 . city , j3 . idcontent FROM theatreok_dev . contacts j1 , theatreok_dev . content_contact j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idcontact = j2 . idcontact
AND j3 . idcontent = 1215 ;
Copy
132
0.06 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j3 . idcontent FROM theatreok_dev . persons j1 , theatreok_dev . content_person j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idperson = j2 . idperson
AND j3 . idcontent = 1215
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j3 . idcontent FROM theatreok_dev . persons j1 , theatreok_dev . content_person j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idperson = j2 . idperson
AND j3 . idcontent = 1215 ;
Copy
133
0.06 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1215
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 1215 ;
Copy
134
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
135
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_photo_person' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_photo_person' ))) AND persons = 1 ;
Copy
136
0.09 ms
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '3'
AND of . object = 'persons'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_photo_person' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '3'
AND of . object = 'persons'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_photo_person' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
137
6.16 ms
SELECT COUNT (DISTINCT (text_aide . idtextaide )) as total , text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (2 , 3 ) AND text_aide . `idtext` IN (4 , 6 , 10 , 12 , 86 , 87 , 283 , 402 , 460 , 465 , 466 , 471 , 476 , 481 , 482 , 560 , 561 , 564 , 565 , 566 , 567 , 568 , 569 , 570 , 571 , 607 , 609 , 610 , 3269 , 3287 , 3288 , 3289 , 3290 , 3291 , 3292 , 3293 , 3300 , 3335 , 3336 , 3346 , 3347 , 3348 , 3522 , 3525 , 3554 , 6179 , 7264 , 12026 , 15504 , 22248 , 33137 , 35742 , 36323 , 36344 , 36345 , 36348 , 36649 , 37560 , 3524 , 37623 , 37623 , 44073 , 21983 , 37623 , 9638 , 29164 , 37623 , 37623 , 37623 , 3670 , 37623 , 37623 , 4354 , 37623 , 3450 , 3523 , 9638 , 37623 , 3450 , 3523 , 9638 , 37623 , 12034 , 5 , 8 , 191 , 267 , 404 , 406 , 408 , 435 , 754 , 1134 , 1183 , 1620 , 1669 , 1699 , 1700 , 1957 , 2598 , 3270 , 3301 , 3373 , 3397 , 3432 , 3462 , 4372 , 4374 , 5995 , 6274 , 7188 , 25664 , 32552 , 45615 , 7 , 1359 , 1427 , 1429 , 3400 , 3555 , 4605 , 6062 , 6817 , 6860 , 13778 , 17926 , 25628 , 40922 , 33 , 265 , 336 , 400 , 457 , 1019 , 1021 , 1300 , 1697 , 3398 , 3399 , 3420 , 3421 , 3433 , 3586 , 3847 , 4263 , 5157 , 5308 , 6088 , 16755 , 266 , 453 , 1085 , 1186 , 1662 , 2648 , 2666 , 2968 , 3299 , 3401 , 3459 , 4415 , 4745 , 5998 , 6463 , 7296 , 7658 , 7725 , 8812 , 16775 , 22377 , 23415 , 25026 , 26277 , 32924 , 40923 , 44604 , 399 , 424 , 458 , 468 , 1785 , 1958 , 3374 , 3811 , 7206 , 268 , 1362 , 5250 , 5438 , 5575 , 5772 , 397 , 401 , 423 , 456 , 753 , 3302 , 3563 , 403 , 451 , 474 , 1670 , 1709 , 4371 , 5579 , 6803 , 461 , 1712 , 4001 , 4416 , 469 , 470 , 407 , 472 , 799 , 1492 , 1660 , 961 , 1326 , 1358 , 1710 , 3264 , 3411 , 5205 , 6061 , 8744 , 8813 , 40924 , 1927 , 1668 , 2481 , 3417 , 3423 , 3415 , 40925 , 40921 , 3271 , 3272 , 3428 , 13779 , 3422 , 3561 , 5510 , 3562 , 1928 , 2599 , 3830 , 5963 , 3416 , 3547 , 35741 ) AND aides . `idaide` = text_aide . `idaide`
LIMIT 0 , 100
SELECT
COUNT (
DISTINCT (text_aide . idtextaide )
) as total ,
text_aide . * ,
aides . * ,
`text_aide` . `publish` as text_aide_publish
FROM
`aides` ,
`text_aide`
WHERE
1
AND aides . `publish` = 1
AND aides . `type_aide` IN (2 , 3 )
AND text_aide . `idtext` IN (
4 ,
6 ,
10 ,
12 ,
86 ,
87 ,
283 ,
402 ,
460 ,
465 ,
466 ,
471 ,
476 ,
481 ,
482 ,
560 ,
561 ,
564 ,
565 ,
566 ,
567 ,
568 ,
569 ,
570 ,
571 ,
607 ,
609 ,
610 ,
3269 ,
3287 ,
3288 ,
3289 ,
3290 ,
3291 ,
3292 ,
3293 ,
3300 ,
3335 ,
3336 ,
3346 ,
3347 ,
3348 ,
3522 ,
3525 ,
3554 ,
6179 ,
7264 ,
12026 ,
15504 ,
22248 ,
33137 ,
35742 ,
36323 ,
36344 ,
36345 ,
36348 ,
36649 ,
37560 ,
3524 ,
37623 ,
37623 ,
44073 ,
21983 ,
37623 ,
9638 ,
29164 ,
37623 ,
37623 ,
37623 ,
3670 ,
37623 ,
37623 ,
4354 ,
37623 ,
3450 ,
3523 ,
9638 ,
37623 ,
3450 ,
3523 ,
9638 ,
37623 ,
12034 ,
5 ,
8 ,
191 ,
267 ,
404 ,
406 ,
408 ,
435 ,
754 ,
1134 ,
1183 ,
1620 ,
1669 ,
1699 ,
1700 ,
1957 ,
2598 ,
3270 ,
3301 ,
3373 ,
3397 ,
3432 ,
3462 ,
4372 ,
4374 ,
5995 ,
6274 ,
7188 ,
25664 ,
32552 ,
45615 ,
7 ,
1359 ,
1427 ,
1429 ,
3400 ,
3555 ,
4605 ,
6062 ,
6817 ,
6860 ,
13778 ,
17926 ,
25628 ,
40922 ,
33 ,
265 ,
336 ,
400 ,
457 ,
1019 ,
1021 ,
1300 ,
1697 ,
3398 ,
3399 ,
3420 ,
3421 ,
3433 ,
3586 ,
3847 ,
4263 ,
5157 ,
5308 ,
6088 ,
16755 ,
266 ,
453 ,
1085 ,
1186 ,
1662 ,
2648 ,
2666 ,
2968 ,
3299 ,
3401 ,
3459 ,
4415 ,
4745 ,
5998 ,
6463 ,
7296 ,
7658 ,
7725 ,
8812 ,
16775 ,
22377 ,
23415 ,
25026 ,
26277 ,
32924 ,
40923 ,
44604 ,
399 ,
424 ,
458 ,
468 ,
1785 ,
1958 ,
3374 ,
3811 ,
7206 ,
268 ,
1362 ,
5250 ,
5438 ,
5575 ,
5772 ,
397 ,
401 ,
423 ,
456 ,
753 ,
3302 ,
3563 ,
403 ,
451 ,
474 ,
1670 ,
1709 ,
4371 ,
5579 ,
6803 ,
461 ,
1712 ,
4001 ,
4416 ,
469 ,
470 ,
407 ,
472 ,
799 ,
1492 ,
1660 ,
961 ,
1326 ,
1358 ,
1710 ,
3264 ,
3411 ,
5205 ,
6061 ,
8744 ,
8813 ,
40924 ,
1927 ,
1668 ,
2481 ,
3417 ,
3423 ,
3415 ,
40925 ,
40921 ,
3271 ,
3272 ,
3428 ,
13779 ,
3422 ,
3561 ,
5510 ,
3562 ,
1928 ,
2599 ,
3830 ,
5963 ,
3416 ,
3547 ,
35741
)
AND aides . `idaide` = text_aide . `idaide`
LIMIT
0 , 100
Copy
SELECT COUNT (DISTINCT (text_aide . idtextaide )) as total , text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (2 , 3 ) AND text_aide . `idtext` IN (4 , 6 , 10 , 12 , 86 , 87 , 283 , 402 , 460 , 465 , 466 , 471 , 476 , 481 , 482 , 560 , 561 , 564 , 565 , 566 , 567 , 568 , 569 , 570 , 571 , 607 , 609 , 610 , 3269 , 3287 , 3288 , 3289 , 3290 , 3291 , 3292 , 3293 , 3300 , 3335 , 3336 , 3346 , 3347 , 3348 , 3522 , 3525 , 3554 , 6179 , 7264 , 12026 , 15504 , 22248 , 33137 , 35742 , 36323 , 36344 , 36345 , 36348 , 36649 , 37560 , 3524 , 37623 , 37623 , 44073 , 21983 , 37623 , 9638 , 29164 , 37623 , 37623 , 37623 , 3670 , 37623 , 37623 , 4354 , 37623 , 3450 , 3523 , 9638 , 37623 , 3450 , 3523 , 9638 , 37623 , 12034 , 5 , 8 , 191 , 267 , 404 , 406 , 408 , 435 , 754 , 1134 , 1183 , 1620 , 1669 , 1699 , 1700 , 1957 , 2598 , 3270 , 3301 , 3373 , 3397 , 3432 , 3462 , 4372 , 4374 , 5995 , 6274 , 7188 , 25664 , 32552 , 45615 , 7 , 1359 , 1427 , 1429 , 3400 , 3555 , 4605 , 6062 , 6817 , 6860 , 13778 , 17926 , 25628 , 40922 , 33 , 265 , 336 , 400 , 457 , 1019 , 1021 , 1300 , 1697 , 3398 , 3399 , 3420 , 3421 , 3433 , 3586 , 3847 , 4263 , 5157 , 5308 , 6088 , 16755 , 266 , 453 , 1085 , 1186 , 1662 , 2648 , 2666 , 2968 , 3299 , 3401 , 3459 , 4415 , 4745 , 5998 , 6463 , 7296 , 7658 , 7725 , 8812 , 16775 , 22377 , 23415 , 25026 , 26277 , 32924 , 40923 , 44604 , 399 , 424 , 458 , 468 , 1785 , 1958 , 3374 , 3811 , 7206 , 268 , 1362 , 5250 , 5438 , 5575 , 5772 , 397 , 401 , 423 , 456 , 753 , 3302 , 3563 , 403 , 451 , 474 , 1670 , 1709 , 4371 , 5579 , 6803 , 461 , 1712 , 4001 , 4416 , 469 , 470 , 407 , 472 , 799 , 1492 , 1660 , 961 , 1326 , 1358 , 1710 , 3264 , 3411 , 5205 , 6061 , 8744 , 8813 , 40924 , 1927 , 1668 , 2481 , 3417 , 3423 , 3415 , 40925 , 40921 , 3271 , 3272 , 3428 , 13779 , 3422 , 3561 , 5510 , 3562 , 1928 , 2599 , 3830 , 5963 , 3416 , 3547 , 35741 ) AND aides . `idaide` = text_aide . `idaide`
LIMIT 0 , 100 ;
Copy
138
5.59 ms
SELECT COUNT (DISTINCT (text_aide . idtextaide )) as total , text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (1 ) AND text_aide . `idtext` IN (4 , 6 , 10 , 12 , 86 , 87 , 283 , 402 , 460 , 465 , 466 , 471 , 476 , 481 , 482 , 560 , 561 , 564 , 565 , 566 , 567 , 568 , 569 , 570 , 571 , 607 , 609 , 610 , 3269 , 3287 , 3288 , 3289 , 3290 , 3291 , 3292 , 3293 , 3300 , 3335 , 3336 , 3346 , 3347 , 3348 , 3522 , 3525 , 3554 , 6179 , 7264 , 12026 , 15504 , 22248 , 33137 , 35742 , 36323 , 36344 , 36345 , 36348 , 36649 , 37560 , 3524 , 37623 , 37623 , 44073 , 21983 , 37623 , 9638 , 29164 , 37623 , 37623 , 37623 , 3670 , 37623 , 37623 , 4354 , 37623 , 3450 , 3523 , 9638 , 37623 , 3450 , 3523 , 9638 , 37623 , 12034 , 5 , 8 , 191 , 267 , 404 , 406 , 408 , 435 , 754 , 1134 , 1183 , 1620 , 1669 , 1699 , 1700 , 1957 , 2598 , 3270 , 3301 , 3373 , 3397 , 3432 , 3462 , 4372 , 4374 , 5995 , 6274 , 7188 , 25664 , 32552 , 45615 , 7 , 1359 , 1427 , 1429 , 3400 , 3555 , 4605 , 6062 , 6817 , 6860 , 13778 , 17926 , 25628 , 40922 , 33 , 265 , 336 , 400 , 457 , 1019 , 1021 , 1300 , 1697 , 3398 , 3399 , 3420 , 3421 , 3433 , 3586 , 3847 , 4263 , 5157 , 5308 , 6088 , 16755 , 266 , 453 , 1085 , 1186 , 1662 , 2648 , 2666 , 2968 , 3299 , 3401 , 3459 , 4415 , 4745 , 5998 , 6463 , 7296 , 7658 , 7725 , 8812 , 16775 , 22377 , 23415 , 25026 , 26277 , 32924 , 40923 , 44604 , 399 , 424 , 458 , 468 , 1785 , 1958 , 3374 , 3811 , 7206 , 268 , 1362 , 5250 , 5438 , 5575 , 5772 , 397 , 401 , 423 , 456 , 753 , 3302 , 3563 , 403 , 451 , 474 , 1670 , 1709 , 4371 , 5579 , 6803 , 461 , 1712 , 4001 , 4416 , 469 , 470 , 407 , 472 , 799 , 1492 , 1660 , 961 , 1326 , 1358 , 1710 , 3264 , 3411 , 5205 , 6061 , 8744 , 8813 , 40924 , 1927 , 1668 , 2481 , 3417 , 3423 , 3415 , 40925 , 40921 , 3271 , 3272 , 3428 , 13779 , 3422 , 3561 , 5510 , 3562 , 1928 , 2599 , 3830 , 5963 , 3416 , 3547 , 35741 ) AND aides . `idaide` = text_aide . `idaide`
LIMIT 0 , 5
SELECT
COUNT (
DISTINCT (text_aide . idtextaide )
) as total ,
text_aide . * ,
aides . * ,
`text_aide` . `publish` as text_aide_publish
FROM
`aides` ,
`text_aide`
WHERE
1
AND aides . `publish` = 1
AND aides . `type_aide` IN (1 )
AND text_aide . `idtext` IN (
4 ,
6 ,
10 ,
12 ,
86 ,
87 ,
283 ,
402 ,
460 ,
465 ,
466 ,
471 ,
476 ,
481 ,
482 ,
560 ,
561 ,
564 ,
565 ,
566 ,
567 ,
568 ,
569 ,
570 ,
571 ,
607 ,
609 ,
610 ,
3269 ,
3287 ,
3288 ,
3289 ,
3290 ,
3291 ,
3292 ,
3293 ,
3300 ,
3335 ,
3336 ,
3346 ,
3347 ,
3348 ,
3522 ,
3525 ,
3554 ,
6179 ,
7264 ,
12026 ,
15504 ,
22248 ,
33137 ,
35742 ,
36323 ,
36344 ,
36345 ,
36348 ,
36649 ,
37560 ,
3524 ,
37623 ,
37623 ,
44073 ,
21983 ,
37623 ,
9638 ,
29164 ,
37623 ,
37623 ,
37623 ,
3670 ,
37623 ,
37623 ,
4354 ,
37623 ,
3450 ,
3523 ,
9638 ,
37623 ,
3450 ,
3523 ,
9638 ,
37623 ,
12034 ,
5 ,
8 ,
191 ,
267 ,
404 ,
406 ,
408 ,
435 ,
754 ,
1134 ,
1183 ,
1620 ,
1669 ,
1699 ,
1700 ,
1957 ,
2598 ,
3270 ,
3301 ,
3373 ,
3397 ,
3432 ,
3462 ,
4372 ,
4374 ,
5995 ,
6274 ,
7188 ,
25664 ,
32552 ,
45615 ,
7 ,
1359 ,
1427 ,
1429 ,
3400 ,
3555 ,
4605 ,
6062 ,
6817 ,
6860 ,
13778 ,
17926 ,
25628 ,
40922 ,
33 ,
265 ,
336 ,
400 ,
457 ,
1019 ,
1021 ,
1300 ,
1697 ,
3398 ,
3399 ,
3420 ,
3421 ,
3433 ,
3586 ,
3847 ,
4263 ,
5157 ,
5308 ,
6088 ,
16755 ,
266 ,
453 ,
1085 ,
1186 ,
1662 ,
2648 ,
2666 ,
2968 ,
3299 ,
3401 ,
3459 ,
4415 ,
4745 ,
5998 ,
6463 ,
7296 ,
7658 ,
7725 ,
8812 ,
16775 ,
22377 ,
23415 ,
25026 ,
26277 ,
32924 ,
40923 ,
44604 ,
399 ,
424 ,
458 ,
468 ,
1785 ,
1958 ,
3374 ,
3811 ,
7206 ,
268 ,
1362 ,
5250 ,
5438 ,
5575 ,
5772 ,
397 ,
401 ,
423 ,
456 ,
753 ,
3302 ,
3563 ,
403 ,
451 ,
474 ,
1670 ,
1709 ,
4371 ,
5579 ,
6803 ,
461 ,
1712 ,
4001 ,
4416 ,
469 ,
470 ,
407 ,
472 ,
799 ,
1492 ,
1660 ,
961 ,
1326 ,
1358 ,
1710 ,
3264 ,
3411 ,
5205 ,
6061 ,
8744 ,
8813 ,
40924 ,
1927 ,
1668 ,
2481 ,
3417 ,
3423 ,
3415 ,
40925 ,
40921 ,
3271 ,
3272 ,
3428 ,
13779 ,
3422 ,
3561 ,
5510 ,
3562 ,
1928 ,
2599 ,
3830 ,
5963 ,
3416 ,
3547 ,
35741
)
AND aides . `idaide` = text_aide . `idaide`
LIMIT
0 , 5
Copy
SELECT COUNT (DISTINCT (text_aide . idtextaide )) as total , text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (1 ) AND text_aide . `idtext` IN (4 , 6 , 10 , 12 , 86 , 87 , 283 , 402 , 460 , 465 , 466 , 471 , 476 , 481 , 482 , 560 , 561 , 564 , 565 , 566 , 567 , 568 , 569 , 570 , 571 , 607 , 609 , 610 , 3269 , 3287 , 3288 , 3289 , 3290 , 3291 , 3292 , 3293 , 3300 , 3335 , 3336 , 3346 , 3347 , 3348 , 3522 , 3525 , 3554 , 6179 , 7264 , 12026 , 15504 , 22248 , 33137 , 35742 , 36323 , 36344 , 36345 , 36348 , 36649 , 37560 , 3524 , 37623 , 37623 , 44073 , 21983 , 37623 , 9638 , 29164 , 37623 , 37623 , 37623 , 3670 , 37623 , 37623 , 4354 , 37623 , 3450 , 3523 , 9638 , 37623 , 3450 , 3523 , 9638 , 37623 , 12034 , 5 , 8 , 191 , 267 , 404 , 406 , 408 , 435 , 754 , 1134 , 1183 , 1620 , 1669 , 1699 , 1700 , 1957 , 2598 , 3270 , 3301 , 3373 , 3397 , 3432 , 3462 , 4372 , 4374 , 5995 , 6274 , 7188 , 25664 , 32552 , 45615 , 7 , 1359 , 1427 , 1429 , 3400 , 3555 , 4605 , 6062 , 6817 , 6860 , 13778 , 17926 , 25628 , 40922 , 33 , 265 , 336 , 400 , 457 , 1019 , 1021 , 1300 , 1697 , 3398 , 3399 , 3420 , 3421 , 3433 , 3586 , 3847 , 4263 , 5157 , 5308 , 6088 , 16755 , 266 , 453 , 1085 , 1186 , 1662 , 2648 , 2666 , 2968 , 3299 , 3401 , 3459 , 4415 , 4745 , 5998 , 6463 , 7296 , 7658 , 7725 , 8812 , 16775 , 22377 , 23415 , 25026 , 26277 , 32924 , 40923 , 44604 , 399 , 424 , 458 , 468 , 1785 , 1958 , 3374 , 3811 , 7206 , 268 , 1362 , 5250 , 5438 , 5575 , 5772 , 397 , 401 , 423 , 456 , 753 , 3302 , 3563 , 403 , 451 , 474 , 1670 , 1709 , 4371 , 5579 , 6803 , 461 , 1712 , 4001 , 4416 , 469 , 470 , 407 , 472 , 799 , 1492 , 1660 , 961 , 1326 , 1358 , 1710 , 3264 , 3411 , 5205 , 6061 , 8744 , 8813 , 40924 , 1927 , 1668 , 2481 , 3417 , 3423 , 3415 , 40925 , 40921 , 3271 , 3272 , 3428 , 13779 , 3422 , 3561 , 5510 , 3562 , 1928 , 2599 , 3830 , 5963 , 3416 , 3547 , 35741 ) AND aides . `idaide` = text_aide . `idaide`
LIMIT 0 , 5 ;
Copy
139
4.70 ms
SELECT COUNT (DISTINCT (text_aide . idtextaide )) as total , text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (4 ) AND text_aide . `idtext` IN (4 , 6 , 10 , 12 , 86 , 87 , 283 , 402 , 460 , 465 , 466 , 471 , 476 , 481 , 482 , 560 , 561 , 564 , 565 , 566 , 567 , 568 , 569 , 570 , 571 , 607 , 609 , 610 , 3269 , 3287 , 3288 , 3289 , 3290 , 3291 , 3292 , 3293 , 3300 , 3335 , 3336 , 3346 , 3347 , 3348 , 3522 , 3525 , 3554 , 6179 , 7264 , 12026 , 15504 , 22248 , 33137 , 35742 , 36323 , 36344 , 36345 , 36348 , 36649 , 37560 , 3524 , 37623 , 37623 , 44073 , 21983 , 37623 , 9638 , 29164 , 37623 , 37623 , 37623 , 3670 , 37623 , 37623 , 4354 , 37623 , 3450 , 3523 , 9638 , 37623 , 3450 , 3523 , 9638 , 37623 , 12034 , 5 , 8 , 191 , 267 , 404 , 406 , 408 , 435 , 754 , 1134 , 1183 , 1620 , 1669 , 1699 , 1700 , 1957 , 2598 , 3270 , 3301 , 3373 , 3397 , 3432 , 3462 , 4372 , 4374 , 5995 , 6274 , 7188 , 25664 , 32552 , 45615 , 7 , 1359 , 1427 , 1429 , 3400 , 3555 , 4605 , 6062 , 6817 , 6860 , 13778 , 17926 , 25628 , 40922 , 33 , 265 , 336 , 400 , 457 , 1019 , 1021 , 1300 , 1697 , 3398 , 3399 , 3420 , 3421 , 3433 , 3586 , 3847 , 4263 , 5157 , 5308 , 6088 , 16755 , 266 , 453 , 1085 , 1186 , 1662 , 2648 , 2666 , 2968 , 3299 , 3401 , 3459 , 4415 , 4745 , 5998 , 6463 , 7296 , 7658 , 7725 , 8812 , 16775 , 22377 , 23415 , 25026 , 26277 , 32924 , 40923 , 44604 , 399 , 424 , 458 , 468 , 1785 , 1958 , 3374 , 3811 , 7206 , 268 , 1362 , 5250 , 5438 , 5575 , 5772 , 397 , 401 , 423 , 456 , 753 , 3302 , 3563 , 403 , 451 , 474 , 1670 , 1709 , 4371 , 5579 , 6803 , 461 , 1712 , 4001 , 4416 , 469 , 470 , 407 , 472 , 799 , 1492 , 1660 , 961 , 1326 , 1358 , 1710 , 3264 , 3411 , 5205 , 6061 , 8744 , 8813 , 40924 , 1927 , 1668 , 2481 , 3417 , 3423 , 3415 , 40925 , 40921 , 3271 , 3272 , 3428 , 13779 , 3422 , 3561 , 5510 , 3562 , 1928 , 2599 , 3830 , 5963 , 3416 , 3547 , 35741 ) AND aides . `idaide` = text_aide . `idaide`
LIMIT 0 , 5
SELECT
COUNT (
DISTINCT (text_aide . idtextaide )
) as total ,
text_aide . * ,
aides . * ,
`text_aide` . `publish` as text_aide_publish
FROM
`aides` ,
`text_aide`
WHERE
1
AND aides . `publish` = 1
AND aides . `type_aide` IN (4 )
AND text_aide . `idtext` IN (
4 ,
6 ,
10 ,
12 ,
86 ,
87 ,
283 ,
402 ,
460 ,
465 ,
466 ,
471 ,
476 ,
481 ,
482 ,
560 ,
561 ,
564 ,
565 ,
566 ,
567 ,
568 ,
569 ,
570 ,
571 ,
607 ,
609 ,
610 ,
3269 ,
3287 ,
3288 ,
3289 ,
3290 ,
3291 ,
3292 ,
3293 ,
3300 ,
3335 ,
3336 ,
3346 ,
3347 ,
3348 ,
3522 ,
3525 ,
3554 ,
6179 ,
7264 ,
12026 ,
15504 ,
22248 ,
33137 ,
35742 ,
36323 ,
36344 ,
36345 ,
36348 ,
36649 ,
37560 ,
3524 ,
37623 ,
37623 ,
44073 ,
21983 ,
37623 ,
9638 ,
29164 ,
37623 ,
37623 ,
37623 ,
3670 ,
37623 ,
37623 ,
4354 ,
37623 ,
3450 ,
3523 ,
9638 ,
37623 ,
3450 ,
3523 ,
9638 ,
37623 ,
12034 ,
5 ,
8 ,
191 ,
267 ,
404 ,
406 ,
408 ,
435 ,
754 ,
1134 ,
1183 ,
1620 ,
1669 ,
1699 ,
1700 ,
1957 ,
2598 ,
3270 ,
3301 ,
3373 ,
3397 ,
3432 ,
3462 ,
4372 ,
4374 ,
5995 ,
6274 ,
7188 ,
25664 ,
32552 ,
45615 ,
7 ,
1359 ,
1427 ,
1429 ,
3400 ,
3555 ,
4605 ,
6062 ,
6817 ,
6860 ,
13778 ,
17926 ,
25628 ,
40922 ,
33 ,
265 ,
336 ,
400 ,
457 ,
1019 ,
1021 ,
1300 ,
1697 ,
3398 ,
3399 ,
3420 ,
3421 ,
3433 ,
3586 ,
3847 ,
4263 ,
5157 ,
5308 ,
6088 ,
16755 ,
266 ,
453 ,
1085 ,
1186 ,
1662 ,
2648 ,
2666 ,
2968 ,
3299 ,
3401 ,
3459 ,
4415 ,
4745 ,
5998 ,
6463 ,
7296 ,
7658 ,
7725 ,
8812 ,
16775 ,
22377 ,
23415 ,
25026 ,
26277 ,
32924 ,
40923 ,
44604 ,
399 ,
424 ,
458 ,
468 ,
1785 ,
1958 ,
3374 ,
3811 ,
7206 ,
268 ,
1362 ,
5250 ,
5438 ,
5575 ,
5772 ,
397 ,
401 ,
423 ,
456 ,
753 ,
3302 ,
3563 ,
403 ,
451 ,
474 ,
1670 ,
1709 ,
4371 ,
5579 ,
6803 ,
461 ,
1712 ,
4001 ,
4416 ,
469 ,
470 ,
407 ,
472 ,
799 ,
1492 ,
1660 ,
961 ,
1326 ,
1358 ,
1710 ,
3264 ,
3411 ,
5205 ,
6061 ,
8744 ,
8813 ,
40924 ,
1927 ,
1668 ,
2481 ,
3417 ,
3423 ,
3415 ,
40925 ,
40921 ,
3271 ,
3272 ,
3428 ,
13779 ,
3422 ,
3561 ,
5510 ,
3562 ,
1928 ,
2599 ,
3830 ,
5963 ,
3416 ,
3547 ,
35741
)
AND aides . `idaide` = text_aide . `idaide`
LIMIT
0 , 5
Copy
SELECT COUNT (DISTINCT (text_aide . idtextaide )) as total , text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (4 ) AND text_aide . `idtext` IN (4 , 6 , 10 , 12 , 86 , 87 , 283 , 402 , 460 , 465 , 466 , 471 , 476 , 481 , 482 , 560 , 561 , 564 , 565 , 566 , 567 , 568 , 569 , 570 , 571 , 607 , 609 , 610 , 3269 , 3287 , 3288 , 3289 , 3290 , 3291 , 3292 , 3293 , 3300 , 3335 , 3336 , 3346 , 3347 , 3348 , 3522 , 3525 , 3554 , 6179 , 7264 , 12026 , 15504 , 22248 , 33137 , 35742 , 36323 , 36344 , 36345 , 36348 , 36649 , 37560 , 3524 , 37623 , 37623 , 44073 , 21983 , 37623 , 9638 , 29164 , 37623 , 37623 , 37623 , 3670 , 37623 , 37623 , 4354 , 37623 , 3450 , 3523 , 9638 , 37623 , 3450 , 3523 , 9638 , 37623 , 12034 , 5 , 8 , 191 , 267 , 404 , 406 , 408 , 435 , 754 , 1134 , 1183 , 1620 , 1669 , 1699 , 1700 , 1957 , 2598 , 3270 , 3301 , 3373 , 3397 , 3432 , 3462 , 4372 , 4374 , 5995 , 6274 , 7188 , 25664 , 32552 , 45615 , 7 , 1359 , 1427 , 1429 , 3400 , 3555 , 4605 , 6062 , 6817 , 6860 , 13778 , 17926 , 25628 , 40922 , 33 , 265 , 336 , 400 , 457 , 1019 , 1021 , 1300 , 1697 , 3398 , 3399 , 3420 , 3421 , 3433 , 3586 , 3847 , 4263 , 5157 , 5308 , 6088 , 16755 , 266 , 453 , 1085 , 1186 , 1662 , 2648 , 2666 , 2968 , 3299 , 3401 , 3459 , 4415 , 4745 , 5998 , 6463 , 7296 , 7658 , 7725 , 8812 , 16775 , 22377 , 23415 , 25026 , 26277 , 32924 , 40923 , 44604 , 399 , 424 , 458 , 468 , 1785 , 1958 , 3374 , 3811 , 7206 , 268 , 1362 , 5250 , 5438 , 5575 , 5772 , 397 , 401 , 423 , 456 , 753 , 3302 , 3563 , 403 , 451 , 474 , 1670 , 1709 , 4371 , 5579 , 6803 , 461 , 1712 , 4001 , 4416 , 469 , 470 , 407 , 472 , 799 , 1492 , 1660 , 961 , 1326 , 1358 , 1710 , 3264 , 3411 , 5205 , 6061 , 8744 , 8813 , 40924 , 1927 , 1668 , 2481 , 3417 , 3423 , 3415 , 40925 , 40921 , 3271 , 3272 , 3428 , 13779 , 3422 , 3561 , 5510 , 3562 , 1928 , 2599 , 3830 , 5963 , 3416 , 3547 , 35741 ) AND aides . `idaide` = text_aide . `idaide`
LIMIT 0 , 5 ;
Copy
140
0.41 ms
SELECT COUNT (DISTINCT (p . `idplaylist` )) as total
FROM playlists p
LEFT JOIN playlist_classification pc ON pc . `idplaylist` = p . `idplaylist`
LEFT JOIN classifications c ON pc . `idclassification` = c . `idclassification`
WHERE p . `publish` = 1
AND p . `idperson` IN (3 ) AND c . `classification` = 'class_auteur_meme'
SELECT COUNT (DISTINCT (p . `idplaylist` )) as total
FROM playlists p
LEFT JOIN playlist_classification pc ON pc . `idplaylist` = p . `idplaylist`
LEFT JOIN classifications c ON pc . `idclassification` = c . `idclassification`
WHERE p . `publish` = 1
AND p . `idperson` IN (3 ) AND c . `classification` = 'class_auteur_meme' ;
Copy
141
0.30 ms
SELECT p . `idplaylist`
FROM playlists p
LEFT JOIN playlist_classification pc ON pc . `idplaylist` = p . `idplaylist`
LEFT JOIN classifications c ON pc . `idclassification` = c . `idclassification`
WHERE p . `publish` = 1
AND p . `idperson` = 3 AND c . `classification` = 'class_auteur_meme' LIMIT 0 , 1
SELECT p . `idplaylist`
FROM playlists p
LEFT JOIN playlist_classification pc ON pc . `idplaylist` = p . `idplaylist`
LEFT JOIN classifications c ON pc . `idclassification` = c . `idclassification`
WHERE p . `publish` = 1
AND p . `idperson` = 3 AND c . `classification` = 'class_auteur_meme' LIMIT 0 , 1 ;
Copy
142
0.16 ms
SELECT p0_ . idplaylist AS idplaylist_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . url_clean AS url_clean_3 , p0_ . dateupdate AS dateupdate_4 , p0_ . dateinsert AS dateinsert_5 , p0_ . publish AS publish_6 , p0_ . valid AS valid_7 FROM playlists p0_ WHERE p0_ . idplaylist = ?
SELECT p0_ . idplaylist AS idplaylist_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . url_clean AS url_clean_3 , p0_ . dateupdate AS dateupdate_4 , p0_ . dateinsert AS dateinsert_5 , p0_ . publish AS publish_6 , p0_ . valid AS valid_7 FROM playlists p0_ WHERE p0_ . idplaylist = '786' ;
Copy
143
0.18 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . persons j1 , theatreok_dev . playlists j3
WHERE j1 . idperson = j3 . idperson
AND j3 . idplaylist = 786
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . persons j1 , theatreok_dev . playlists j3
WHERE j1 . idperson = j3 . idperson
AND j3 . idplaylist = 786 ;
Copy
144
0.31 ms
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . spectacles j1 , theatreok_dev . playlists j3
WHERE j1 . idspectacle = j3 . idspectacle
AND j3 . idplaylist = 786
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . spectacles j1 , theatreok_dev . playlists j3
WHERE j1 . idspectacle = j3 . idspectacle
AND j3 . idplaylist = 786 ;
Copy
145
0.20 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . contacts j1 , theatreok_dev . playlists j3
WHERE j1 . idcontact = j3 . idcontact
AND j3 . idplaylist = 786
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . contacts j1 , theatreok_dev . playlists j3
WHERE j1 . idcontact = j3 . idcontact
AND j3 . idplaylist = 786 ;
Copy
146
0.20 ms
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . texts j1 , theatreok_dev . playlists j3
WHERE j1 . idtext = j3 . idtext
AND j3 . idplaylist = 786
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . texts j1 , theatreok_dev . playlists j3
WHERE j1 . idtext = j3 . idtext
AND j3 . idplaylist = 786 ;
Copy
147
0.34 ms
SELECT j1 . idmultimedia , j1 . sujet_titre , j1 . url_clean , j1 . status , j1 . price , j3 . idplaylist FROM theatreok_dev . multimedias j1 , theatreok_dev . playlist_multimedia j2 , theatreok_dev . playlists j3
WHERE j3 . idplaylist = j2 . idplaylist
AND j1 . idmultimedia = j2 . idmultimedia
AND j3 . idplaylist = 786 ORDER BY j2 . `orderplaylist`
SELECT j1 . idmultimedia , j1 . sujet_titre , j1 . url_clean , j1 . status , j1 . price , j3 . idplaylist FROM theatreok_dev . multimedias j1 , theatreok_dev . playlist_multimedia j2 , theatreok_dev . playlists j3
WHERE j3 . idplaylist = j2 . idplaylist
AND j1 . idmultimedia = j2 . idmultimedia
AND j3 . idplaylist = 786 ORDER BY j2 . `orderplaylist` ;
Copy
148
0.24 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idplaylist FROM theatreok_dev . classifications j1 , theatreok_dev . playlist_classification j2 , theatreok_dev . playlists j3
WHERE j3 . idplaylist = j2 . idplaylist
AND j1 . idclassification = j2 . idclassification
AND j3 . idplaylist = 786
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idplaylist FROM theatreok_dev . classifications j1 , theatreok_dev . playlist_classification j2 , theatreok_dev . playlists j3
WHERE j3 . idplaylist = j2 . idplaylist
AND j1 . idclassification = j2 . idclassification
AND j3 . idplaylist = 786 ;
Copy
149
15.05 ms
SELECT DISTINCT (s . idschedule ), hour , date , s . note , s . url_spectacle , s . url_booking , s . idcontact_festival , s . hour , s . idspectacle ,
c . idcontact , c . organisation , c . phone1 , c . phone2 , c . city , c . url_clean ,
ft . idcontact as festival_idcontact , ft . organisation as festival_organisation , ft . city as festival_city , ft . url_clean as festival_url_clean
FROM schedules s
JOIN contacts c ON s . idcontact = c . idcontact
LEFT JOIN contacts ft ON s . idcontact_festival = ft . idcontact
WHERE 1 AND s . idspectacle IN (4 , 5 , 6 , 7 , 8 , 9 , 10 , 12 , 13 , 16 , 17 , 18 , 22 , 23 , 24 , 25 , 27 , 28 , 31 , 33 , 43 , 44 , 48 , 49 , 51 , 72 , 73 , 75 , 76 , 78 , 79 , 87 , 89 , 98 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 115 , 116 , 118 , 124 , 132 , 142 , 143 , 146 , 218 , 243 , 253 , 255 , 257 , 263 , 264 , 265 , 266 , 267 , 268 , 269 , 271 , 273 , 274 , 277 , 278 , 279 , 282 , 368 , 378 , 382 , 385 , 386 , 390 , 391 , 392 , 393 , 394 , 395 , 396 , 397 , 398 , 400 , 401 , 402 , 403 , 423 , 443 , 452 , 455 , 457 , 460 , 463 , 464 , 465 , 466 , 467 , 468 , 469 , 470 , 471 , 472 , 473 , 475 , 476 , 477 , 483 , 567 , 568 , 569 , 572 , 573 , 584 , 585 , 586 , 588 , 589 , 594 , 595 , 699 , 701 , 702 , 703 , 705 , 706 , 707 , 709 , 710 , 712 , 737 , 738 , 741 , 746 , 754 , 755 , 756 , 757 , 758 , 759 , 760 , 763 , 765 , 778 , 780 , 795 , 825 , 828 , 885 , 890 , 891 , 895 , 897 , 902 , 933 , 946 , 953 , 957 , 981 , 982 , 983 , 984 , 987 , 988 , 989 , 995 , 1001 , 1003 , 1008 , 1011 , 1014 , 1015 , 1020 , 1022 , 1028 , 1168 , 1170 , 1181 , 1203 , 1222 , 1228 , 1229 , 1230 , 1267 , 1268 , 1275 , 1276 , 1277 , 1278 , 1280 , 1281 , 1283 , 1294 , 1305 , 1306 , 1307 , 1311 , 1312 , 1317 , 1338 , 1340 , 1341 , 1342 , 1343 , 1344 , 1345 , 1349 , 1350 , 1352 , 1353 , 1354 , 1356 , 1361 , 1451 , 1460 , 1543 , 1580 , 1654 , 1690 , 1699 , 1724 , 1744 , 1745 , 1747 , 1868 , 1928 , 1929 , 1990 , 2096 , 2129 , 2146 , 2147 , 2149 , 2152 , 2153 , 2159 , 2160 , 2163 , 2164 , 2166 , 2167 , 2168 , 2169 , 2171 , 2215 , 2216 , 2217 , 2218 , 2220 , 2255 , 2315 , 2445 , 2446 , 2447 , 2466 , 2482 , 2547 , 2553 , 2554 , 2560 , 2573 , 2574 , 2616 , 2650 , 2651 , 2653 , 2654 , 2662 , 2693 , 2694 , 2695 , 2709 , 2712 , 2719 , 2720 , 2721 , 2737 , 2744 , 2748 , 2750 , 2757 , 2781 , 2785 , 2786 , 2788 , 2796 , 2797 , 2803 , 2804 , 2813 , 2814 , 2824 , 2831 , 2832 , 2833 , 2834 , 2840 , 2856 , 2874 , 2875 , 2887 , 2891 , 2892 , 2895 , 2900 , 2901 , 2902 , 2912 , 2913 , 2969 , 2971 , 2976 , 2983 , 3036 , 3048 , 3089 , 3094 , 3095 , 3097 , 3098 , 3117 , 3118 , 3119 , 3126 , 3217 , 3224 , 3226 , 3234 , 3259 , 3410 , 3412 , 3445 , 3447 , 3451 , 3491 , 3492 , 3493 , 3495 , 3501 , 3518 , 3542 , 3583 , 3587 , 3596 , 3628 , 3636 , 3637 , 3731 , 3760 , 3762 , 3821 , 3834 , 3836 , 3852 , 3944 , 4000 , 4008 , 4009 , 4014 , 4027 , 4031 , 4032 , 4056 , 4075 , 4090 , 4092 , 4101 , 4104 , 4111 , 4123 , 4124 , 4132 , 4133 , 4134 , 4138 , 4168 , 4194 , 4229 , 4367 , 4368 , 4382 , 4429 , 4478 , 4559 , 4570 , 4571 , 4572 , 4592 , 4627 , 4629 , 4646 , 4660 , 4671 , 4690 , 4718 , 4749 , 4750 , 4753 , 4757 , 4774 , 4778 , 4795 , 4797 , 4799 , 4800 , 4803 , 4806 , 4811 , 4814 , 4925 , 4947 , 4984 , 5015 , 5020 , 5035 , 5048 , 5050 , 5052 , 5091 , 5106 , 5129 , 5131 , 5161 , 5162 , 5163 , 5199 , 5207 , 5208 , 5399 , 5401 , 5549 , 5586 , 5646 , 5757 , 5785 , 5820 , 5834 , 6137 , 6482 , 6649 , 6655 , 6808 , 7858 , 8145 , 8340 , 8431 , 8433 , 8779 , 8986 , 9106 , 9708 , 9748 , 10741 , 11286 , 11342 , 11496 , 12996 , 12997 , 13022 , 13358 , 13451 , 13845 , 14006 , 14559 , 15675 , 16644 , 16813 , 16859 , 16998 , 17408 , 18099 , 18473 , 19138 , 19168 , 19216 , 19483 , 19613 , 19638 , 19793 , 20030 , 20108 , 20273 , 20323 , 20533 , 20666 , 20943 , 20981 , 21124 , 21145 , 22067 , 22476 , 22479 , 22515 , 22676 , 22911 , 22914 , 23156 , 23240 , 23307 , 23500 , 23596 , 23609 , 23666 , 23671 , 23997 , 24799 , 24800 , 25582 , 25788 , 26092 , 26404 , 26539 , 27069 , 27082 , 27299 , 27635 , 28700 , 28857 , 29335 , 29384 , 29429 , 29824 , 30283 , 30324 , 30448 , 30808 , 30837 , 31709 , 31749 , 31773 , 31883 , 31903 , 32051 , 33275 , 33287 , 33589 , 33662 , 34647 , 35581 , 35582 , 35720 , 35740 , 36130 , 36335 , 36541 , 36569 , 36611 , 36875 , 36933 , 37020 , 37091 , 37310 , 37311 , 37312 , 37313 ) AND s . date > = '2024-05-01' ORDER BY s . date ASC LIMIT 0 , 1
SELECT
DISTINCT (s . idschedule ),
hour ,
date ,
s . note ,
s . url_spectacle ,
s . url_booking ,
s . idcontact_festival ,
s . hour ,
s . idspectacle ,
c . idcontact ,
c . organisation ,
c . phone1 ,
c . phone2 ,
c . city ,
c . url_clean ,
ft . idcontact as festival_idcontact ,
ft . organisation as festival_organisation ,
ft . city as festival_city ,
ft . url_clean as festival_url_clean
FROM
schedules s
JOIN contacts c ON s . idcontact = c . idcontact
LEFT JOIN contacts ft ON s . idcontact_festival = ft . idcontact
WHERE
1
AND s . idspectacle IN (
4 ,
5 ,
6 ,
7 ,
8 ,
9 ,
10 ,
12 ,
13 ,
16 ,
17 ,
18 ,
22 ,
23 ,
24 ,
25 ,
27 ,
28 ,
31 ,
33 ,
43 ,
44 ,
48 ,
49 ,
51 ,
72 ,
73 ,
75 ,
76 ,
78 ,
79 ,
87 ,
89 ,
98 ,
105 ,
106 ,
107 ,
108 ,
109 ,
110 ,
111 ,
115 ,
116 ,
118 ,
124 ,
132 ,
142 ,
143 ,
146 ,
218 ,
243 ,
253 ,
255 ,
257 ,
263 ,
264 ,
265 ,
266 ,
267 ,
268 ,
269 ,
271 ,
273 ,
274 ,
277 ,
278 ,
279 ,
282 ,
368 ,
378 ,
382 ,
385 ,
386 ,
390 ,
391 ,
392 ,
393 ,
394 ,
395 ,
396 ,
397 ,
398 ,
400 ,
401 ,
402 ,
403 ,
423 ,
443 ,
452 ,
455 ,
457 ,
460 ,
463 ,
464 ,
465 ,
466 ,
467 ,
468 ,
469 ,
470 ,
471 ,
472 ,
473 ,
475 ,
476 ,
477 ,
483 ,
567 ,
568 ,
569 ,
572 ,
573 ,
584 ,
585 ,
586 ,
588 ,
589 ,
594 ,
595 ,
699 ,
701 ,
702 ,
703 ,
705 ,
706 ,
707 ,
709 ,
710 ,
712 ,
737 ,
738 ,
741 ,
746 ,
754 ,
755 ,
756 ,
757 ,
758 ,
759 ,
760 ,
763 ,
765 ,
778 ,
780 ,
795 ,
825 ,
828 ,
885 ,
890 ,
891 ,
895 ,
897 ,
902 ,
933 ,
946 ,
953 ,
957 ,
981 ,
982 ,
983 ,
984 ,
987 ,
988 ,
989 ,
995 ,
1001 ,
1003 ,
1008 ,
1011 ,
1014 ,
1015 ,
1020 ,
1022 ,
1028 ,
1168 ,
1170 ,
1181 ,
1203 ,
1222 ,
1228 ,
1229 ,
1230 ,
1267 ,
1268 ,
1275 ,
1276 ,
1277 ,
1278 ,
1280 ,
1281 ,
1283 ,
1294 ,
1305 ,
1306 ,
1307 ,
1311 ,
1312 ,
1317 ,
1338 ,
1340 ,
1341 ,
1342 ,
1343 ,
1344 ,
1345 ,
1349 ,
1350 ,
1352 ,
1353 ,
1354 ,
1356 ,
1361 ,
1451 ,
1460 ,
1543 ,
1580 ,
1654 ,
1690 ,
1699 ,
1724 ,
1744 ,
1745 ,
1747 ,
1868 ,
1928 ,
1929 ,
1990 ,
2096 ,
2129 ,
2146 ,
2147 ,
2149 ,
2152 ,
2153 ,
2159 ,
2160 ,
2163 ,
2164 ,
2166 ,
2167 ,
2168 ,
2169 ,
2171 ,
2215 ,
2216 ,
2217 ,
2218 ,
2220 ,
2255 ,
2315 ,
2445 ,
2446 ,
2447 ,
2466 ,
2482 ,
2547 ,
2553 ,
2554 ,
2560 ,
2573 ,
2574 ,
2616 ,
2650 ,
2651 ,
2653 ,
2654 ,
2662 ,
2693 ,
2694 ,
2695 ,
2709 ,
2712 ,
2719 ,
2720 ,
2721 ,
2737 ,
2744 ,
2748 ,
2750 ,
2757 ,
2781 ,
2785 ,
2786 ,
2788 ,
2796 ,
2797 ,
2803 ,
2804 ,
2813 ,
2814 ,
2824 ,
2831 ,
2832 ,
2833 ,
2834 ,
2840 ,
2856 ,
2874 ,
2875 ,
2887 ,
2891 ,
2892 ,
2895 ,
2900 ,
2901 ,
2902 ,
2912 ,
2913 ,
2969 ,
2971 ,
2976 ,
2983 ,
3036 ,
3048 ,
3089 ,
3094 ,
3095 ,
3097 ,
3098 ,
3117 ,
3118 ,
3119 ,
3126 ,
3217 ,
3224 ,
3226 ,
3234 ,
3259 ,
3410 ,
3412 ,
3445 ,
3447 ,
3451 ,
3491 ,
3492 ,
3493 ,
3495 ,
3501 ,
3518 ,
3542 ,
3583 ,
3587 ,
3596 ,
3628 ,
3636 ,
3637 ,
3731 ,
3760 ,
3762 ,
3821 ,
3834 ,
3836 ,
3852 ,
3944 ,
4000 ,
4008 ,
4009 ,
4014 ,
4027 ,
4031 ,
4032 ,
4056 ,
4075 ,
4090 ,
4092 ,
4101 ,
4104 ,
4111 ,
4123 ,
4124 ,
4132 ,
4133 ,
4134 ,
4138 ,
4168 ,
4194 ,
4229 ,
4367 ,
4368 ,
4382 ,
4429 ,
4478 ,
4559 ,
4570 ,
4571 ,
4572 ,
4592 ,
4627 ,
4629 ,
4646 ,
4660 ,
4671 ,
4690 ,
4718 ,
4749 ,
4750 ,
4753 ,
4757 ,
4774 ,
4778 ,
4795 ,
4797 ,
4799 ,
4800 ,
4803 ,
4806 ,
4811 ,
4814 ,
4925 ,
4947 ,
4984 ,
5015 ,
5020 ,
5035 ,
5048 ,
5050 ,
5052 ,
5091 ,
5106 ,
5129 ,
5131 ,
5161 ,
5162 ,
5163 ,
5199 ,
5207 ,
5208 ,
5399 ,
5401 ,
5549 ,
5586 ,
5646 ,
5757 ,
5785 ,
5820 ,
5834 ,
6137 ,
6482 ,
6649 ,
6655 ,
6808 ,
7858 ,
8145 ,
8340 ,
8431 ,
8433 ,
8779 ,
8986 ,
9106 ,
9708 ,
9748 ,
10741 ,
11286 ,
11342 ,
11496 ,
12996 ,
12997 ,
13022 ,
13358 ,
13451 ,
13845 ,
14006 ,
14559 ,
15675 ,
16644 ,
16813 ,
16859 ,
16998 ,
17408 ,
18099 ,
18473 ,
19138 ,
19168 ,
19216 ,
19483 ,
19613 ,
19638 ,
19793 ,
20030 ,
20108 ,
20273 ,
20323 ,
20533 ,
20666 ,
20943 ,
20981 ,
21124 ,
21145 ,
22067 ,
22476 ,
22479 ,
22515 ,
22676 ,
22911 ,
22914 ,
23156 ,
23240 ,
23307 ,
23500 ,
23596 ,
23609 ,
23666 ,
23671 ,
23997 ,
24799 ,
24800 ,
25582 ,
25788 ,
26092 ,
26404 ,
26539 ,
27069 ,
27082 ,
27299 ,
27635 ,
28700 ,
28857 ,
29335 ,
29384 ,
29429 ,
29824 ,
30283 ,
30324 ,
30448 ,
30808 ,
30837 ,
31709 ,
31749 ,
31773 ,
31883 ,
31903 ,
32051 ,
33275 ,
33287 ,
33589 ,
33662 ,
34647 ,
35581 ,
35582 ,
35720 ,
35740 ,
36130 ,
36335 ,
36541 ,
36569 ,
36611 ,
36875 ,
36933 ,
37020 ,
37091 ,
37310 ,
37311 ,
37312 ,
37313
)
AND s . date > = '2024-05-01'
ORDER BY
s . date ASC
LIMIT
0 , 1
Copy
SELECT DISTINCT (s . idschedule ), hour , date , s . note , s . url_spectacle , s . url_booking , s . idcontact_festival , s . hour , s . idspectacle ,
c . idcontact , c . organisation , c . phone1 , c . phone2 , c . city , c . url_clean ,
ft . idcontact as festival_idcontact , ft . organisation as festival_organisation , ft . city as festival_city , ft . url_clean as festival_url_clean
FROM schedules s
JOIN contacts c ON s . idcontact = c . idcontact
LEFT JOIN contacts ft ON s . idcontact_festival = ft . idcontact
WHERE 1 AND s . idspectacle IN (4 , 5 , 6 , 7 , 8 , 9 , 10 , 12 , 13 , 16 , 17 , 18 , 22 , 23 , 24 , 25 , 27 , 28 , 31 , 33 , 43 , 44 , 48 , 49 , 51 , 72 , 73 , 75 , 76 , 78 , 79 , 87 , 89 , 98 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 115 , 116 , 118 , 124 , 132 , 142 , 143 , 146 , 218 , 243 , 253 , 255 , 257 , 263 , 264 , 265 , 266 , 267 , 268 , 269 , 271 , 273 , 274 , 277 , 278 , 279 , 282 , 368 , 378 , 382 , 385 , 386 , 390 , 391 , 392 , 393 , 394 , 395 , 396 , 397 , 398 , 400 , 401 , 402 , 403 , 423 , 443 , 452 , 455 , 457 , 460 , 463 , 464 , 465 , 466 , 467 , 468 , 469 , 470 , 471 , 472 , 473 , 475 , 476 , 477 , 483 , 567 , 568 , 569 , 572 , 573 , 584 , 585 , 586 , 588 , 589 , 594 , 595 , 699 , 701 , 702 , 703 , 705 , 706 , 707 , 709 , 710 , 712 , 737 , 738 , 741 , 746 , 754 , 755 , 756 , 757 , 758 , 759 , 760 , 763 , 765 , 778 , 780 , 795 , 825 , 828 , 885 , 890 , 891 , 895 , 897 , 902 , 933 , 946 , 953 , 957 , 981 , 982 , 983 , 984 , 987 , 988 , 989 , 995 , 1001 , 1003 , 1008 , 1011 , 1014 , 1015 , 1020 , 1022 , 1028 , 1168 , 1170 , 1181 , 1203 , 1222 , 1228 , 1229 , 1230 , 1267 , 1268 , 1275 , 1276 , 1277 , 1278 , 1280 , 1281 , 1283 , 1294 , 1305 , 1306 , 1307 , 1311 , 1312 , 1317 , 1338 , 1340 , 1341 , 1342 , 1343 , 1344 , 1345 , 1349 , 1350 , 1352 , 1353 , 1354 , 1356 , 1361 , 1451 , 1460 , 1543 , 1580 , 1654 , 1690 , 1699 , 1724 , 1744 , 1745 , 1747 , 1868 , 1928 , 1929 , 1990 , 2096 , 2129 , 2146 , 2147 , 2149 , 2152 , 2153 , 2159 , 2160 , 2163 , 2164 , 2166 , 2167 , 2168 , 2169 , 2171 , 2215 , 2216 , 2217 , 2218 , 2220 , 2255 , 2315 , 2445 , 2446 , 2447 , 2466 , 2482 , 2547 , 2553 , 2554 , 2560 , 2573 , 2574 , 2616 , 2650 , 2651 , 2653 , 2654 , 2662 , 2693 , 2694 , 2695 , 2709 , 2712 , 2719 , 2720 , 2721 , 2737 , 2744 , 2748 , 2750 , 2757 , 2781 , 2785 , 2786 , 2788 , 2796 , 2797 , 2803 , 2804 , 2813 , 2814 , 2824 , 2831 , 2832 , 2833 , 2834 , 2840 , 2856 , 2874 , 2875 , 2887 , 2891 , 2892 , 2895 , 2900 , 2901 , 2902 , 2912 , 2913 , 2969 , 2971 , 2976 , 2983 , 3036 , 3048 , 3089 , 3094 , 3095 , 3097 , 3098 , 3117 , 3118 , 3119 , 3126 , 3217 , 3224 , 3226 , 3234 , 3259 , 3410 , 3412 , 3445 , 3447 , 3451 , 3491 , 3492 , 3493 , 3495 , 3501 , 3518 , 3542 , 3583 , 3587 , 3596 , 3628 , 3636 , 3637 , 3731 , 3760 , 3762 , 3821 , 3834 , 3836 , 3852 , 3944 , 4000 , 4008 , 4009 , 4014 , 4027 , 4031 , 4032 , 4056 , 4075 , 4090 , 4092 , 4101 , 4104 , 4111 , 4123 , 4124 , 4132 , 4133 , 4134 , 4138 , 4168 , 4194 , 4229 , 4367 , 4368 , 4382 , 4429 , 4478 , 4559 , 4570 , 4571 , 4572 , 4592 , 4627 , 4629 , 4646 , 4660 , 4671 , 4690 , 4718 , 4749 , 4750 , 4753 , 4757 , 4774 , 4778 , 4795 , 4797 , 4799 , 4800 , 4803 , 4806 , 4811 , 4814 , 4925 , 4947 , 4984 , 5015 , 5020 , 5035 , 5048 , 5050 , 5052 , 5091 , 5106 , 5129 , 5131 , 5161 , 5162 , 5163 , 5199 , 5207 , 5208 , 5399 , 5401 , 5549 , 5586 , 5646 , 5757 , 5785 , 5820 , 5834 , 6137 , 6482 , 6649 , 6655 , 6808 , 7858 , 8145 , 8340 , 8431 , 8433 , 8779 , 8986 , 9106 , 9708 , 9748 , 10741 , 11286 , 11342 , 11496 , 12996 , 12997 , 13022 , 13358 , 13451 , 13845 , 14006 , 14559 , 15675 , 16644 , 16813 , 16859 , 16998 , 17408 , 18099 , 18473 , 19138 , 19168 , 19216 , 19483 , 19613 , 19638 , 19793 , 20030 , 20108 , 20273 , 20323 , 20533 , 20666 , 20943 , 20981 , 21124 , 21145 , 22067 , 22476 , 22479 , 22515 , 22676 , 22911 , 22914 , 23156 , 23240 , 23307 , 23500 , 23596 , 23609 , 23666 , 23671 , 23997 , 24799 , 24800 , 25582 , 25788 , 26092 , 26404 , 26539 , 27069 , 27082 , 27299 , 27635 , 28700 , 28857 , 29335 , 29384 , 29429 , 29824 , 30283 , 30324 , 30448 , 30808 , 30837 , 31709 , 31749 , 31773 , 31883 , 31903 , 32051 , 33275 , 33287 , 33589 , 33662 , 34647 , 35581 , 35582 , 35720 , 35740 , 36130 , 36335 , 36541 , 36569 , 36611 , 36875 , 36933 , 37020 , 37091 , 37310 , 37311 , 37312 , 37313 ) AND s . date > = '2024-05-01' ORDER BY s . date ASC LIMIT 0 , 1 ;
Copy
150
1.53 ms
SELECT COUNT (DISTINCT (T1 . idnew )) as total FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_person T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idperson = 3 ) AND T1 . publish = 1
SELECT COUNT (DISTINCT (T1 . idnew )) as total FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_person T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idperson = 3 ) AND T1 . publish = 1 ;
Copy
151
2.98 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 3
AND om . object = 'persons'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 3
AND om . object = 'persons'
AND m . publish = 1 ;
Copy
152
0.77 ms
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_person do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idperson` = 3 AND d . code_franceinter IS NOT NULL
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_person do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idperson` = 3 AND d . code_franceinter IS NOT NULL ;
Copy
153
0.55 ms
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_person do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idperson` = 3 AND d . code_soundcloud IS NOT NULL
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_person do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idperson` = 3 AND d . code_soundcloud IS NOT NULL ;
Copy
154
5.87 ms
SELECT COUNT (DISTINCT (T1 . `idtext` )) as total FROM texts T1
LEFT JOIN contacts T2 ON T2 . `idcontact` = T1 . `idcontact_publisher` , object_content oc2 , contents c2 , content_classification cc2 WHERE 1 AND oc2 . idcontent = c2 . idcontent
AND cc2 . idcontent = c2 . idcontent
AND oc2 . idobject = T1 . idtext
AND cc2 . idclassification IN (125 )
AND oc2 . object = 'texts' AND T1 . `idtext` IN (4 , 6 , 10 , 12 , 86 , 87 , 283 , 402 , 460 , 465 , 466 , 471 , 476 , 481 , 482 , 560 , 561 , 564 , 565 , 566 , 567 , 568 , 569 , 570 , 571 , 607 , 609 , 610 , 3269 , 3287 , 3288 , 3289 , 3290 , 3291 , 3292 , 3293 , 3300 , 3335 , 3336 , 3346 , 3347 , 3348 , 3522 , 3525 , 3554 , 6179 , 7264 , 12026 , 15504 , 22248 , 33137 , 35742 , 36323 , 36344 , 36345 , 36348 , 36649 , 37560 , 3524 , 37623 , 37623 , 44073 , 21983 , 37623 , 9638 , 29164 , 37623 , 37623 , 37623 , 3670 , 37623 , 37623 , 4354 , 37623 , 3450 , 3523 , 9638 , 37623 , 3450 , 3523 , 9638 , 37623 , 12034 , 5 , 8 , 191 , 267 , 404 , 406 , 408 , 435 , 754 , 1134 , 1183 , 1620 , 1669 , 1699 , 1700 , 1957 , 2598 , 3270 , 3301 , 3373 , 3397 , 3432 , 3462 , 4372 , 4374 , 5995 , 6274 , 7188 , 25664 , 32552 , 45615 , 7 , 1359 , 1427 , 1429 , 3400 , 3555 , 4605 , 6062 , 6817 , 6860 , 13778 , 17926 , 25628 , 40922 , 33 , 265 , 336 , 400 , 457 , 1019 , 1021 , 1300 , 1697 , 3398 , 3399 , 3420 , 3421 , 3433 , 3586 , 3847 , 4263 , 5157 , 5308 , 6088 , 16755 , 266 , 453 , 1085 , 1186 , 1662 , 2648 , 2666 , 2968 , 3299 , 3401 , 3459 , 4415 , 4745 , 5998 , 6463 , 7296 , 7658 , 7725 , 8812 , 16775 , 22377 , 23415 , 25026 , 26277 , 32924 , 40923 , 44604 , 399 , 424 , 458 , 468 , 1785 , 1958 , 3374 , 3811 , 7206 , 268 , 1362 , 5250 , 5438 , 5575 , 5772 , 397 , 401 , 423 , 456 , 753 , 3302 , 3563 , 403 , 451 , 474 , 1670 , 1709 , 4371 , 5579 , 6803 , 461 , 1712 , 4001 , 4416 , 469 , 470 , 407 , 472 , 799 , 1492 , 1660 , 961 , 1326 , 1358 , 1710 , 3264 , 3411 , 5205 , 6061 , 8744 , 8813 , 40924 , 1927 , 1668 , 2481 , 3417 , 3423 , 3415 , 40925 , 40921 , 3271 , 3272 , 3428 , 13779 , 3422 , 3561 , 5510 , 3562 , 1928 , 2599 , 3830 , 5963 , 3416 , 3547 , 35741 ) ORDER BY publication_year DESC
SELECT
COUNT (
DISTINCT (T1 . `idtext` )
) as total
FROM
texts T1
LEFT JOIN contacts T2 ON T2 . `idcontact` = T1 . `idcontact_publisher` ,
object_content oc2 ,
contents c2 ,
content_classification cc2
WHERE
1
AND oc2 . idcontent = c2 . idcontent
AND cc2 . idcontent = c2 . idcontent
AND oc2 . idobject = T1 . idtext
AND cc2 . idclassification IN (125 )
AND oc2 . object = 'texts'
AND T1 . `idtext` IN (
4 ,
6 ,
10 ,
12 ,
86 ,
87 ,
283 ,
402 ,
460 ,
465 ,
466 ,
471 ,
476 ,
481 ,
482 ,
560 ,
561 ,
564 ,
565 ,
566 ,
567 ,
568 ,
569 ,
570 ,
571 ,
607 ,
609 ,
610 ,
3269 ,
3287 ,
3288 ,
3289 ,
3290 ,
3291 ,
3292 ,
3293 ,
3300 ,
3335 ,
3336 ,
3346 ,
3347 ,
3348 ,
3522 ,
3525 ,
3554 ,
6179 ,
7264 ,
12026 ,
15504 ,
22248 ,
33137 ,
35742 ,
36323 ,
36344 ,
36345 ,
36348 ,
36649 ,
37560 ,
3524 ,
37623 ,
37623 ,
44073 ,
21983 ,
37623 ,
9638 ,
29164 ,
37623 ,
37623 ,
37623 ,
3670 ,
37623 ,
37623 ,
4354 ,
37623 ,
3450 ,
3523 ,
9638 ,
37623 ,
3450 ,
3523 ,
9638 ,
37623 ,
12034 ,
5 ,
8 ,
191 ,
267 ,
404 ,
406 ,
408 ,
435 ,
754 ,
1134 ,
1183 ,
1620 ,
1669 ,
1699 ,
1700 ,
1957 ,
2598 ,
3270 ,
3301 ,
3373 ,
3397 ,
3432 ,
3462 ,
4372 ,
4374 ,
5995 ,
6274 ,
7188 ,
25664 ,
32552 ,
45615 ,
7 ,
1359 ,
1427 ,
1429 ,
3400 ,
3555 ,
4605 ,
6062 ,
6817 ,
6860 ,
13778 ,
17926 ,
25628 ,
40922 ,
33 ,
265 ,
336 ,
400 ,
457 ,
1019 ,
1021 ,
1300 ,
1697 ,
3398 ,
3399 ,
3420 ,
3421 ,
3433 ,
3586 ,
3847 ,
4263 ,
5157 ,
5308 ,
6088 ,
16755 ,
266 ,
453 ,
1085 ,
1186 ,
1662 ,
2648 ,
2666 ,
2968 ,
3299 ,
3401 ,
3459 ,
4415 ,
4745 ,
5998 ,
6463 ,
7296 ,
7658 ,
7725 ,
8812 ,
16775 ,
22377 ,
23415 ,
25026 ,
26277 ,
32924 ,
40923 ,
44604 ,
399 ,
424 ,
458 ,
468 ,
1785 ,
1958 ,
3374 ,
3811 ,
7206 ,
268 ,
1362 ,
5250 ,
5438 ,
5575 ,
5772 ,
397 ,
401 ,
423 ,
456 ,
753 ,
3302 ,
3563 ,
403 ,
451 ,
474 ,
1670 ,
1709 ,
4371 ,
5579 ,
6803 ,
461 ,
1712 ,
4001 ,
4416 ,
469 ,
470 ,
407 ,
472 ,
799 ,
1492 ,
1660 ,
961 ,
1326 ,
1358 ,
1710 ,
3264 ,
3411 ,
5205 ,
6061 ,
8744 ,
8813 ,
40924 ,
1927 ,
1668 ,
2481 ,
3417 ,
3423 ,
3415 ,
40925 ,
40921 ,
3271 ,
3272 ,
3428 ,
13779 ,
3422 ,
3561 ,
5510 ,
3562 ,
1928 ,
2599 ,
3830 ,
5963 ,
3416 ,
3547 ,
35741
)
ORDER BY
publication_year DESC
Copy
SELECT COUNT (DISTINCT (T1 . `idtext` )) as total FROM texts T1
LEFT JOIN contacts T2 ON T2 . `idcontact` = T1 . `idcontact_publisher` , object_content oc2 , contents c2 , content_classification cc2 WHERE 1 AND oc2 . idcontent = c2 . idcontent
AND cc2 . idcontent = c2 . idcontent
AND oc2 . idobject = T1 . idtext
AND cc2 . idclassification IN (125 )
AND oc2 . object = 'texts' AND T1 . `idtext` IN (4 , 6 , 10 , 12 , 86 , 87 , 283 , 402 , 460 , 465 , 466 , 471 , 476 , 481 , 482 , 560 , 561 , 564 , 565 , 566 , 567 , 568 , 569 , 570 , 571 , 607 , 609 , 610 , 3269 , 3287 , 3288 , 3289 , 3290 , 3291 , 3292 , 3293 , 3300 , 3335 , 3336 , 3346 , 3347 , 3348 , 3522 , 3525 , 3554 , 6179 , 7264 , 12026 , 15504 , 22248 , 33137 , 35742 , 36323 , 36344 , 36345 , 36348 , 36649 , 37560 , 3524 , 37623 , 37623 , 44073 , 21983 , 37623 , 9638 , 29164 , 37623 , 37623 , 37623 , 3670 , 37623 , 37623 , 4354 , 37623 , 3450 , 3523 , 9638 , 37623 , 3450 , 3523 , 9638 , 37623 , 12034 , 5 , 8 , 191 , 267 , 404 , 406 , 408 , 435 , 754 , 1134 , 1183 , 1620 , 1669 , 1699 , 1700 , 1957 , 2598 , 3270 , 3301 , 3373 , 3397 , 3432 , 3462 , 4372 , 4374 , 5995 , 6274 , 7188 , 25664 , 32552 , 45615 , 7 , 1359 , 1427 , 1429 , 3400 , 3555 , 4605 , 6062 , 6817 , 6860 , 13778 , 17926 , 25628 , 40922 , 33 , 265 , 336 , 400 , 457 , 1019 , 1021 , 1300 , 1697 , 3398 , 3399 , 3420 , 3421 , 3433 , 3586 , 3847 , 4263 , 5157 , 5308 , 6088 , 16755 , 266 , 453 , 1085 , 1186 , 1662 , 2648 , 2666 , 2968 , 3299 , 3401 , 3459 , 4415 , 4745 , 5998 , 6463 , 7296 , 7658 , 7725 , 8812 , 16775 , 22377 , 23415 , 25026 , 26277 , 32924 , 40923 , 44604 , 399 , 424 , 458 , 468 , 1785 , 1958 , 3374 , 3811 , 7206 , 268 , 1362 , 5250 , 5438 , 5575 , 5772 , 397 , 401 , 423 , 456 , 753 , 3302 , 3563 , 403 , 451 , 474 , 1670 , 1709 , 4371 , 5579 , 6803 , 461 , 1712 , 4001 , 4416 , 469 , 470 , 407 , 472 , 799 , 1492 , 1660 , 961 , 1326 , 1358 , 1710 , 3264 , 3411 , 5205 , 6061 , 8744 , 8813 , 40924 , 1927 , 1668 , 2481 , 3417 , 3423 , 3415 , 40925 , 40921 , 3271 , 3272 , 3428 , 13779 , 3422 , 3561 , 5510 , 3562 , 1928 , 2599 , 3830 , 5963 , 3416 , 3547 , 35741 ) ORDER BY publication_year DESC ;
Copy
155
5.69 ms
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . * , spectacles . `idspectacle` , schedules . `idcontact`
FROM `object_multimedia` ,
`schedules` ,
`spectacles` ,
`contacts` ,
`multimedias` ,
`multimedia_classification`
WHERE 1 AND multimedias . `publish` = 1 AND object_multimedia . `object` = 'spectacles' AND object_multimedia . `idrole` IS NULL AND schedules . `date` BETWEEN '1999-01-01' AND '2030-01-01' AND object_multimedia . `object` = 'spectacles' AND object_multimedia . `idobject` IN (4 , 5 , 6 , 7 , 8 , 9 , 10 , 12 , 13 , 16 , 17 , 18 , 22 , 23 , 24 , 25 , 27 , 28 , 31 , 33 , 43 , 44 , 48 , 49 , 51 , 72 , 73 , 75 , 76 , 78 , 79 , 87 , 89 , 98 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 115 , 116 , 118 , 124 , 132 , 142 , 143 , 146 , 218 , 243 , 253 , 255 , 257 , 263 , 264 , 265 , 266 , 267 , 268 , 269 , 271 , 273 , 274 , 277 , 278 , 279 , 282 , 368 , 378 , 382 , 385 , 386 , 390 , 391 , 392 , 393 , 394 , 395 , 396 , 397 , 398 , 400 , 401 , 402 , 403 , 423 , 443 , 452 , 455 , 457 , 460 , 463 , 464 , 465 , 466 , 467 , 468 , 469 , 470 , 471 , 472 , 473 , 475 , 476 , 477 , 483 , 567 , 568 , 569 , 572 , 573 , 584 , 585 , 586 , 588 , 589 , 594 , 595 , 699 , 701 , 702 , 703 , 705 , 706 , 707 , 709 , 710 , 712 , 737 , 738 , 741 , 746 , 754 , 755 , 756 , 757 , 758 , 759 , 760 , 763 , 765 , 778 , 780 , 795 , 825 , 828 , 885 , 890 , 891 , 895 , 897 , 902 , 933 , 946 , 953 , 957 , 981 , 982 , 983 , 984 , 987 , 988 , 989 , 995 , 1001 , 1003 , 1008 , 1011 , 1014 , 1015 , 1020 , 1022 , 1028 , 1168 , 1170 , 1181 , 1203 , 1222 , 1228 , 1229 , 1230 , 1267 , 1268 , 1275 , 1276 , 1277 , 1278 , 1280 , 1281 , 1283 , 1294 , 1305 , 1306 , 1307 , 1311 , 1312 , 1317 , 1338 , 1340 , 1341 , 1342 , 1343 , 1344 , 1345 , 1349 , 1350 , 1352 , 1353 , 1354 , 1356 , 1361 , 1451 , 1460 , 1543 , 1580 , 1654 , 1690 , 1699 , 1724 , 1744 , 1745 , 1747 , 1868 , 1928 , 1929 , 1990 , 2096 , 2129 , 2146 , 2147 , 2149 , 2152 , 2153 , 2159 , 2160 , 2163 , 2164 , 2166 , 2167 , 2168 , 2169 , 2171 , 2215 , 2216 , 2217 , 2218 , 2220 , 2255 , 2315 , 2445 , 2446 , 2447 , 2466 , 2482 , 2547 , 2553 , 2554 , 2560 , 2573 , 2574 , 2616 , 2650 , 2651 , 2653 , 2654 , 2662 , 2693 , 2694 , 2695 , 2709 , 2712 , 2719 , 2720 , 2721 , 2737 , 2744 , 2748 , 2750 , 2757 , 2781 , 2785 , 2786 , 2788 , 2796 , 2797 , 2803 , 2804 , 2813 , 2814 , 2824 , 2831 , 2832 , 2833 , 2834 , 2840 , 2856 , 2874 , 2875 , 2887 , 2891 , 2892 , 2895 , 2900 , 2901 , 2902 , 2912 , 2913 , 2969 , 2971 , 2976 , 2983 , 3036 , 3048 , 3089 , 3094 , 3095 , 3097 , 3098 , 3117 , 3118 , 3119 , 3126 , 3217 , 3224 , 3226 , 3234 , 3259 , 3410 , 3412 , 3445 , 3447 , 3451 , 3491 , 3492 , 3493 , 3495 , 3501 , 3518 , 3542 , 3583 , 3587 , 3596 , 3628 , 3636 , 3637 , 3731 , 3760 , 3762 , 3821 , 3834 , 3836 , 3852 , 3944 , 4000 , 4008 , 4009 , 4014 , 4027 , 4031 , 4032 , 4056 , 4075 , 4090 , 4092 , 4101 , 4104 , 4111 , 4123 , 4124 , 4132 , 4133 , 4134 , 4138 , 4168 , 4194 , 4229 , 4367 , 4368 , 4382 , 4429 , 4478 , 4559 , 4570 , 4571 , 4572 , 4592 , 4627 , 4629 , 4646 , 4660 , 4671 , 4690 , 4718 , 4749 , 4750 , 4753 , 4757 , 4774 , 4778 , 4795 , 4797 , 4799 , 4800 , 4803 , 4806 , 4811 , 4814 , 4925 , 4947 , 4984 , 5015 , 5020 , 5035 , 5048 , 5050 , 5052 , 5091 , 5106 , 5129 , 5131 , 5161 , 5162 , 5163 , 5199 , 5207 , 5208 , 5399 , 5401 , 5549 , 5586 , 5646 , 5757 , 5785 , 5820 , 5834 , 6137 , 6482 , 6649 , 6655 , 6808 , 7858 , 8145 , 8340 , 8431 , 8433 , 8779 , 8986 , 9106 , 9708 , 9748 , 10741 , 11286 , 11342 , 11496 , 12996 , 12997 , 13022 , 13358 , 13451 , 13845 , 14006 , 14559 , 15675 , 16644 , 16813 , 16859 , 16998 , 17408 , 18099 , 18473 , 19138 , 19168 , 19216 , 19483 , 19613 , 19638 , 19793 , 20030 , 20108 , 20273 , 20323 , 20533 , 20666 , 20943 , 20981 , 21124 , 21145 , 22067 , 22476 , 22479 , 22515 , 22676 , 22911 , 22914 , 23156 , 23240 , 23307 , 23500 , 23596 , 23609 , 23666 , 23671 , 23997 , 24799 , 24800 , 25582 , 25788 , 26092 , 26404 , 26539 , 27069 , 27082 , 27299 , 27635 , 28700 , 28857 , 29335 , 29384 , 29429 , 29824 , 30283 , 30324 , 30448 , 30808 , 30837 , 31709 , 31749 , 31773 , 31883 , 31903 , 32051 , 33275 , 33287 , 33589 , 33662 , 34647 , 35581 , 35582 , 35720 , 35740 , 36130 , 36335 , 36541 , 36569 , 36611 , 36875 , 36933 , 37020 , 37091 , 37310 , 37311 , 37312 , 37313 ) AND multimedia_classification . `idclassification` = 145 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia` AND schedules . `idspectacle` = spectacles . `idspectacle` AND spectacles . `idspectacle` = object_multimedia . `idobject` AND contacts . `idcontact` = schedules . `idcontact` AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia` AND multimedias . `idmultimedia` = multimedia_classification . `idmultimedia`
GROUP BY object_multimedia . `idobject`
ORDER BY schedules . `date`
ASC
LIMIT 0 , 100
SELECT
DISTINCT (multimedias . idmultimedia ),
multimedias . * ,
spectacles . `idspectacle` ,
schedules . `idcontact`
FROM
`object_multimedia` ,
`schedules` ,
`spectacles` ,
`contacts` ,
`multimedias` ,
`multimedia_classification`
WHERE
1
AND multimedias . `publish` = 1
AND object_multimedia . `object` = 'spectacles'
AND object_multimedia . `idrole` IS NULL
AND schedules . `date` BETWEEN '1999-01-01'
AND '2030-01-01'
AND object_multimedia . `object` = 'spectacles'
AND object_multimedia . `idobject` IN (
4 ,
5 ,
6 ,
7 ,
8 ,
9 ,
10 ,
12 ,
13 ,
16 ,
17 ,
18 ,
22 ,
23 ,
24 ,
25 ,
27 ,
28 ,
31 ,
33 ,
43 ,
44 ,
48 ,
49 ,
51 ,
72 ,
73 ,
75 ,
76 ,
78 ,
79 ,
87 ,
89 ,
98 ,
105 ,
106 ,
107 ,
108 ,
109 ,
110 ,
111 ,
115 ,
116 ,
118 ,
124 ,
132 ,
142 ,
143 ,
146 ,
218 ,
243 ,
253 ,
255 ,
257 ,
263 ,
264 ,
265 ,
266 ,
267 ,
268 ,
269 ,
271 ,
273 ,
274 ,
277 ,
278 ,
279 ,
282 ,
368 ,
378 ,
382 ,
385 ,
386 ,
390 ,
391 ,
392 ,
393 ,
394 ,
395 ,
396 ,
397 ,
398 ,
400 ,
401 ,
402 ,
403 ,
423 ,
443 ,
452 ,
455 ,
457 ,
460 ,
463 ,
464 ,
465 ,
466 ,
467 ,
468 ,
469 ,
470 ,
471 ,
472 ,
473 ,
475 ,
476 ,
477 ,
483 ,
567 ,
568 ,
569 ,
572 ,
573 ,
584 ,
585 ,
586 ,
588 ,
589 ,
594 ,
595 ,
699 ,
701 ,
702 ,
703 ,
705 ,
706 ,
707 ,
709 ,
710 ,
712 ,
737 ,
738 ,
741 ,
746 ,
754 ,
755 ,
756 ,
757 ,
758 ,
759 ,
760 ,
763 ,
765 ,
778 ,
780 ,
795 ,
825 ,
828 ,
885 ,
890 ,
891 ,
895 ,
897 ,
902 ,
933 ,
946 ,
953 ,
957 ,
981 ,
982 ,
983 ,
984 ,
987 ,
988 ,
989 ,
995 ,
1001 ,
1003 ,
1008 ,
1011 ,
1014 ,
1015 ,
1020 ,
1022 ,
1028 ,
1168 ,
1170 ,
1181 ,
1203 ,
1222 ,
1228 ,
1229 ,
1230 ,
1267 ,
1268 ,
1275 ,
1276 ,
1277 ,
1278 ,
1280 ,
1281 ,
1283 ,
1294 ,
1305 ,
1306 ,
1307 ,
1311 ,
1312 ,
1317 ,
1338 ,
1340 ,
1341 ,
1342 ,
1343 ,
1344 ,
1345 ,
1349 ,
1350 ,
1352 ,
1353 ,
1354 ,
1356 ,
1361 ,
1451 ,
1460 ,
1543 ,
1580 ,
1654 ,
1690 ,
1699 ,
1724 ,
1744 ,
1745 ,
1747 ,
1868 ,
1928 ,
1929 ,
1990 ,
2096 ,
2129 ,
2146 ,
2147 ,
2149 ,
2152 ,
2153 ,
2159 ,
2160 ,
2163 ,
2164 ,
2166 ,
2167 ,
2168 ,
2169 ,
2171 ,
2215 ,
2216 ,
2217 ,
2218 ,
2220 ,
2255 ,
2315 ,
2445 ,
2446 ,
2447 ,
2466 ,
2482 ,
2547 ,
2553 ,
2554 ,
2560 ,
2573 ,
2574 ,
2616 ,
2650 ,
2651 ,
2653 ,
2654 ,
2662 ,
2693 ,
2694 ,
2695 ,
2709 ,
2712 ,
2719 ,
2720 ,
2721 ,
2737 ,
2744 ,
2748 ,
2750 ,
2757 ,
2781 ,
2785 ,
2786 ,
2788 ,
2796 ,
2797 ,
2803 ,
2804 ,
2813 ,
2814 ,
2824 ,
2831 ,
2832 ,
2833 ,
2834 ,
2840 ,
2856 ,
2874 ,
2875 ,
2887 ,
2891 ,
2892 ,
2895 ,
2900 ,
2901 ,
2902 ,
2912 ,
2913 ,
2969 ,
2971 ,
2976 ,
2983 ,
3036 ,
3048 ,
3089 ,
3094 ,
3095 ,
3097 ,
3098 ,
3117 ,
3118 ,
3119 ,
3126 ,
3217 ,
3224 ,
3226 ,
3234 ,
3259 ,
3410 ,
3412 ,
3445 ,
3447 ,
3451 ,
3491 ,
3492 ,
3493 ,
3495 ,
3501 ,
3518 ,
3542 ,
3583 ,
3587 ,
3596 ,
3628 ,
3636 ,
3637 ,
3731 ,
3760 ,
3762 ,
3821 ,
3834 ,
3836 ,
3852 ,
3944 ,
4000 ,
4008 ,
4009 ,
4014 ,
4027 ,
4031 ,
4032 ,
4056 ,
4075 ,
4090 ,
4092 ,
4101 ,
4104 ,
4111 ,
4123 ,
4124 ,
4132 ,
4133 ,
4134 ,
4138 ,
4168 ,
4194 ,
4229 ,
4367 ,
4368 ,
4382 ,
4429 ,
4478 ,
4559 ,
4570 ,
4571 ,
4572 ,
4592 ,
4627 ,
4629 ,
4646 ,
4660 ,
4671 ,
4690 ,
4718 ,
4749 ,
4750 ,
4753 ,
4757 ,
4774 ,
4778 ,
4795 ,
4797 ,
4799 ,
4800 ,
4803 ,
4806 ,
4811 ,
4814 ,
4925 ,
4947 ,
4984 ,
5015 ,
5020 ,
5035 ,
5048 ,
5050 ,
5052 ,
5091 ,
5106 ,
5129 ,
5131 ,
5161 ,
5162 ,
5163 ,
5199 ,
5207 ,
5208 ,
5399 ,
5401 ,
5549 ,
5586 ,
5646 ,
5757 ,
5785 ,
5820 ,
5834 ,
6137 ,
6482 ,
6649 ,
6655 ,
6808 ,
7858 ,
8145 ,
8340 ,
8431 ,
8433 ,
8779 ,
8986 ,
9106 ,
9708 ,
9748 ,
10741 ,
11286 ,
11342 ,
11496 ,
12996 ,
12997 ,
13022 ,
13358 ,
13451 ,
13845 ,
14006 ,
14559 ,
15675 ,
16644 ,
16813 ,
16859 ,
16998 ,
17408 ,
18099 ,
18473 ,
19138 ,
19168 ,
19216 ,
19483 ,
19613 ,
19638 ,
19793 ,
20030 ,
20108 ,
20273 ,
20323 ,
20533 ,
20666 ,
20943 ,
20981 ,
21124 ,
21145 ,
22067 ,
22476 ,
22479 ,
22515 ,
22676 ,
22911 ,
22914 ,
23156 ,
23240 ,
23307 ,
23500 ,
23596 ,
23609 ,
23666 ,
23671 ,
23997 ,
24799 ,
24800 ,
25582 ,
25788 ,
26092 ,
26404 ,
26539 ,
27069 ,
27082 ,
27299 ,
27635 ,
28700 ,
28857 ,
29335 ,
29384 ,
29429 ,
29824 ,
30283 ,
30324 ,
30448 ,
30808 ,
30837 ,
31709 ,
31749 ,
31773 ,
31883 ,
31903 ,
32051 ,
33275 ,
33287 ,
33589 ,
33662 ,
34647 ,
35581 ,
35582 ,
35720 ,
35740 ,
36130 ,
36335 ,
36541 ,
36569 ,
36611 ,
36875 ,
36933 ,
37020 ,
37091 ,
37310 ,
37311 ,
37312 ,
37313
)
AND multimedia_classification . `idclassification` = 145
AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
AND schedules . `idspectacle` = spectacles . `idspectacle`
AND spectacles . `idspectacle` = object_multimedia . `idobject`
AND contacts . `idcontact` = schedules . `idcontact`
AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
AND multimedias . `idmultimedia` = multimedia_classification . `idmultimedia`
GROUP BY
object_multimedia . `idobject`
ORDER BY
schedules . `date` ASC
LIMIT
0 , 100
Copy
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . * , spectacles . `idspectacle` , schedules . `idcontact`
FROM `object_multimedia` ,
`schedules` ,
`spectacles` ,
`contacts` ,
`multimedias` ,
`multimedia_classification`
WHERE 1 AND multimedias . `publish` = 1 AND object_multimedia . `object` = 'spectacles' AND object_multimedia . `idrole` IS NULL AND schedules . `date` BETWEEN '1999-01-01' AND '2030-01-01' AND object_multimedia . `object` = 'spectacles' AND object_multimedia . `idobject` IN (4 , 5 , 6 , 7 , 8 , 9 , 10 , 12 , 13 , 16 , 17 , 18 , 22 , 23 , 24 , 25 , 27 , 28 , 31 , 33 , 43 , 44 , 48 , 49 , 51 , 72 , 73 , 75 , 76 , 78 , 79 , 87 , 89 , 98 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 115 , 116 , 118 , 124 , 132 , 142 , 143 , 146 , 218 , 243 , 253 , 255 , 257 , 263 , 264 , 265 , 266 , 267 , 268 , 269 , 271 , 273 , 274 , 277 , 278 , 279 , 282 , 368 , 378 , 382 , 385 , 386 , 390 , 391 , 392 , 393 , 394 , 395 , 396 , 397 , 398 , 400 , 401 , 402 , 403 , 423 , 443 , 452 , 455 , 457 , 460 , 463 , 464 , 465 , 466 , 467 , 468 , 469 , 470 , 471 , 472 , 473 , 475 , 476 , 477 , 483 , 567 , 568 , 569 , 572 , 573 , 584 , 585 , 586 , 588 , 589 , 594 , 595 , 699 , 701 , 702 , 703 , 705 , 706 , 707 , 709 , 710 , 712 , 737 , 738 , 741 , 746 , 754 , 755 , 756 , 757 , 758 , 759 , 760 , 763 , 765 , 778 , 780 , 795 , 825 , 828 , 885 , 890 , 891 , 895 , 897 , 902 , 933 , 946 , 953 , 957 , 981 , 982 , 983 , 984 , 987 , 988 , 989 , 995 , 1001 , 1003 , 1008 , 1011 , 1014 , 1015 , 1020 , 1022 , 1028 , 1168 , 1170 , 1181 , 1203 , 1222 , 1228 , 1229 , 1230 , 1267 , 1268 , 1275 , 1276 , 1277 , 1278 , 1280 , 1281 , 1283 , 1294 , 1305 , 1306 , 1307 , 1311 , 1312 , 1317 , 1338 , 1340 , 1341 , 1342 , 1343 , 1344 , 1345 , 1349 , 1350 , 1352 , 1353 , 1354 , 1356 , 1361 , 1451 , 1460 , 1543 , 1580 , 1654 , 1690 , 1699 , 1724 , 1744 , 1745 , 1747 , 1868 , 1928 , 1929 , 1990 , 2096 , 2129 , 2146 , 2147 , 2149 , 2152 , 2153 , 2159 , 2160 , 2163 , 2164 , 2166 , 2167 , 2168 , 2169 , 2171 , 2215 , 2216 , 2217 , 2218 , 2220 , 2255 , 2315 , 2445 , 2446 , 2447 , 2466 , 2482 , 2547 , 2553 , 2554 , 2560 , 2573 , 2574 , 2616 , 2650 , 2651 , 2653 , 2654 , 2662 , 2693 , 2694 , 2695 , 2709 , 2712 , 2719 , 2720 , 2721 , 2737 , 2744 , 2748 , 2750 , 2757 , 2781 , 2785 , 2786 , 2788 , 2796 , 2797 , 2803 , 2804 , 2813 , 2814 , 2824 , 2831 , 2832 , 2833 , 2834 , 2840 , 2856 , 2874 , 2875 , 2887 , 2891 , 2892 , 2895 , 2900 , 2901 , 2902 , 2912 , 2913 , 2969 , 2971 , 2976 , 2983 , 3036 , 3048 , 3089 , 3094 , 3095 , 3097 , 3098 , 3117 , 3118 , 3119 , 3126 , 3217 , 3224 , 3226 , 3234 , 3259 , 3410 , 3412 , 3445 , 3447 , 3451 , 3491 , 3492 , 3493 , 3495 , 3501 , 3518 , 3542 , 3583 , 3587 , 3596 , 3628 , 3636 , 3637 , 3731 , 3760 , 3762 , 3821 , 3834 , 3836 , 3852 , 3944 , 4000 , 4008 , 4009 , 4014 , 4027 , 4031 , 4032 , 4056 , 4075 , 4090 , 4092 , 4101 , 4104 , 4111 , 4123 , 4124 , 4132 , 4133 , 4134 , 4138 , 4168 , 4194 , 4229 , 4367 , 4368 , 4382 , 4429 , 4478 , 4559 , 4570 , 4571 , 4572 , 4592 , 4627 , 4629 , 4646 , 4660 , 4671 , 4690 , 4718 , 4749 , 4750 , 4753 , 4757 , 4774 , 4778 , 4795 , 4797 , 4799 , 4800 , 4803 , 4806 , 4811 , 4814 , 4925 , 4947 , 4984 , 5015 , 5020 , 5035 , 5048 , 5050 , 5052 , 5091 , 5106 , 5129 , 5131 , 5161 , 5162 , 5163 , 5199 , 5207 , 5208 , 5399 , 5401 , 5549 , 5586 , 5646 , 5757 , 5785 , 5820 , 5834 , 6137 , 6482 , 6649 , 6655 , 6808 , 7858 , 8145 , 8340 , 8431 , 8433 , 8779 , 8986 , 9106 , 9708 , 9748 , 10741 , 11286 , 11342 , 11496 , 12996 , 12997 , 13022 , 13358 , 13451 , 13845 , 14006 , 14559 , 15675 , 16644 , 16813 , 16859 , 16998 , 17408 , 18099 , 18473 , 19138 , 19168 , 19216 , 19483 , 19613 , 19638 , 19793 , 20030 , 20108 , 20273 , 20323 , 20533 , 20666 , 20943 , 20981 , 21124 , 21145 , 22067 , 22476 , 22479 , 22515 , 22676 , 22911 , 22914 , 23156 , 23240 , 23307 , 23500 , 23596 , 23609 , 23666 , 23671 , 23997 , 24799 , 24800 , 25582 , 25788 , 26092 , 26404 , 26539 , 27069 , 27082 , 27299 , 27635 , 28700 , 28857 , 29335 , 29384 , 29429 , 29824 , 30283 , 30324 , 30448 , 30808 , 30837 , 31709 , 31749 , 31773 , 31883 , 31903 , 32051 , 33275 , 33287 , 33589 , 33662 , 34647 , 35581 , 35582 , 35720 , 35740 , 36130 , 36335 , 36541 , 36569 , 36611 , 36875 , 36933 , 37020 , 37091 , 37310 , 37311 , 37312 , 37313 ) AND multimedia_classification . `idclassification` = 145 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia` AND schedules . `idspectacle` = spectacles . `idspectacle` AND spectacles . `idspectacle` = object_multimedia . `idobject` AND contacts . `idcontact` = schedules . `idcontact` AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia` AND multimedias . `idmultimedia` = multimedia_classification . `idmultimedia`
GROUP BY object_multimedia . `idobject`
ORDER BY schedules . `date`
ASC
LIMIT 0 , 100 ;
Copy
156
0.51 ms
SELECT t0 . idstat AS idstat_1 , t0 . type AS type_2 , t0 . module AS module_3 , t0 . url AS url_4 , t0 . idcontent AS idcontent_5 , t0 . object AS object_6 , t0 . idobject AS idobject_7 , t0 . video AS video_8 , t0 . remote_addr AS remote_addr_9 , t0 . lng AS lng_10 , t0 . source AS source_11 , t0 . md5url AS md5url_12 , t0 . dateinsert AS dateinsert_13 FROM stats t0 WHERE t0 . remote_addr = ? AND t0 . idcontent = ? AND t0 . md5url = ?
Parameters :
[
"8db5057c5c2618c585d304c96245c044-e1f2 "
0
"f7a9dd2099ff5456a4aff50d9c43845c "
]
SELECT t0 . idstat AS idstat_1 , t0 . type AS type_2 , t0 . module AS module_3 , t0 . url AS url_4 , t0 . idcontent AS idcontent_5 , t0 . object AS object_6 , t0 . idobject AS idobject_7 , t0 . video AS video_8 , t0 . remote_addr AS remote_addr_9 , t0 . lng AS lng_10 , t0 . source AS source_11 , t0 . md5url AS md5url_12 , t0 . dateinsert AS dateinsert_13 FROM stats t0 WHERE t0 . remote_addr = '8db5057c5c2618c585d304c96245c044-e1f2' AND t0 . idcontent = 0 AND t0 . md5url = 'f7a9dd2099ff5456a4aff50d9c43845c' ;
Copy
157
2.32 ms
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/biographies/Jean-Luc-Lagarce/ensavoirplus/idcontent/1215 "
"f7a9dd2099ff5456a4aff50d9c43845c "
0
"persons "
3
0
"fr "
"8db5057c5c2618c585d304c96245c044-e1f2 "
"/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553 "
]
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES ('article' , 'thnet' , '/biographies/Jean-Luc-Lagarce/ensavoirplus/idcontent/1215' , 'f7a9dd2099ff5456a4aff50d9c43845c' , 0 , 'persons' , 3 , 0 , 'fr' , '8db5057c5c2618c585d304c96245c044-e1f2' , '/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553' );
Copy
158
0.71 ms
SELECT * FROM bannieres
WHERE publish = 1
AND valid = 1
AND is_bottom = 1
AND date_start < = NOW()
AND date_end > = NOW()
ORDER BY bannieres . order ASC
LIMIT 0 , 10
SELECT * FROM bannieres
WHERE publish = 1
AND valid = 1
AND is_bottom = 1
AND date_start < = NOW()
AND date_end > = NOW()
ORDER BY bannieres . order ASC
LIMIT 0 , 10 ;
Copy