1
0.67 ms
SELECT idperson FROM persons WHERE url_clean = 'Marion-Aubert'
SELECT idperson FROM persons WHERE url_clean = 'Marion-Aubert' ;
Copy
2
0.42 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 = 1281 ;
Copy
3
0.88 ms
SELECT COUNT (DISTINCT (t . idtext ))
FROM text_author ta , texts t
WHERE t . idtext = ta . idtext AND t . textfictif = 0
AND ta . idperson = 1281 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 = 1281 AND t . publish = 1 AND t . type IN (0 , 2 ) ;
Copy
4
0.93 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 = 1281 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 = 1281 AND t . publish = 1 ;
Copy
5
0.60 ms
SELECT COUNT (DISTINCT (sp . idspectacle )) as total
FROM spectacle_person sp , spectacles s
WHERE 1
AND sp . idspectacle = s . idspectacle
AND sp . idperson = 1281
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 = 1281
AND sp . idrole = 1 AND s . publish = 1 ;
Copy
6
0.08 ms
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
7
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
8
0.71 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 = 1281 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 = 1281 AND j2 . idoffice = 1 ;
Copy
9
0.07 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
2.37 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 = '1281'
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 = '1281'
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 = 130365
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 = 130365 ;
Copy
12
0.08 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
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 = '1281'
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 = '1281'
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.95 ms
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (1281 )
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (1281 ) ;
Copy
15
0.88 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 (1281 )
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 (1281 ) ;
Copy
16
0.30 ms
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (1281 )
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (1281 ) ;
Copy
17
0.76 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 (1281 )
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 (1281 ) ;
Copy
18
0.81 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` = 1281 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` = 1281 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
19
0.48 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 16826
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 16826
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
20
0.53 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15740
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15740
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
21
0.51 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15535
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15535
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
22
0.45 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15739
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15739
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
23
0.37 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15735
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15735
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
24
0.51 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15506
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15506
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
25
0.43 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15484
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15484
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
26
0.45 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 12293
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 12293
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
27
0.35 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 12292
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 12292
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
28
0.40 ms
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 12291
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 12291
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
29
2.61 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 (763 , 1259 , 1684 , 1713 , 2760 , 3638 , 4084 , 4153 , 4496 , 4638 , 5150 , 7650 , 8162 , 8582 , 9498 , 11885 , 16679 , 18457 , 18593 , 18900 , 20066 , 20596 , 21572 , 21971 , 22623 , 22908 , 23992 , 24458 , 28310 , 29099 , 31085 , 31391 , 32823 , 33309 , 33880 , 34067 , 35712 )
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 (763 , 1259 , 1684 , 1713 , 2760 , 3638 , 4084 , 4153 , 4496 , 4638 , 5150 , 7650 , 8162 , 8582 , 9498 , 11885 , 16679 , 18457 , 18593 , 18900 , 20066 , 20596 , 21572 , 21971 , 22623 , 22908 , 23992 , 24458 , 28310 , 29099 , 31085 , 31391 , 32823 , 33309 , 33880 , 34067 , 35712 ) ;
Copy
30
1.82 ms
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note 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 = 1281 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date > = '2024-04-27' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note 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 = 1281 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date > = '2024-04-27' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC ;
Copy
31
2.41 ms
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note 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 = 1281 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date < '2024-04-27' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 3
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note 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 = 1281 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date < '2024-04-27' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 3 ;
Copy
32
0.63 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '13349' ;
Copy
33
0.68 ms
SELECT url_file FROM news WHERE idnew = 13349
SELECT url_file FROM news WHERE idnew = 13349 ;
Copy
34
0.49 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13349 AND sc . date < '2024-04-27' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13349 AND sc . date < '2024-04-27' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
35
0.68 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13349 AND sc . date < '2024-04-27' AND sc . idcontact = 233 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13349 AND sc . date < '2024-04-27' AND sc . idcontact = 233 GROUP BY sc . idcontact ;
Copy
36
0.68 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13349
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13349 ;
Copy
37
0.74 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13349
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13349 ;
Copy
38
0.46 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13349
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13349 ;
Copy
39
1.03 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13349
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13349 ;
Copy
40
0.46 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '12405' ;
Copy
41
0.26 ms
SELECT url_file FROM news WHERE idnew = 12405
SELECT url_file FROM news WHERE idnew = 12405 ;
Copy
42
0.51 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12405 AND sc . date < '2024-04-27' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12405 AND sc . date < '2024-04-27' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
43
0.50 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12405 AND sc . date < '2024-04-27' AND sc . idcontact = 20423 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12405 AND sc . date < '2024-04-27' AND sc . idcontact = 20423 GROUP BY sc . idcontact ;
Copy
44
0.36 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12405
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12405 ;
Copy
45
0.37 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12405
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12405 ;
Copy
46
0.30 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12405
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12405 ;
Copy
47
0.37 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12405
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12405 ;
Copy
48
0.34 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '12352' ;
Copy
49
0.44 ms
SELECT url_file FROM news WHERE idnew = 12352
SELECT url_file FROM news WHERE idnew = 12352 ;
Copy
50
0.56 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12352 AND sc . date < '2024-04-27' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12352 AND sc . date < '2024-04-27' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
51
0.54 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12352 AND sc . date < '2024-04-27' AND sc . idcontact = 14647 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12352 AND sc . date < '2024-04-27' AND sc . idcontact = 14647 GROUP BY sc . idcontact ;
Copy
52
0.65 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12352
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12352 ;
Copy
53
0.50 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12352
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12352 ;
Copy
54
0.59 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12352
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12352 ;
Copy
55
0.30 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20335
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20335 ;
Copy
56
0.20 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24070
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24070 ;
Copy
57
0.22 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31381
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31381 ;
Copy
58
0.24 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31382
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31382 ;
Copy
59
0.20 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31383
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31383 ;
Copy
60
0.19 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31384
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31384 ;
Copy
61
0.19 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31385
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31385 ;
Copy
62
0.23 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31386
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31386 ;
Copy
63
0.19 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31387
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31387 ;
Copy
64
0.23 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31388
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31388 ;
Copy
65
0.39 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31389
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31389 ;
Copy
66
0.19 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31390
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31390 ;
Copy
67
0.31 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31391
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31391 ;
Copy
68
0.29 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31392
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31392 ;
Copy
69
0.22 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31393
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31393 ;
Copy
70
0.59 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31394
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31394 ;
Copy
71
0.21 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31395
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31395 ;
Copy
72
0.19 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31396
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31396 ;
Copy
73
0.37 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31397
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31397 ;
Copy
74
0.26 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31398
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31398 ;
Copy
75
0.25 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31399
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31399 ;
Copy
76
0.25 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31400
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31400 ;
Copy
77
0.30 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31401
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31401 ;
Copy
78
0.23 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31402
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31402 ;
Copy
79
0.53 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12352
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12352 ;
Copy
80
0.21 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 25117 ;
Copy
81
0.34 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 25117 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 25117 ORDER BY j2 . classement ASC ;
Copy
82
0.16 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 29827 ;
Copy
83
0.42 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 29827 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 29827 ORDER BY j2 . classement ASC ;
Copy
84
0.16 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 35906 ;
Copy
85
0.33 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 35906 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 35906 ORDER BY j2 . classement ASC ;
Copy
86
0.42 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 36674 ;
Copy
87
0.45 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 36674 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 36674 ORDER BY j2 . classement ASC ;
Copy
88
0.24 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 37297 ;
Copy
89
0.58 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 37297
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 37297
ORDER BY t . title ;
Copy
90
0.55 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37296 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37296 ORDER BY j2 . classement ASC ;
Copy
91
0.43 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 37318 ;
Copy
92
0.56 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 37318
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 37318
ORDER BY t . title ;
Copy
93
0.56 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37317 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37317 ORDER BY j2 . classement ASC ;
Copy
94
0.43 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 37465 ;
Copy
95
0.58 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37465 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37465 ORDER BY j2 . classement ASC ;
Copy
96
0.46 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 37466 ;
Copy
97
0.57 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37466 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37466 ORDER BY j2 . classement ASC ;
Copy
98
0.41 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 37597 ;
Copy
99
0.55 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 37597
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 37597
ORDER BY t . title ;
Copy
100
0.52 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37596 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37596 ORDER BY j2 . classement ASC ;
Copy
101
0.25 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 37812 ;
Copy
102
0.36 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37812 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37812 ORDER BY j2 . classement ASC ;
Copy
103
0.21 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 38108 ;
Copy
104
0.33 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 38108
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 38108
ORDER BY t . title ;
Copy
105
0.43 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38107 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38107 ORDER BY j2 . classement ASC ;
Copy
106
0.41 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 38994 ;
Copy
107
0.50 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38994 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38994 ORDER BY j2 . classement ASC ;
Copy
108
0.28 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 38997 ;
Copy
109
0.42 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 38997
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 38997
ORDER BY t . title ;
Copy
110
0.40 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38995 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38995 ORDER BY j2 . classement ASC ;
Copy
111
0.19 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 38999 ;
Copy
112
0.31 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 38999
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 38999
ORDER BY t . title ;
Copy
113
0.33 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38998 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38998 ORDER BY j2 . classement ASC ;
Copy
114
0.21 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39012 ;
Copy
115
0.36 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39012
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39012
ORDER BY t . title ;
Copy
116
0.40 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39000 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39000 ORDER BY j2 . classement ASC ;
Copy
117
0.20 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39013 ;
Copy
118
0.30 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39013
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39013
ORDER BY t . title ;
Copy
119
0.36 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39001 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39001 ORDER BY j2 . classement ASC ;
Copy
120
0.39 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39014 ;
Copy
121
0.28 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39014
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39014
ORDER BY t . title ;
Copy
122
0.50 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39002 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39002 ORDER BY j2 . classement ASC ;
Copy
123
0.25 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39015 ;
Copy
124
0.57 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39015
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39015
ORDER BY t . title ;
Copy
125
0.61 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39003 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39003 ORDER BY j2 . classement ASC ;
Copy
126
0.44 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39016 ;
Copy
127
0.48 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39016
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39016
ORDER BY t . title ;
Copy
128
0.53 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39004 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39004 ORDER BY j2 . classement ASC ;
Copy
129
0.46 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39005 ;
Copy
130
0.57 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39005 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39005 ORDER BY j2 . classement ASC ;
Copy
131
0.50 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39006 ;
Copy
132
0.57 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39006 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39006 ORDER BY j2 . classement ASC ;
Copy
133
0.38 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39007 ;
Copy
134
0.56 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39007 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39007 ORDER BY j2 . classement ASC ;
Copy
135
0.43 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39008 ;
Copy
136
0.54 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39008 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39008 ORDER BY j2 . classement ASC ;
Copy
137
0.21 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39017 ;
Copy
138
0.53 ms
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39017
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 39017
ORDER BY t . title ;
Copy
139
0.48 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38704 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38704 ORDER BY j2 . classement ASC ;
Copy
140
1.72 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 (1281 ) 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 (1281 ) AND c . `classification` = 'class_auteur_meme' ;
Copy
141
0.58 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` = 1281 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` = 1281 AND c . `classification` = 'class_auteur_meme' LIMIT 0 , 1 ;
Copy
142
0.24 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 = '12' ;
Copy
143
0.51 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 = 12
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 = 12 ;
Copy
144
0.51 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 = 12
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 = 12 ;
Copy
145
0.53 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 = 12
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 = 12 ;
Copy
146
0.45 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 = 12
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 = 12 ;
Copy
147
0.89 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 = 12 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 = 12 ORDER BY j2 . `orderplaylist` ;
Copy
148
0.55 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 = 12
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 = 12 ;
Copy
149
3.23 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 (763 , 1259 , 1684 , 1713 , 2760 , 3638 , 4084 , 4153 , 4496 , 4638 , 5150 , 7650 , 8162 , 8582 , 9498 , 11885 , 16679 , 18457 , 18593 , 18900 , 20066 , 20596 , 21572 , 21971 , 22623 , 22908 , 23992 , 24458 , 28310 , 29099 , 31085 , 31391 , 32823 , 33309 , 33880 , 34067 , 35712 ) AND s . date > = '2024-04-27' 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 (
763 , 1259 , 1684 , 1713 , 2760 , 3638 , 4084 ,
4153 , 4496 , 4638 , 5150 , 7650 , 8162 ,
8582 , 9498 , 11885 , 16679 , 18457 , 18593 ,
18900 , 20066 , 20596 , 21572 , 21971 ,
22623 , 22908 , 23992 , 24458 , 28310 ,
29099 , 31085 , 31391 , 32823 , 33309 ,
33880 , 34067 , 35712
)
AND s . date > = '2024-04-27'
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 (763 , 1259 , 1684 , 1713 , 2760 , 3638 , 4084 , 4153 , 4496 , 4638 , 5150 , 7650 , 8162 , 8582 , 9498 , 11885 , 16679 , 18457 , 18593 , 18900 , 20066 , 20596 , 21572 , 21971 , 22623 , 22908 , 23992 , 24458 , 28310 , 29099 , 31085 , 31391 , 32823 , 33309 , 33880 , 34067 , 35712 ) AND s . date > = '2024-04-27' ORDER BY s . date ASC LIMIT 0 , 1 ;
Copy
150
1.25 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 = 1281 ) 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 = 1281 ) AND T1 . publish = 1 ;
Copy
151
1.20 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 1281
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 = 1281
AND om . object = 'persons'
AND m . publish = 1 ;
Copy
152
1.31 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` = 1281 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` = 1281 AND d . code_franceinter IS NOT NULL ;
Copy
153
0.98 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` = 1281 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` = 1281 AND d . code_soundcloud IS NOT NULL ;
Copy
154
1.97 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 (1639 , 2150 , 2167 , 2179 , 3369 , 4824 , 5698 , 5821 , 6121 , 6535 , 6536 , 6537 , 6539 , 8286 , 10395 , 10396 , 11809 , 15495 , 18856 , 18857 , 20955 , 23624 , 25181 , 25886 , 26854 , 27315 , 28491 , 29197 , 29691 , 29834 , 30259 , 32317 , 35088 , 35906 , 37153 , 39642 , 39663 , 39893 , 41151 , 41831 , 44010 , 20956 ) 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 (
1639 , 2150 , 2167 , 2179 , 3369 , 4824 , 5698 ,
5821 , 6121 , 6535 , 6536 , 6537 , 6539 ,
8286 , 10395 , 10396 , 11809 , 15495 , 18856 ,
18857 , 20955 , 23624 , 25181 , 25886 ,
26854 , 27315 , 28491 , 29197 , 29691 ,
29834 , 30259 , 32317 , 35088 , 35906 ,
37153 , 39642 , 39663 , 39893 , 41151 ,
41831 , 44010 , 20956
)
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 (1639 , 2150 , 2167 , 2179 , 3369 , 4824 , 5698 , 5821 , 6121 , 6535 , 6536 , 6537 , 6539 , 8286 , 10395 , 10396 , 11809 , 15495 , 18856 , 18857 , 20955 , 23624 , 25181 , 25886 , 26854 , 27315 , 28491 , 29197 , 29691 , 29834 , 30259 , 32317 , 35088 , 35906 , 37153 , 39642 , 39663 , 39893 , 41151 , 41831 , 44010 , 20956 ) ORDER BY publication_year DESC ;
Copy
155
3.07 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 (763 , 1259 , 1684 , 1713 , 2760 , 3638 , 4084 , 4153 , 4496 , 4638 , 5150 , 7650 , 8162 , 8582 , 9498 , 11885 , 16679 , 18457 , 18593 , 18900 , 20066 , 20596 , 21572 , 21971 , 22623 , 22908 , 23992 , 24458 , 28310 , 29099 , 31085 , 31391 , 32823 , 33309 , 33880 , 34067 , 35712 ) 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 (
763 , 1259 , 1684 , 1713 , 2760 , 3638 , 4084 ,
4153 , 4496 , 4638 , 5150 , 7650 , 8162 ,
8582 , 9498 , 11885 , 16679 , 18457 , 18593 ,
18900 , 20066 , 20596 , 21572 , 21971 ,
22623 , 22908 , 23992 , 24458 , 28310 ,
29099 , 31085 , 31391 , 32823 , 33309 ,
33880 , 34067 , 35712
)
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 (763 , 1259 , 1684 , 1713 , 2760 , 3638 , 4084 , 4153 , 4496 , 4638 , 5150 , 7650 , 8162 , 8582 , 9498 , 11885 , 16679 , 18457 , 18593 , 18900 , 20066 , 20596 , 21572 , 21971 , 22623 , 22908 , 23992 , 24458 , 28310 , 29099 , 31085 , 31391 , 32823 , 33309 , 33880 , 34067 , 35712 ) 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
1.47 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 :
[
"01dd98061df34401c892421f13c2dcf4-9a02 "
0
"15d19be950a47b1a81e3de26de53cccd "
]
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 = '01dd98061df34401c892421f13c2dcf4-9a02' AND t0 . idcontent = 0 AND t0 . md5url = '15d19be950a47b1a81e3de26de53cccd' ;
Copy
157
2.01 ms
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/biographies/Marion-Aubert/evenements/ "
"15d19be950a47b1a81e3de26de53cccd "
0
"persons "
1281
0
"fr "
"01dd98061df34401c892421f13c2dcf4-9a02 "
"/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/Marion-Aubert/evenements/' , '15d19be950a47b1a81e3de26de53cccd' , 0 , 'persons' , 1281 , 0 , 'fr' , '01dd98061df34401c892421f13c2dcf4-9a02' , '/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553' );
Copy
158
0.12 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
159
0.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 = '1281'
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 = '1281'
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
160
1.29 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