1
0.26 ms
SELECT idperson FROM persons WHERE url_clean = 'Victor-Hugo'
SELECT idperson FROM persons WHERE url_clean = 'Victor-Hugo' ;
Copy
2
0.35 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 = 21494 ;
Copy
3
0.85 ms
SELECT COUNT (DISTINCT (t . idtext ))
FROM text_author ta , texts t
WHERE t . idtext = ta . idtext AND t . textfictif = 0
AND ta . idperson = 21494 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 = 21494 AND t . publish = 1 AND t . type IN (0 , 2 ) ;
Copy
4
0.50 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 = 21494 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 = 21494 AND t . publish = 1 ;
Copy
5
0.40 ms
SELECT COUNT (DISTINCT (sp . idspectacle )) as total
FROM spectacle_person sp , spectacles s
WHERE 1
AND sp . idspectacle = s . idspectacle
AND sp . idperson = 21494
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 = 21494
AND sp . idrole = 1 AND s . publish = 1 ;
Copy
6
0.06 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.44 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 = 21494 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 = 21494 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
1.34 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 = '21494'
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 = '21494'
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.49 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 = 44242
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 = 44242 ;
Copy
12
0.06 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.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 = '21494'
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 = '21494'
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.41 ms
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (21494 )
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (21494 ) ;
Copy
15
0.45 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 (21494 )
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 (21494 ) ;
Copy
16
0.30 ms
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (21494 )
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (21494 ) ;
Copy
17
0.36 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 (21494 )
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 (21494 ) ;
Copy
18
964.33 ms
SELECT s . `idspectacle`
FROM spectacles s
LEFT JOIN spectacle_person sp ON sp . `idspectacle` = s . `idspectacle`
LEFT JOIN text_spectacle ts ON ts . `idspectacle` = s . `idspectacle`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND (sp . `idperson` = 21494 OR ts . `idtext` IN (8153 , 8978 , 9077 , 9300 , 9703 , 10599 , 11108 , 11389 , 11390 , 11423 , 12548 , 13214 , 13247 , 13632 , 13783 , 14519 , 15039 , 23169 , 25304 , 27070 , 28872 , 32205 , 35300 , 38404 , 38483 , 38484 , 38509 , 38510 , 39948 , 42541 , 38385 , 37241 , 41608 , 14959 , 24016 , 9303 , 10602 , 14032 , 18057 , 21434 , 25150 , 14015 , 25492 , 35769 , 35834 , 19253 , 13222 , 22076 , 23756 , 29550 , 36209 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126 , 13812 , 24136 , 15122 , 27568 , 37507 , 43150 , 23260 , 28880 , 35302 , 38405 , 39950 , 27168 ) )
SELECT
s . `idspectacle`
FROM
spectacles s
LEFT JOIN spectacle_person sp ON sp . `idspectacle` = s . `idspectacle`
LEFT JOIN text_spectacle ts ON ts . `idspectacle` = s . `idspectacle`
WHERE
s . `publish` = 1
AND s . `valid` = 1
AND (
sp . `idperson` = 21494
OR ts . `idtext` IN (
8153 , 8978 , 9077 , 9300 , 9703 , 10599 ,
11108 , 11389 , 11390 , 11423 , 12548 ,
13214 , 13247 , 13632 , 13783 , 14519 ,
15039 , 23169 , 25304 , 27070 , 28872 ,
32205 , 35300 , 38404 , 38483 , 38484 ,
38509 , 38510 , 39948 , 42541 , 38385 ,
37241 , 41608 , 14959 , 24016 , 9303 , 10602 ,
14032 , 18057 , 21434 , 25150 , 14015 ,
25492 , 35769 , 35834 , 19253 , 13222 ,
22076 , 23756 , 29550 , 36209 , 8225 , 8615 ,
13633 , 15263 , 16352 , 17721 , 18748 ,
18902 , 20366 , 30312 , 32934 , 35062 ,
36897 , 39445 , 40713 , 43126 , 13812 ,
24136 , 15122 , 27568 , 37507 , 43150 ,
23260 , 28880 , 35302 , 38405 , 39950 ,
27168
)
)
Copy
SELECT s . `idspectacle`
FROM spectacles s
LEFT JOIN spectacle_person sp ON sp . `idspectacle` = s . `idspectacle`
LEFT JOIN text_spectacle ts ON ts . `idspectacle` = s . `idspectacle`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND (sp . `idperson` = 21494 OR ts . `idtext` IN (8153 , 8978 , 9077 , 9300 , 9703 , 10599 , 11108 , 11389 , 11390 , 11423 , 12548 , 13214 , 13247 , 13632 , 13783 , 14519 , 15039 , 23169 , 25304 , 27070 , 28872 , 32205 , 35300 , 38404 , 38483 , 38484 , 38509 , 38510 , 39948 , 42541 , 38385 , 37241 , 41608 , 14959 , 24016 , 9303 , 10602 , 14032 , 18057 , 21434 , 25150 , 14015 , 25492 , 35769 , 35834 , 19253 , 13222 , 22076 , 23756 , 29550 , 36209 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126 , 13812 , 24136 , 15122 , 27568 , 37507 , 43150 , 23260 , 28880 , 35302 , 38405 , 39950 , 27168 ) );
Copy
19
0.58 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` = 21494 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` = 21494 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
20
4.19 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 (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 )
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 (
5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 ,
6702 , 7484 , 7993 , 8282 , 8587 , 9230 ,
9849 , 9873 , 10217 , 10365 , 10376 , 10410 ,
10449 , 10601 , 10627 , 11388 , 11434 ,
11504 , 11511 , 11659 , 12658 , 13436 ,
13870 , 14092 , 14803 , 14876 , 14885 ,
15054 , 16118 , 17519 , 17599 , 18465 ,
18506 , 18555 , 18980 , 19215 , 20049 ,
20190 , 20377 , 20713 , 21622 , 21793 ,
21866 , 22100 , 23860 , 24496 , 24798 ,
24961 , 25776 , 26408 , 26491 , 27561 ,
28348 , 28574 , 28649 , 28978 , 29289 ,
29799 , 30120 , 30289 , 30475 , 30512 ,
30541 , 30652 , 30859 , 30883 , 30969 ,
30975 , 31118 , 31148 , 31764 , 32104 ,
32214 , 32548 , 33333 , 34272 , 34807 ,
34829 , 36482 , 37021
)
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 (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 ) ;
Copy
21
1.36 ms
SELECT t . `idtext` , t . `title` , t . `date` , t . `type` , t . `language` , t . `country` , t . `idcontact_publisher` , t . `isbn` , t . `ean` , t . `publication_year` , t . `nbpages` , t . `idgenretext` , t . `textorder` , t . `url_clean` , contacts . `organisation` , contacts . `url_clean` as url_clean_publisher
FROM text_author ta , texts t
LEFT JOIN contacts ON contacts . idcontact = t . idcontact_publisher
WHERE 1
AND t . idtext = ta . idtext
AND ta . idperson = 21494
AND t . type = 0 AND t . publish = 1 AND t . textfictif = 0 GROUP BY t . idtext ORDER BY date DESC
SELECT t . `idtext` , t . `title` , t . `date` , t . `type` , t . `language` , t . `country` , t . `idcontact_publisher` , t . `isbn` , t . `ean` , t . `publication_year` , t . `nbpages` , t . `idgenretext` , t . `textorder` , t . `url_clean` , contacts . `organisation` , contacts . `url_clean` as url_clean_publisher
FROM text_author ta , texts t
LEFT JOIN contacts ON contacts . idcontact = t . idcontact_publisher
WHERE 1
AND t . idtext = ta . idtext
AND ta . idperson = 21494
AND t . type = 0 AND t . publish = 1 AND t . textfictif = 0 GROUP BY t . idtext ORDER BY date DESC ;
Copy
22
0.37 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 = '13247' ;
Copy
23
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 = 13247 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 = 13247 ORDER BY j2 . classement ASC ;
Copy
24
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
25
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 = '13247'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '13247'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
26
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
27
0.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 = '13247'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '13247'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
28
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
29
0.03 ms
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
30
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 = '9300' ;
Copy
31
0.37 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 = 9300 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 = 9300 ORDER BY j2 . classement ASC ;
Copy
32
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
33
1.32 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 = '9300'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '9300'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
34
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
35
0.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 = '9300'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '9300'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
36
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
37
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 = '32205' ;
Copy
38
0.38 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 = 32205 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 = 32205 ORDER BY j2 . classement ASC ;
Copy
39
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
40
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 = '32205'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '32205'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
41
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
42
0.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 = '32205'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '32205'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
43
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
44
0.18 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 = '13214' ;
Copy
45
0.29 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 = 13214 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 = 13214 ORDER BY j2 . classement ASC ;
Copy
46
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
47
0.99 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 = '13214'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '13214'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
48
0.08 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
49
0.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 = '13214'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '13214'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
50
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
51
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 = '11108' ;
Copy
52
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 = 11108 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 = 11108 ORDER BY j2 . classement ASC ;
Copy
53
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
54
1.02 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 = '11108'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '11108'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
55
0.04 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
56
0.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 = '11108'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '11108'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
57
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
58
0.17 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 = '28872' ;
Copy
59
0.29 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 = 28872 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 = 28872 ORDER BY j2 . classement ASC ;
Copy
60
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
61
1.00 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 = '28872'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '28872'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
62
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
63
0.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 = '28872'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '28872'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
64
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
65
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 = '13632' ;
Copy
66
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 = 13632 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 = 13632 ORDER BY j2 . classement ASC ;
Copy
67
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
68
1.02 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 = '13632'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '13632'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
69
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
70
0.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 = '13632'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '13632'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
71
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
72
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 = '14519' ;
Copy
73
0.28 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 = 14519 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 = 14519 ORDER BY j2 . classement ASC ;
Copy
74
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
75
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 = '14519'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '14519'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
76
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
77
0.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 = '14519'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '14519'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
78
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
79
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 = '12548' ;
Copy
80
0.37 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 = 12548 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 = 12548 ORDER BY j2 . classement ASC ;
Copy
81
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
82
1.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 = '12548'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '12548'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
83
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
84
0.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 = '12548'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '12548'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
85
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
86
0.23 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 = '23169' ;
Copy
87
0.38 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 = 23169 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 = 23169 ORDER BY j2 . classement ASC ;
Copy
88
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
89
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 = '23169'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '23169'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
90
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
91
0.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 = '23169'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '23169'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
92
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
93
0.48 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 = '9077' ;
Copy
94
0.76 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 = 9077 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 = 9077 ORDER BY j2 . classement ASC ;
Copy
95
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
96
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 = '11423' ;
Copy
97
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 = 11423 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 = 11423 ORDER BY j2 . classement ASC ;
Copy
98
0.14 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
99
1.20 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 = '11423'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '11423'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
100
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
101
0.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 = '11423'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '11423'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
102
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
103
0.26 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 = '13783' ;
Copy
104
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 = 13783 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 = 13783 ORDER BY j2 . classement ASC ;
Copy
105
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
106
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 = '13783'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '13783'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
107
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
108
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 = '13783'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '13783'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
109
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
110
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 = '9703' ;
Copy
111
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 = 9703 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 = 9703 ORDER BY j2 . classement ASC ;
Copy
112
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
113
1.27 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 = '9703'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '9703'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
114
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
115
0.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 = '9703'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '9703'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
116
0.11 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
117
0.27 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 = '8978' ;
Copy
118
0.41 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 = 8978 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 = 8978 ORDER BY j2 . classement ASC ;
Copy
119
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
120
1.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 = '8978'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '8978'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
121
0.08 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
122
0.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 = '8978'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '8978'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
123
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
124
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 = '15039' ;
Copy
125
0.35 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 = 15039 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 = 15039 ORDER BY j2 . classement ASC ;
Copy
126
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
127
1.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 = '15039'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '15039'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
128
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
129
0.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 = '15039'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '15039'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
130
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
131
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 = '25304' ;
Copy
132
0.35 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 = 25304 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 = 25304 ORDER BY j2 . classement ASC ;
Copy
133
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
134
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 = '25304'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '25304'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
135
0.13 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 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 = '25304'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '25304'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
137
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
138
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 = '8153' ;
Copy
139
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 = 8153 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 = 8153 ORDER BY j2 . classement ASC ;
Copy
140
0.11 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
141
0.30 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 = '11390' ;
Copy
142
0.63 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 = 11390 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 = 11390 ORDER BY j2 . classement ASC ;
Copy
143
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
144
0.99 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 = '11390'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '11390'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
145
0.28 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
146
0.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 = '11390'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '11390'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
147
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
148
0.30 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 = '11389' ;
Copy
149
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 = 11389 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 = 11389 ORDER BY j2 . classement ASC ;
Copy
150
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
151
1.14 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 = '11389'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '11389'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
152
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
153
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 = '11389'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '11389'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
154
0.04 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
155
0.27 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 = '10599' ;
Copy
156
0.41 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 = 10599 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 = 10599 ORDER BY j2 . classement ASC ;
Copy
157
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
158
1.35 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 = '10599'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '10599'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
159
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
160
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 = '10599'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '10599'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
161
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
162
0.33 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 = '27070' ;
Copy
163
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 = 27070 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 = 27070 ORDER BY j2 . classement ASC ;
Copy
164
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
165
1.37 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 = '27070'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '27070'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
166
0.10 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
167
0.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 = '27070'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '27070'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
168
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
169
0.22 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 = '35300' ;
Copy
170
0.35 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 = 35300 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 = 35300 ORDER BY j2 . classement ASC ;
Copy
171
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
172
1.44 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 = '35300'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '35300'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
173
0.08 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
174
0.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 = '35300'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) 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 = '35300'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
175
0.21 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
176
0.26 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 = '38404' ;
Copy
177
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 = 38404 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 = 38404 ORDER BY j2 . classement ASC ;
Copy
178
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
179
0.30 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 = '38483' ;
Copy
180
0.41 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 = 38483 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 = 38483 ORDER BY j2 . classement ASC ;
Copy
181
0.06 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
182
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 = '38484' ;
Copy
183
0.32 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 = 38484 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 = 38484 ORDER BY j2 . classement ASC ;
Copy
184
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
185
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 = '38509' ;
Copy
186
0.31 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 = 38509 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 = 38509 ORDER BY j2 . classement ASC ;
Copy
187
0.05 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
188
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 = '38510' ;
Copy
189
0.51 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 = 38510 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 = 38510 ORDER BY j2 . classement ASC ;
Copy
190
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
191
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 = '39948' ;
Copy
192
0.35 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 = 39948 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 = 39948 ORDER BY j2 . classement ASC ;
Copy
193
0.07 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
194
0.04 ms
SELECT idgenretext , genretext FROM genretexts ORDER BY ordergenre
SELECT idgenretext , genretext FROM genretexts ORDER BY ordergenre ;
Copy
195
0.19 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 13247
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 13247 ;
Copy
196
0.12 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 13247
SELECT t . idtext FROM texts t WHERE t . idtext = 13247 ;
Copy
197
0.37 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 13247
OR ts . idtext IN (
13247
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 13247
OR ts . idtext IN (
13247
));
Copy
198
0.27 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 13247 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 13247 AND t . publish = 1 ;
Copy
199
0.16 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 9300
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 9300 ;
Copy
200
0.11 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 9300
SELECT t . idtext FROM texts t WHERE t . idtext = 9300 ;
Copy
201
0.29 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 9300
OR ts . idtext IN (
9300 , 9303
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 9300
OR ts . idtext IN (
9300 , 9303
));
Copy
202
0.24 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 9300 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 9300 AND t . publish = 1 ;
Copy
203
0.16 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 32205
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 32205 ;
Copy
204
0.32 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 32205
SELECT t . idtext FROM texts t WHERE t . idtext = 32205 ;
Copy
205
0.29 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 32205
OR ts . idtext IN (
32205
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 32205
OR ts . idtext IN (
32205
));
Copy
206
0.23 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 32205 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 32205 AND t . publish = 1 ;
Copy
207
0.16 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 13214
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 13214 ;
Copy
208
0.12 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 13214
SELECT t . idtext FROM texts t WHERE t . idtext = 13214 ;
Copy
209
0.41 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 13214
OR ts . idtext IN (
13214 , 13222 , 22076 , 23756 , 29550 , 36209
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 13214
OR ts . idtext IN (
13214 , 13222 , 22076 , 23756 , 29550 , 36209
));
Copy
210
0.28 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 13214 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 13214 AND t . publish = 1 ;
Copy
211
0.21 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 11108
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 11108 ;
Copy
212
0.11 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 11108
SELECT t . idtext FROM texts t WHERE t . idtext = 11108 ;
Copy
213
0.27 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 11108
OR ts . idtext IN (
11108
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 11108
OR ts . idtext IN (
11108
));
Copy
214
0.21 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 11108 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 11108 AND t . publish = 1 ;
Copy
215
0.16 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 28872
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 28872 ;
Copy
216
0.23 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 28872
SELECT t . idtext FROM texts t WHERE t . idtext = 28872 ;
Copy
217
0.47 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 28872
OR ts . idtext IN (
28872 , 28880
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 28872
OR ts . idtext IN (
28872 , 28880
));
Copy
218
0.23 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 28872 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 28872 AND t . publish = 1 ;
Copy
219
0.18 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 13632
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 13632 ;
Copy
220
0.19 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 13632
SELECT t . idtext FROM texts t WHERE t . idtext = 13632 ;
Copy
221
0.74 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 13632
OR ts . idtext IN (
13632 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 13632
OR ts . idtext IN (
13632 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126
));
Copy
222
0.39 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 13632 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 13632 AND t . publish = 1 ;
Copy
223
0.39 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 14519
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 14519 ;
Copy
224
0.20 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 14519
SELECT t . idtext FROM texts t WHERE t . idtext = 14519 ;
Copy
225
0.36 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 14519
OR ts . idtext IN (
14519 , 15122
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 14519
OR ts . idtext IN (
14519 , 15122
));
Copy
226
0.27 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 14519 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 14519 AND t . publish = 1 ;
Copy
227
2.11 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 12548
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 12548 ;
Copy
228
0.22 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 12548
SELECT t . idtext FROM texts t WHERE t . idtext = 12548 ;
Copy
229
0.35 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 12548
OR ts . idtext IN (
12548
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 12548
OR ts . idtext IN (
12548
));
Copy
230
0.27 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 12548 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 12548 AND t . publish = 1 ;
Copy
231
0.21 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 23169
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 23169 ;
Copy
232
0.17 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 23169
SELECT t . idtext FROM texts t WHERE t . idtext = 23169 ;
Copy
233
0.35 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 23169
OR ts . idtext IN (
23169 , 23260
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 23169
OR ts . idtext IN (
23169 , 23260
));
Copy
234
2.80 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 23169 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 23169 AND t . publish = 1 ;
Copy
235
0.26 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 9077
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 9077 ;
Copy
236
0.29 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 9077
SELECT t . idtext FROM texts t WHERE t . idtext = 9077 ;
Copy
237
0.47 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 9077
OR ts . idtext IN (
9077 , 14959 , 24016
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 9077
OR ts . idtext IN (
9077 , 14959 , 24016
));
Copy
238
0.28 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 9077 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 9077 AND t . publish = 1 ;
Copy
239
0.22 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 11423
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 11423 ;
Copy
240
0.18 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 11423
SELECT t . idtext FROM texts t WHERE t . idtext = 11423 ;
Copy
241
0.44 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 11423
OR ts . idtext IN (
11423 , 19253
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 11423
OR ts . idtext IN (
11423 , 19253
));
Copy
242
0.30 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 11423 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 11423 AND t . publish = 1 ;
Copy
243
0.28 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 13783
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 13783 ;
Copy
244
0.34 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 13783
SELECT t . idtext FROM texts t WHERE t . idtext = 13783 ;
Copy
245
0.46 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 13783
OR ts . idtext IN (
13783 , 13812 , 24136
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 13783
OR ts . idtext IN (
13783 , 13812 , 24136
));
Copy
246
0.27 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 13783 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 13783 AND t . publish = 1 ;
Copy
247
0.22 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 9703
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 9703 ;
Copy
248
0.19 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 9703
SELECT t . idtext FROM texts t WHERE t . idtext = 9703 ;
Copy
249
0.36 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 9703
OR ts . idtext IN (
9703
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 9703
OR ts . idtext IN (
9703
));
Copy
250
0.33 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 9703 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 9703 AND t . publish = 1 ;
Copy
251
0.27 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 8978
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 8978 ;
Copy
252
0.38 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 8978
SELECT t . idtext FROM texts t WHERE t . idtext = 8978 ;
Copy
253
0.61 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 8978
OR ts . idtext IN (
8978 , 37241 , 41608
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 8978
OR ts . idtext IN (
8978 , 37241 , 41608
));
Copy
254
0.60 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 8978 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 8978 AND t . publish = 1 ;
Copy
255
0.27 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 15039
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 15039 ;
Copy
256
0.21 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 15039
SELECT t . idtext FROM texts t WHERE t . idtext = 15039 ;
Copy
257
0.46 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 15039
OR ts . idtext IN (
15039 , 27568 , 37507 , 43150
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 15039
OR ts . idtext IN (
15039 , 27568 , 37507 , 43150
));
Copy
258
0.32 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 15039 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 15039 AND t . publish = 1 ;
Copy
259
0.33 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 25304
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 25304 ;
Copy
260
0.28 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 25304
SELECT t . idtext FROM texts t WHERE t . idtext = 25304 ;
Copy
261
0.35 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 25304
OR ts . idtext IN (
25304
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 25304
OR ts . idtext IN (
25304
));
Copy
262
0.33 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 25304 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 25304 AND t . publish = 1 ;
Copy
263
0.27 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 8153
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 8153 ;
Copy
264
0.21 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 8153
SELECT t . idtext FROM texts t WHERE t . idtext = 8153 ;
Copy
265
0.44 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 8153
OR ts . idtext IN (
8153 , 38385
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 8153
OR ts . idtext IN (
8153 , 38385
));
Copy
266
0.40 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 8153 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 8153 AND t . publish = 1 ;
Copy
267
0.30 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 11390
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 11390 ;
Copy
268
0.31 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 11390
SELECT t . idtext FROM texts t WHERE t . idtext = 11390 ;
Copy
269
0.50 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 11390
OR ts . idtext IN (
11390 , 14015 , 25492 , 35769 , 35834
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 11390
OR ts . idtext IN (
11390 , 14015 , 25492 , 35769 , 35834
));
Copy
270
0.34 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 11390 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 11390 AND t . publish = 1 ;
Copy
271
0.27 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 11389
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 11389 ;
Copy
272
1.86 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 11389
SELECT t . idtext FROM texts t WHERE t . idtext = 11389 ;
Copy
273
0.46 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 11389
OR ts . idtext IN (
11389 , 14032 , 18057 , 21434 , 25150
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 11389
OR ts . idtext IN (
11389 , 14032 , 18057 , 21434 , 25150
));
Copy
274
1.93 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 11389 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 11389 AND t . publish = 1 ;
Copy
275
0.27 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 10599
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 10599 ;
Copy
276
0.33 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 10599
SELECT t . idtext FROM texts t WHERE t . idtext = 10599 ;
Copy
277
0.49 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 10599
OR ts . idtext IN (
10599 , 10602
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 10599
OR ts . idtext IN (
10599 , 10602
));
Copy
278
0.24 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 10599 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 10599 AND t . publish = 1 ;
Copy
279
0.24 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 27070
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 27070 ;
Copy
280
0.15 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 27070
SELECT t . idtext FROM texts t WHERE t . idtext = 27070 ;
Copy
281
0.31 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 27070
OR ts . idtext IN (
27070
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 27070
OR ts . idtext IN (
27070
));
Copy
282
0.28 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 27070 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 27070 AND t . publish = 1 ;
Copy
283
0.20 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 35300
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 35300 ;
Copy
284
0.15 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 35300
SELECT t . idtext FROM texts t WHERE t . idtext = 35300 ;
Copy
285
0.31 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 35300
OR ts . idtext IN (
35300 , 35302
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 35300
OR ts . idtext IN (
35300 , 35302
));
Copy
286
0.23 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 35300 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 35300 AND t . publish = 1 ;
Copy
287
0.27 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38404
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38404 ;
Copy
288
0.16 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 38404
SELECT t . idtext FROM texts t WHERE t . idtext = 38404 ;
Copy
289
0.32 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38404
OR ts . idtext IN (
38404 , 38405
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38404
OR ts . idtext IN (
38404 , 38405
));
Copy
290
0.28 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38404 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38404 AND t . publish = 1 ;
Copy
291
0.14 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38483
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38483 ;
Copy
292
0.47 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 38483
SELECT t . idtext FROM texts t WHERE t . idtext = 38483 ;
Copy
293
0.77 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38483
OR ts . idtext IN (
38483
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38483
OR ts . idtext IN (
38483
));
Copy
294
0.45 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38483 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38483 AND t . publish = 1 ;
Copy
295
0.35 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38484
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38484 ;
Copy
296
0.16 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 38484
SELECT t . idtext FROM texts t WHERE t . idtext = 38484 ;
Copy
297
0.36 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38484
OR ts . idtext IN (
38484
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38484
OR ts . idtext IN (
38484
));
Copy
298
0.40 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38484 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38484 AND t . publish = 1 ;
Copy
299
0.25 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38509
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38509 ;
Copy
300
0.40 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 38509
SELECT t . idtext FROM texts t WHERE t . idtext = 38509 ;
Copy
301
0.41 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38509
OR ts . idtext IN (
38509
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38509
OR ts . idtext IN (
38509
));
Copy
302
0.25 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38509 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38509 AND t . publish = 1 ;
Copy
303
0.22 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38510
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 38510 ;
Copy
304
0.15 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 38510
SELECT t . idtext FROM texts t WHERE t . idtext = 38510 ;
Copy
305
0.36 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38510
OR ts . idtext IN (
38510
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 38510
OR ts . idtext IN (
38510
));
Copy
306
0.45 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38510 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 38510 AND t . publish = 1 ;
Copy
307
0.23 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 39948
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 39948 ;
Copy
308
0.20 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 39948
SELECT t . idtext FROM texts t WHERE t . idtext = 39948 ;
Copy
309
0.36 ms
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 39948
OR ts . idtext IN (
39948 , 39950
))
SELECT COUNT (DISTINCT (s . idspectacle )) as total
FROM text_spectacle ts , spectacles s
WHERE ts . idspectacle = s . idspectacle AND s . publish = 1 AND (ts . idtext = 39948
OR ts . idtext IN (
39948 , 39950
));
Copy
310
0.26 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 39948 AND t . publish = 1
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 39948 AND t . publish = 1 ;
Copy
311
1.49 ms
SELECT t . `idtext` , t . `title` , t . `date` , t . `type` , t . `language` , t . `country` , t . `idcontact_publisher` , t . `isbn` , t . `ean` , t . `publication_year` , t . `nbpages` , t . `idgenretext` , t . `textorder` , t . `url_clean` , contacts . `organisation` , contacts . `url_clean` as url_clean_publisher , tad . `idtextadaptation`
FROM text_adaptation tad
JOIN texts t ON t . idtext = tad . idtextadaptation
JOIN text_author ta ON t . idtext = ta . idtext
LEFT JOIN contacts contacts ON contacts . idcontact = t . idcontact_publisher
WHERE ta . idperson = 21494
AND t . type = 2 AND t . publish = 1 AND t . textfictif = 0 GROUP BY t . idtext ORDER BY date DESC
SELECT t . `idtext` , t . `title` , t . `date` , t . `type` , t . `language` , t . `country` , t . `idcontact_publisher` , t . `isbn` , t . `ean` , t . `publication_year` , t . `nbpages` , t . `idgenretext` , t . `textorder` , t . `url_clean` , contacts . `organisation` , contacts . `url_clean` as url_clean_publisher , tad . `idtextadaptation`
FROM text_adaptation tad
JOIN texts t ON t . idtext = tad . idtextadaptation
JOIN text_author ta ON t . idtext = ta . idtext
LEFT JOIN contacts contacts ON contacts . idcontact = t . idcontact_publisher
WHERE ta . idperson = 21494
AND t . type = 2 AND t . publish = 1 AND t . textfictif = 0 GROUP BY t . idtext ORDER BY date DESC ;
Copy
312
0.23 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotextes' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotextes' ))) AND persons = 1 ;
Copy
313
1.22 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 = '21494'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_biotextes' ))) 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 = '21494'
AND oc . object = 'persons'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_biotextes' ))) ORDER BY c . `range` , c . idcontent ;
Copy
314
1.77 ms
SELECT DISTINCT (playlists . idplaylist ), playlists . *
FROM `playlist_classification` ,
`playlists`
WHERE 1 AND playlists . `publish` = 1 AND playlists . `idtext` IN (8153 , 8978 , 9077 , 9300 , 9703 , 10599 , 11108 , 11389 , 11390 , 11423 , 12548 , 13214 , 13247 , 13632 , 13783 , 14519 , 15039 , 23169 , 25304 , 27070 , 28872 , 32205 , 35300 , 38404 , 38483 , 38484 , 38509 , 38510 , 39948 , 42541 , 38385 , 37241 , 41608 , 14959 , 24016 , 9303 , 10602 , 14032 , 18057 , 21434 , 25150 , 14015 , 25492 , 35769 , 35834 , 19253 , 13222 , 22076 , 23756 , 29550 , 36209 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126 , 13812 , 24136 , 15122 , 27568 , 37507 , 43150 , 23260 , 28880 , 35302 , 38405 , 39950 , 27168 ) AND playlist_classification . `idclassification` = 144 AND playlists . `idplaylist` = playlist_classification . `idplaylist`
GROUP BY playlists . idplaylist
ORDER BY playlists . dateinsert
DESC
LIMIT 0 , 10
SELECT
DISTINCT (playlists . idplaylist ),
playlists . *
FROM
`playlist_classification` ,
`playlists`
WHERE
1
AND playlists . `publish` = 1
AND playlists . `idtext` IN (
8153 , 8978 , 9077 , 9300 , 9703 , 10599 ,
11108 , 11389 , 11390 , 11423 , 12548 ,
13214 , 13247 , 13632 , 13783 , 14519 ,
15039 , 23169 , 25304 , 27070 , 28872 ,
32205 , 35300 , 38404 , 38483 , 38484 ,
38509 , 38510 , 39948 , 42541 , 38385 ,
37241 , 41608 , 14959 , 24016 , 9303 , 10602 ,
14032 , 18057 , 21434 , 25150 , 14015 ,
25492 , 35769 , 35834 , 19253 , 13222 ,
22076 , 23756 , 29550 , 36209 , 8225 , 8615 ,
13633 , 15263 , 16352 , 17721 , 18748 ,
18902 , 20366 , 30312 , 32934 , 35062 ,
36897 , 39445 , 40713 , 43126 , 13812 ,
24136 , 15122 , 27568 , 37507 , 43150 ,
23260 , 28880 , 35302 , 38405 , 39950 ,
27168
)
AND playlist_classification . `idclassification` = 144
AND playlists . `idplaylist` = playlist_classification . `idplaylist`
GROUP BY
playlists . idplaylist
ORDER BY
playlists . dateinsert DESC
LIMIT
0 , 10
Copy
SELECT DISTINCT (playlists . idplaylist ), playlists . *
FROM `playlist_classification` ,
`playlists`
WHERE 1 AND playlists . `publish` = 1 AND playlists . `idtext` IN (8153 , 8978 , 9077 , 9300 , 9703 , 10599 , 11108 , 11389 , 11390 , 11423 , 12548 , 13214 , 13247 , 13632 , 13783 , 14519 , 15039 , 23169 , 25304 , 27070 , 28872 , 32205 , 35300 , 38404 , 38483 , 38484 , 38509 , 38510 , 39948 , 42541 , 38385 , 37241 , 41608 , 14959 , 24016 , 9303 , 10602 , 14032 , 18057 , 21434 , 25150 , 14015 , 25492 , 35769 , 35834 , 19253 , 13222 , 22076 , 23756 , 29550 , 36209 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126 , 13812 , 24136 , 15122 , 27568 , 37507 , 43150 , 23260 , 28880 , 35302 , 38405 , 39950 , 27168 ) AND playlist_classification . `idclassification` = 144 AND playlists . `idplaylist` = playlist_classification . `idplaylist`
GROUP BY playlists . idplaylist
ORDER BY playlists . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
315
0.08 ms
SELECT DISTINCT (playlists . idplaylist ), playlists . *
FROM `playlist_classification` ,
`playlists`
WHERE 1 AND playlists . `publish` = 1 AND playlists . `idtext` IN (8153 , 8978 , 9077 , 9300 , 9703 , 10599 , 11108 , 11389 , 11390 , 11423 , 12548 , 13214 , 13247 , 13632 , 13783 , 14519 , 15039 , 23169 , 25304 , 27070 , 28872 , 32205 , 35300 , 38404 , 38483 , 38484 , 38509 , 38510 , 39948 , 42541 , 38385 , 37241 , 41608 , 14959 , 24016 , 9303 , 10602 , 14032 , 18057 , 21434 , 25150 , 14015 , 25492 , 35769 , 35834 , 19253 , 13222 , 22076 , 23756 , 29550 , 36209 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126 , 13812 , 24136 , 15122 , 27568 , 37507 , 43150 , 23260 , 28880 , 35302 , 38405 , 39950 , 27168 ) AND playlist_classification . `idclassification` = 144 AND playlists . `idplaylist` = playlist_classification . `idplaylist`
GROUP BY playlists . idplaylist
ORDER BY playlists . dateinsert
DESC
LIMIT 0 , 10
SELECT
DISTINCT (playlists . idplaylist ),
playlists . *
FROM
`playlist_classification` ,
`playlists`
WHERE
1
AND playlists . `publish` = 1
AND playlists . `idtext` IN (
8153 , 8978 , 9077 , 9300 , 9703 , 10599 ,
11108 , 11389 , 11390 , 11423 , 12548 ,
13214 , 13247 , 13632 , 13783 , 14519 ,
15039 , 23169 , 25304 , 27070 , 28872 ,
32205 , 35300 , 38404 , 38483 , 38484 ,
38509 , 38510 , 39948 , 42541 , 38385 ,
37241 , 41608 , 14959 , 24016 , 9303 , 10602 ,
14032 , 18057 , 21434 , 25150 , 14015 ,
25492 , 35769 , 35834 , 19253 , 13222 ,
22076 , 23756 , 29550 , 36209 , 8225 , 8615 ,
13633 , 15263 , 16352 , 17721 , 18748 ,
18902 , 20366 , 30312 , 32934 , 35062 ,
36897 , 39445 , 40713 , 43126 , 13812 ,
24136 , 15122 , 27568 , 37507 , 43150 ,
23260 , 28880 , 35302 , 38405 , 39950 ,
27168
)
AND playlist_classification . `idclassification` = 144
AND playlists . `idplaylist` = playlist_classification . `idplaylist`
GROUP BY
playlists . idplaylist
ORDER BY
playlists . dateinsert DESC
LIMIT
0 , 10
Copy
SELECT DISTINCT (playlists . idplaylist ), playlists . *
FROM `playlist_classification` ,
`playlists`
WHERE 1 AND playlists . `publish` = 1 AND playlists . `idtext` IN (8153 , 8978 , 9077 , 9300 , 9703 , 10599 , 11108 , 11389 , 11390 , 11423 , 12548 , 13214 , 13247 , 13632 , 13783 , 14519 , 15039 , 23169 , 25304 , 27070 , 28872 , 32205 , 35300 , 38404 , 38483 , 38484 , 38509 , 38510 , 39948 , 42541 , 38385 , 37241 , 41608 , 14959 , 24016 , 9303 , 10602 , 14032 , 18057 , 21434 , 25150 , 14015 , 25492 , 35769 , 35834 , 19253 , 13222 , 22076 , 23756 , 29550 , 36209 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126 , 13812 , 24136 , 15122 , 27568 , 37507 , 43150 , 23260 , 28880 , 35302 , 38405 , 39950 , 27168 ) AND playlist_classification . `idclassification` = 144 AND playlists . `idplaylist` = playlist_classification . `idplaylist`
GROUP BY playlists . idplaylist
ORDER BY playlists . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
316
0.67 ms
SELECT COUNT (* ) , j3 . idperson FROM theatreok_dev . text_classification j1 , theatreok_dev . text_person j2 , theatreok_dev . persons j3
WHERE j3 . idperson = j2 . idperson
AND j1 . idtext = j2 . idtext
AND j3 . idperson = 21494
SELECT COUNT (* ) , j3 . idperson FROM theatreok_dev . text_classification j1 , theatreok_dev . text_person j2 , theatreok_dev . persons j3
WHERE j3 . idperson = j2 . idperson
AND j1 . idtext = j2 . idtext
AND j3 . idperson = 21494 ;
Copy
317
0.09 ms
SELECT COUNT (* ) , j3 . idperson FROM theatreok_dev . text_classification j1 , theatreok_dev . text_person j2 , theatreok_dev . persons j3
WHERE j3 . idperson = j2 . idperson
AND j1 . idtext = j2 . idtext
AND j3 . idperson = 21494
SELECT COUNT (* ) , j3 . idperson FROM theatreok_dev . text_classification j1 , theatreok_dev . text_person j2 , theatreok_dev . persons j3
WHERE j3 . idperson = j2 . idperson
AND j1 . idtext = j2 . idtext
AND j3 . idperson = 21494 ;
Copy
318
0.40 ms
SELECT COUNT (t . `idtext` ) AS total
FROM text_traduction tt , text_translator ttr , texts t
LEFT JOIN contacts ON contacts . idcontact = t . idcontact_publisher
WHERE 1
AND t . idtext = tt . idtexttraduction
AND t . idtext = ttr . idtext
AND ttr . idperson = 21494
AND t . type = 1
SELECT COUNT (t . `idtext` ) AS total
FROM text_traduction tt , text_translator ttr , texts t
LEFT JOIN contacts ON contacts . idcontact = t . idcontact_publisher
WHERE 1
AND t . idtext = tt . idtexttraduction
AND t . idtext = ttr . idtext
AND ttr . idperson = 21494
AND t . type = 1 ;
Copy
319
0.77 ms
SELECT COUNT (DISTINCT (t . idtext ))
FROM text_traduction tt , texts t
LEFT OUTER JOIN contacts ON contacts . idcontact = t . idcontact_publisher
WHERE 1
AND tt . idtexttraduction = t . idtext
AND t . publish = 1
AND tt . idtext IN (
SELECT idtext
FROM text_author
WHERE idperson = 21494
)
SELECT COUNT (DISTINCT (t . idtext ))
FROM text_traduction tt , texts t
LEFT OUTER JOIN contacts ON contacts . idcontact = t . idcontact_publisher
WHERE 1
AND tt . idtexttraduction = t . idtext
AND t . publish = 1
AND tt . idtext IN (
SELECT idtext
FROM text_author
WHERE idperson = 21494
)
;
Copy
320
0.35 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 (21494 ) 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 (21494 ) AND c . `classification` = 'class_auteur_meme' ;
Copy
321
3.55 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 (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 ) AND s . date > = '2024-04-26' 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 (
5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 ,
6702 , 7484 , 7993 , 8282 , 8587 , 9230 ,
9849 , 9873 , 10217 , 10365 , 10376 , 10410 ,
10449 , 10601 , 10627 , 11388 , 11434 ,
11504 , 11511 , 11659 , 12658 , 13436 ,
13870 , 14092 , 14803 , 14876 , 14885 ,
15054 , 16118 , 17519 , 17599 , 18465 ,
18506 , 18555 , 18980 , 19215 , 20049 ,
20190 , 20377 , 20713 , 21622 , 21793 ,
21866 , 22100 , 23860 , 24496 , 24798 ,
24961 , 25776 , 26408 , 26491 , 27561 ,
28348 , 28574 , 28649 , 28978 , 29289 ,
29799 , 30120 , 30289 , 30475 , 30512 ,
30541 , 30652 , 30859 , 30883 , 30969 ,
30975 , 31118 , 31148 , 31764 , 32104 ,
32214 , 32548 , 33333 , 34272 , 34807 ,
34829 , 36482 , 37021
)
AND s . date > = '2024-04-26'
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 (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 ) AND s . date > = '2024-04-26' ORDER BY s . date ASC LIMIT 0 , 1 ;
Copy
322
4.40 ms
SELECT schedules . `date` , YEAR (schedules . `date` ) as annee
FROM schedules , spectacles
WHERE schedules . `idspectacle` = spectacles . `idspectacle`
AND spectacles . `publish` = 1
AND schedules . `idspectacle` IN (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 )
GROUP BY spectacles . `idspectacle`
ORDER BY schedules . `date`
SELECT
schedules . `date` ,
YEAR (schedules . `date` ) as annee
FROM
schedules ,
spectacles
WHERE
schedules . `idspectacle` = spectacles . `idspectacle`
AND spectacles . `publish` = 1
AND schedules . `idspectacle` IN (
5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 ,
6702 , 7484 , 7993 , 8282 , 8587 , 9230 ,
9849 , 9873 , 10217 , 10365 , 10376 , 10410 ,
10449 , 10601 , 10627 , 11388 , 11434 ,
11504 , 11511 , 11659 , 12658 , 13436 ,
13870 , 14092 , 14803 , 14876 , 14885 ,
15054 , 16118 , 17519 , 17599 , 18465 ,
18506 , 18555 , 18980 , 19215 , 20049 ,
20190 , 20377 , 20713 , 21622 , 21793 ,
21866 , 22100 , 23860 , 24496 , 24798 ,
24961 , 25776 , 26408 , 26491 , 27561 ,
28348 , 28574 , 28649 , 28978 , 29289 ,
29799 , 30120 , 30289 , 30475 , 30512 ,
30541 , 30652 , 30859 , 30883 , 30969 ,
30975 , 31118 , 31148 , 31764 , 32104 ,
32214 , 32548 , 33333 , 34272 , 34807 ,
34829 , 36482 , 37021
)
GROUP BY
spectacles . `idspectacle`
ORDER BY
schedules . `date`
Copy
SELECT schedules . `date` , YEAR (schedules . `date` ) as annee
FROM schedules , spectacles
WHERE schedules . `idspectacle` = spectacles . `idspectacle`
AND spectacles . `publish` = 1
AND schedules . `idspectacle` IN (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 )
GROUP BY spectacles . `idspectacle`
ORDER BY schedules . `date` ;
Copy
323
0.55 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 = 21494 ) 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 = 21494 ) AND T1 . publish = 1 ;
Copy
324
0.69 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 21494
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 = 21494
AND om . object = 'persons'
AND m . publish = 1 ;
Copy
325
0.70 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` = 21494 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` = 21494 AND d . code_franceinter IS NOT NULL ;
Copy
326
0.76 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` = 21494 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` = 21494 AND d . code_soundcloud IS NOT NULL ;
Copy
327
1.51 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 (8153 , 8978 , 9077 , 9300 , 9703 , 10599 , 11108 , 11389 , 11390 , 11423 , 12548 , 13214 , 13247 , 13632 , 13783 , 14519 , 15039 , 23169 , 25304 , 27070 , 28872 , 32205 , 35300 , 38404 , 38483 , 38484 , 38509 , 38510 , 39948 , 42541 , 38385 , 37241 , 41608 , 14959 , 24016 , 9303 , 10602 , 14032 , 18057 , 21434 , 25150 , 14015 , 25492 , 35769 , 35834 , 19253 , 13222 , 22076 , 23756 , 29550 , 36209 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126 , 13812 , 24136 , 15122 , 27568 , 37507 , 43150 , 23260 , 28880 , 35302 , 38405 , 39950 , 27168 ) 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 (
8153 , 8978 , 9077 , 9300 , 9703 , 10599 ,
11108 , 11389 , 11390 , 11423 , 12548 ,
13214 , 13247 , 13632 , 13783 , 14519 ,
15039 , 23169 , 25304 , 27070 , 28872 ,
32205 , 35300 , 38404 , 38483 , 38484 ,
38509 , 38510 , 39948 , 42541 , 38385 ,
37241 , 41608 , 14959 , 24016 , 9303 , 10602 ,
14032 , 18057 , 21434 , 25150 , 14015 ,
25492 , 35769 , 35834 , 19253 , 13222 ,
22076 , 23756 , 29550 , 36209 , 8225 , 8615 ,
13633 , 15263 , 16352 , 17721 , 18748 ,
18902 , 20366 , 30312 , 32934 , 35062 ,
36897 , 39445 , 40713 , 43126 , 13812 ,
24136 , 15122 , 27568 , 37507 , 43150 ,
23260 , 28880 , 35302 , 38405 , 39950 ,
27168
)
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 (8153 , 8978 , 9077 , 9300 , 9703 , 10599 , 11108 , 11389 , 11390 , 11423 , 12548 , 13214 , 13247 , 13632 , 13783 , 14519 , 15039 , 23169 , 25304 , 27070 , 28872 , 32205 , 35300 , 38404 , 38483 , 38484 , 38509 , 38510 , 39948 , 42541 , 38385 , 37241 , 41608 , 14959 , 24016 , 9303 , 10602 , 14032 , 18057 , 21434 , 25150 , 14015 , 25492 , 35769 , 35834 , 19253 , 13222 , 22076 , 23756 , 29550 , 36209 , 8225 , 8615 , 13633 , 15263 , 16352 , 17721 , 18748 , 18902 , 20366 , 30312 , 32934 , 35062 , 36897 , 39445 , 40713 , 43126 , 13812 , 24136 , 15122 , 27568 , 37507 , 43150 , 23260 , 28880 , 35302 , 38405 , 39950 , 27168 ) ORDER BY publication_year DESC ;
Copy
328
8.02 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , o2_ . idobject AS idobject_2 , o2_ . object AS object_3 , o2_ . `range` AS range_4 , o2_ . idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c8_ ON s1_ . idcontact = c8_ . idcontact LEFT JOIN object_content o2_ ON (o2_ . object = 'spectacles' ) LEFT JOIN contents c9_ ON (c9_ . idcontent = o2_ . idcontent ) LEFT JOIN content_classification c11_ ON c9_ . idcontent = c11_ . idcontent LEFT JOIN classifications c10_ ON c10_ . idclassification = c11_ . idclassification WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c8_ . idcontact OR s1_ . idcontact_festival = c8_ . idcontact ) AND (c9_ . valid = 1 AND c9_ . publish = 1 ) AND c10_ . idclassification IN (125 ) AND s0_ . idspectacle = o2_ . idobject AND c9_ . idcontent = o2_ . idcontent AND s0_ . idspectacle IN (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 ) ORDER BY sclr_1 DESC
SELECT
COUNT (
DISTINCT (s0_ . idspectacle )
) AS sclr_0 ,
MIN (s1_ . date ) AS sclr_1 ,
o2_ . idobject AS idobject_2 ,
o2_ . object AS object_3 ,
o2_ . `range` AS range_4 ,
o2_ . idcontent AS idcontent_5
FROM
spectacles s0_
LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle
LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext
LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle
LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle
LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle
LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson
INNER JOIN contacts c8_ ON s1_ . idcontact = c8_ . idcontact
LEFT JOIN object_content o2_ ON (o2_ . object = 'spectacles' )
LEFT JOIN contents c9_ ON (c9_ . idcontent = o2_ . idcontent )
LEFT JOIN content_classification c11_ ON c9_ . idcontent = c11_ . idcontent
LEFT JOIN classifications c10_ ON c10_ . idclassification = c11_ . idclassification
WHERE
s1_ . idspectacle = s0_ . idspectacle
AND (
s1_ . idcontact = c8_ . idcontact
OR s1_ . idcontact_festival = c8_ . idcontact
)
AND (
c9_ . valid = 1
AND c9_ . publish = 1
)
AND c10_ . idclassification IN (125 )
AND s0_ . idspectacle = o2_ . idobject
AND c9_ . idcontent = o2_ . idcontent
AND s0_ . idspectacle IN (
5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 ,
6702 , 7484 , 7993 , 8282 , 8587 , 9230 ,
9849 , 9873 , 10217 , 10365 , 10376 , 10410 ,
10449 , 10601 , 10627 , 11388 , 11434 ,
11504 , 11511 , 11659 , 12658 , 13436 ,
13870 , 14092 , 14803 , 14876 , 14885 ,
15054 , 16118 , 17519 , 17599 , 18465 ,
18506 , 18555 , 18980 , 19215 , 20049 ,
20190 , 20377 , 20713 , 21622 , 21793 ,
21866 , 22100 , 23860 , 24496 , 24798 ,
24961 , 25776 , 26408 , 26491 , 27561 ,
28348 , 28574 , 28649 , 28978 , 29289 ,
29799 , 30120 , 30289 , 30475 , 30512 ,
30541 , 30652 , 30859 , 30883 , 30969 ,
30975 , 31118 , 31148 , 31764 , 32104 ,
32214 , 32548 , 33333 , 34272 , 34807 ,
34829 , 36482 , 37021
)
ORDER BY
sclr_1 DESC
Copy
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , o2_ . idobject AS idobject_2 , o2_ . object AS object_3 , o2_ . `range` AS range_4 , o2_ . idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c8_ ON s1_ . idcontact = c8_ . idcontact LEFT JOIN object_content o2_ ON (o2_ . object = 'spectacles' ) LEFT JOIN contents c9_ ON (c9_ . idcontent = o2_ . idcontent ) LEFT JOIN content_classification c11_ ON c9_ . idcontent = c11_ . idcontent LEFT JOIN classifications c10_ ON c10_ . idclassification = c11_ . idclassification WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c8_ . idcontact OR s1_ . idcontact_festival = c8_ . idcontact ) AND (c9_ . valid = 1 AND c9_ . publish = 1 ) AND c10_ . idclassification IN (125 ) AND s0_ . idspectacle = o2_ . idobject AND c9_ . idcontent = o2_ . idcontent AND s0_ . idspectacle IN (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 ) ORDER BY sclr_1 DESC ;
Copy
329
5.51 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , o2_ . idobject AS idobject_2 , o2_ . object AS object_3 , o2_ . `range` AS range_4 , o2_ . idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c8_ ON s1_ . idcontact = c8_ . idcontact LEFT JOIN object_content o2_ ON (o2_ . object = 'spectacles' ) LEFT JOIN contents c9_ ON (c9_ . idcontent = o2_ . idcontent ) LEFT JOIN content_classification c11_ ON c9_ . idcontent = c11_ . idcontent LEFT JOIN classifications c10_ ON c10_ . idclassification = c11_ . idclassification WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c8_ . idcontact OR s1_ . idcontact_festival = c8_ . idcontact ) AND (c9_ . valid = 1 AND c9_ . publish = 1 ) AND c10_ . idclassification IN (82 ) AND s0_ . idspectacle = o2_ . idobject AND c9_ . idcontent = o2_ . idcontent AND s0_ . idspectacle IN (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 ) ORDER BY sclr_1 DESC
SELECT
COUNT (
DISTINCT (s0_ . idspectacle )
) AS sclr_0 ,
MIN (s1_ . date ) AS sclr_1 ,
o2_ . idobject AS idobject_2 ,
o2_ . object AS object_3 ,
o2_ . `range` AS range_4 ,
o2_ . idcontent AS idcontent_5
FROM
spectacles s0_
LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle
LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext
LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle
LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle
LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle
LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson
INNER JOIN contacts c8_ ON s1_ . idcontact = c8_ . idcontact
LEFT JOIN object_content o2_ ON (o2_ . object = 'spectacles' )
LEFT JOIN contents c9_ ON (c9_ . idcontent = o2_ . idcontent )
LEFT JOIN content_classification c11_ ON c9_ . idcontent = c11_ . idcontent
LEFT JOIN classifications c10_ ON c10_ . idclassification = c11_ . idclassification
WHERE
s1_ . idspectacle = s0_ . idspectacle
AND (
s1_ . idcontact = c8_ . idcontact
OR s1_ . idcontact_festival = c8_ . idcontact
)
AND (
c9_ . valid = 1
AND c9_ . publish = 1
)
AND c10_ . idclassification IN (82 )
AND s0_ . idspectacle = o2_ . idobject
AND c9_ . idcontent = o2_ . idcontent
AND s0_ . idspectacle IN (
5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 ,
6702 , 7484 , 7993 , 8282 , 8587 , 9230 ,
9849 , 9873 , 10217 , 10365 , 10376 , 10410 ,
10449 , 10601 , 10627 , 11388 , 11434 ,
11504 , 11511 , 11659 , 12658 , 13436 ,
13870 , 14092 , 14803 , 14876 , 14885 ,
15054 , 16118 , 17519 , 17599 , 18465 ,
18506 , 18555 , 18980 , 19215 , 20049 ,
20190 , 20377 , 20713 , 21622 , 21793 ,
21866 , 22100 , 23860 , 24496 , 24798 ,
24961 , 25776 , 26408 , 26491 , 27561 ,
28348 , 28574 , 28649 , 28978 , 29289 ,
29799 , 30120 , 30289 , 30475 , 30512 ,
30541 , 30652 , 30859 , 30883 , 30969 ,
30975 , 31118 , 31148 , 31764 , 32104 ,
32214 , 32548 , 33333 , 34272 , 34807 ,
34829 , 36482 , 37021
)
ORDER BY
sclr_1 DESC
Copy
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , o2_ . idobject AS idobject_2 , o2_ . object AS object_3 , o2_ . `range` AS range_4 , o2_ . idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c8_ ON s1_ . idcontact = c8_ . idcontact LEFT JOIN object_content o2_ ON (o2_ . object = 'spectacles' ) LEFT JOIN contents c9_ ON (c9_ . idcontent = o2_ . idcontent ) LEFT JOIN content_classification c11_ ON c9_ . idcontent = c11_ . idcontent LEFT JOIN classifications c10_ ON c10_ . idclassification = c11_ . idclassification WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c8_ . idcontact OR s1_ . idcontact_festival = c8_ . idcontact ) AND (c9_ . valid = 1 AND c9_ . publish = 1 ) AND c10_ . idclassification IN (82 ) AND s0_ . idspectacle = o2_ . idobject AND c9_ . idcontent = o2_ . idcontent AND s0_ . idspectacle IN (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 ) ORDER BY sclr_1 DESC ;
Copy
330
3.62 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 (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 ) 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 (
5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 ,
6702 , 7484 , 7993 , 8282 , 8587 , 9230 ,
9849 , 9873 , 10217 , 10365 , 10376 , 10410 ,
10449 , 10601 , 10627 , 11388 , 11434 ,
11504 , 11511 , 11659 , 12658 , 13436 ,
13870 , 14092 , 14803 , 14876 , 14885 ,
15054 , 16118 , 17519 , 17599 , 18465 ,
18506 , 18555 , 18980 , 19215 , 20049 ,
20190 , 20377 , 20713 , 21622 , 21793 ,
21866 , 22100 , 23860 , 24496 , 24798 ,
24961 , 25776 , 26408 , 26491 , 27561 ,
28348 , 28574 , 28649 , 28978 , 29289 ,
29799 , 30120 , 30289 , 30475 , 30512 ,
30541 , 30652 , 30859 , 30883 , 30969 ,
30975 , 31118 , 31148 , 31764 , 32104 ,
32214 , 32548 , 33333 , 34272 , 34807 ,
34829 , 36482 , 37021
)
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 (5421 , 5462 , 5712 , 5926 , 6077 , 6149 , 6343 , 6702 , 7484 , 7993 , 8282 , 8587 , 9230 , 9849 , 9873 , 10217 , 10365 , 10376 , 10410 , 10449 , 10601 , 10627 , 11388 , 11434 , 11504 , 11511 , 11659 , 12658 , 13436 , 13870 , 14092 , 14803 , 14876 , 14885 , 15054 , 16118 , 17519 , 17599 , 18465 , 18506 , 18555 , 18980 , 19215 , 20049 , 20190 , 20377 , 20713 , 21622 , 21793 , 21866 , 22100 , 23860 , 24496 , 24798 , 24961 , 25776 , 26408 , 26491 , 27561 , 28348 , 28574 , 28649 , 28978 , 29289 , 29799 , 30120 , 30289 , 30475 , 30512 , 30541 , 30652 , 30859 , 30883 , 30969 , 30975 , 31118 , 31148 , 31764 , 32104 , 32214 , 32548 , 33333 , 34272 , 34807 , 34829 , 36482 , 37021 ) 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
331
0.68 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 :
[
"abac86841e52efe5b1f30e2b65d0733e-bdad "
0
"c31be989c0f6fcdda61a9f698388d6f1 "
]
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 = 'abac86841e52efe5b1f30e2b65d0733e-bdad' AND t0 . idcontent = 0 AND t0 . md5url = 'c31be989c0f6fcdda61a9f698388d6f1' ;
Copy
332
2.45 ms
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/biographies/Victor-Hugo/textes/ "
"c31be989c0f6fcdda61a9f698388d6f1 "
0
"persons "
21494
0
"fr "
"abac86841e52efe5b1f30e2b65d0733e-bdad "
"/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/Victor-Hugo/textes/' , 'c31be989c0f6fcdda61a9f698388d6f1' , 0 , 'persons' , 21494 , 0 , 'fr' , 'abac86841e52efe5b1f30e2b65d0733e-bdad' , '/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553' );
Copy
333
0.09 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
334
0.14 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 = '21494'
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 = '21494'
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
335
1.20 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