1
0.89 ms
SELECT idperson FROM persons WHERE url_clean = 'Bertolt-Brecht'
SELECT idperson FROM persons WHERE url_clean = 'Bertolt-Brecht' ;
Copy
2
0.71 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 = 20477 ;
Copy
3
1.35 ms
SELECT COUNT (DISTINCT (t . idtext ))
FROM text_author ta , texts t
WHERE t . idtext = ta . idtext AND t . textfictif = 0
AND ta . idperson = 20477 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 = 20477 AND t . publish = 1 AND t . type IN (0 , 2 ) ;
Copy
4
0.64 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 = 20477 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 = 20477 AND t . publish = 1 ;
Copy
5
0.55 ms
SELECT COUNT (DISTINCT (sp . idspectacle )) as total
FROM spectacle_person sp , spectacles s
WHERE 1
AND sp . idspectacle = s . idspectacle
AND sp . idperson = 20477
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 = 20477
AND sp . idrole = 1 AND s . publish = 1 ;
Copy
6
0.25 ms
SELECT fr FROM countries WHERE id = 'DE'
SELECT fr FROM countries WHERE id = 'DE' ;
Copy
7
0.21 ms
SELECT fr FROM languages WHERE id = 'de'
SELECT fr FROM languages WHERE id = 'de' ;
Copy
8
0.83 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 = 20477 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 = 20477 AND j2 . idoffice = 1 ;
Copy
9
0.21 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotxt' ))) AND persons = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_biotxt' ))) AND persons = 1 ;
Copy
10
2.18 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 = '20477'
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 = '20477'
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.83 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 = 44222
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 = 44222 ;
Copy
12
0.07 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.83 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 = '20477'
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 = '20477'
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.82 ms
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (20477 )
SELECT t . `idtext`
FROM text_author ta
JOIN texts t ON ta . `idtext` = t . `idtext`
WHERE ta . `idperson` IN (20477 ) ;
Copy
15
0.57 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 (20477 )
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 (20477 ) ;
Copy
16
0.35 ms
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (20477 )
SELECT t . `idtext`
FROM text_translator tt
JOIN texts t ON tt . `idtext` = t . `idtext`
WHERE
tt . `idperson` IN (20477 ) ;
Copy
17
0.98 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 (20477 )
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 (20477 ) ;
Copy
18
544.32 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` = 20477 OR ts . `idtext` IN (7642 , 7686 , 8062 , 8484 , 8681 , 8741 , 8770 , 9106 , 9188 , 9189 , 9506 , 9548 , 9568 , 11033 , 11062 , 11370 , 11371 , 11618 , 12215 , 13550 , 13946 , 18473 , 18602 , 20690 , 20951 , 21586 , 23816 , 32253 , 34514 , 10044 , 10713 , 32485 , 34572 , 44853 , 18770 , 10815 , 19222 , 31001 , 25136 , 34815 , 21325 , 25614 , 13947 , 18618 , 18686 , 32254 , 34476 , 7688 , 10712 , 7687 , 8063 , 8485 , 8682 , 8742 , 8771 , 9107 , 11736 , 9193 , 15145 , 38008 , 9190 , 9507 , 9549 , 9582 , 11820 , 25415 , 37961 , 11372 , 11652 , 12229 , 13551 , 18474 , 18617 , 41892 , 20698 , 20952 , 21587 , 23817 ) )
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` = 20477
OR ts . `idtext` IN (
7642 , 7686 , 8062 , 8484 , 8681 , 8741 , 8770 ,
9106 , 9188 , 9189 , 9506 , 9548 , 9568 ,
11033 , 11062 , 11370 , 11371 , 11618 ,
12215 , 13550 , 13946 , 18473 , 18602 ,
20690 , 20951 , 21586 , 23816 , 32253 ,
34514 , 10044 , 10713 , 32485 , 34572 ,
44853 , 18770 , 10815 , 19222 , 31001 ,
25136 , 34815 , 21325 , 25614 , 13947 ,
18618 , 18686 , 32254 , 34476 , 7688 , 10712 ,
7687 , 8063 , 8485 , 8682 , 8742 , 8771 ,
9107 , 11736 , 9193 , 15145 , 38008 , 9190 ,
9507 , 9549 , 9582 , 11820 , 25415 , 37961 ,
11372 , 11652 , 12229 , 13551 , 18474 ,
18617 , 41892 , 20698 , 20952 , 21587 ,
23817
)
)
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` = 20477 OR ts . `idtext` IN (7642 , 7686 , 8062 , 8484 , 8681 , 8741 , 8770 , 9106 , 9188 , 9189 , 9506 , 9548 , 9568 , 11033 , 11062 , 11370 , 11371 , 11618 , 12215 , 13550 , 13946 , 18473 , 18602 , 20690 , 20951 , 21586 , 23816 , 32253 , 34514 , 10044 , 10713 , 32485 , 34572 , 44853 , 18770 , 10815 , 19222 , 31001 , 25136 , 34815 , 21325 , 25614 , 13947 , 18618 , 18686 , 32254 , 34476 , 7688 , 10712 , 7687 , 8063 , 8485 , 8682 , 8742 , 8771 , 9107 , 11736 , 9193 , 15145 , 38008 , 9190 , 9507 , 9549 , 9582 , 11820 , 25415 , 37961 , 11372 , 11652 , 12229 , 13551 , 18474 , 18617 , 41892 , 20698 , 20952 , 21587 , 23817 ) );
Copy
19
0.70 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` = 20477 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` = 20477 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
20
4.61 ms
SELECT COUNT (DISTINCT (ct . `idcontent` ))
FROM spectacles s
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND cc . `idclassification` = 101
AND s . `idspectacle` IN (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 )
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 (
5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 ,
6241 , 6245 , 6527 , 6586 , 6707 , 6944 ,
6994 , 7063 , 7130 , 7599 , 7691 , 8217 ,
8382 , 8496 , 8507 , 8597 , 8942 , 10148 ,
10200 , 10540 , 11531 , 11630 , 11655 ,
12137 , 13156 , 14546 , 14631 , 15135 ,
15914 , 15964 , 16397 , 16431 , 16506 ,
16674 , 16994 , 17234 , 17568 , 17766 ,
17840 , 19389 , 19605 , 19768 , 20033 ,
20286 , 20467 , 20688 , 20890 , 21288 ,
22407 , 22482 , 23620 , 24011 , 24839 ,
25913 , 26040 , 26338 , 26476 , 27755 ,
27856 , 27947 , 28131 , 28141 , 29109 ,
29196 , 29354 , 30308 , 30553 , 30573 ,
30653 , 31429 , 31477 , 31782 , 32213 ,
34892 , 36575 , 37301
)
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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 ) ;
Copy
21
0.85 ms
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND podcasts . `code_franceinter` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND (podcasts . type_franceinter is NULL OR podcasts . type_franceinter = 0 ) AND podcasts . `idpodcast` = podcast_person . `idpodcast`
LIMIT 0 , 20
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND podcasts . `code_franceinter` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND (podcasts . type_franceinter is NULL OR podcasts . type_franceinter = 0 ) AND podcasts . `idpodcast` = podcast_person . `idpodcast`
LIMIT 0 , 20 ;
Copy
22
1.21 ms
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND podcasts . `code_franceinter` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `type_franceinter` = 1 AND podcasts . `idpodcast` = podcast_person . `idpodcast`
LIMIT 0 , 20
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND podcasts . `code_franceinter` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `type_franceinter` = 1 AND podcasts . `idpodcast` = podcast_person . `idpodcast`
LIMIT 0 , 20 ;
Copy
23
0.42 ms
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND podcasts . `code_soundcloud` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_person . `idpodcast`
LIMIT 0 , 20
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND podcasts . `code_soundcloud` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_person . `idpodcast`
LIMIT 0 , 20 ;
Copy
24
0.43 ms
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND ( `podcasts` . `code_franceinter` IS NOT NULL OR `podcasts` . `code_soundcloud` IS NOT NULL ) AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_person . `idpodcast`
LIMIT 0 , 20
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND ( `podcasts` . `code_franceinter` IS NOT NULL OR `podcasts` . `code_soundcloud` IS NOT NULL ) AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_person . `idpodcast`
LIMIT 0 , 20 ;
Copy
25
1.61 ms
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND ( `podcasts` . `code_franceinter` IS NOT NULL OR `podcasts` . `code_soundcloud` IS NOT NULL ) AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_person . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 20
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_person` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_person . `idperson` = 20477 AND ( `podcasts` . `code_franceinter` IS NOT NULL OR `podcasts` . `code_soundcloud` IS NOT NULL ) AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_person . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 20 ;
Copy
26
0.36 ms
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = ?
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = '4948' ;
Copy
27
0.34 ms
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 4948
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 4948 ;
Copy
28
0.39 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 36575
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 36575 ;
Copy
29
0.46 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 4948
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 4948 ;
Copy
30
0.72 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 4948
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 4948 ;
Copy
31
0.37 ms
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 4948
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 4948 ;
Copy
32
0.10 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4948
SELECT url_file FROM podcasts WHERE idpodcast = 4948 ;
Copy
33
0.04 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4948
SELECT url_file FROM podcasts WHERE idpodcast = 4948 ;
Copy
34
0.27 ms
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = ?
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = '4715' ;
Copy
35
0.37 ms
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 4715
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 4715 ;
Copy
36
0.44 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24011
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24011 ;
Copy
37
0.52 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 33540
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 33540 ;
Copy
38
0.21 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 33965
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 33965 ;
Copy
39
0.37 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 34516
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 34516 ;
Copy
40
0.44 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 34755
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 34755 ;
Copy
41
0.45 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 4715
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 4715 ;
Copy
42
0.32 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 4715
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 4715 ;
Copy
43
0.36 ms
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 4715
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 4715 ;
Copy
44
0.30 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4715
SELECT url_file FROM podcasts WHERE idpodcast = 4715 ;
Copy
45
0.05 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4715
SELECT url_file FROM podcasts WHERE idpodcast = 4715 ;
Copy
46
0.23 ms
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = ?
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = '1812' ;
Copy
47
0.27 ms
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 1812
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 1812 ;
Copy
48
0.19 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 10413
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 10413 ;
Copy
49
0.17 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 21333
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 21333 ;
Copy
50
0.22 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 25836
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 25836 ;
Copy
51
0.36 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 26476
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 26476 ;
Copy
52
0.56 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 27581
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 27581 ;
Copy
53
0.22 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 28058
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 28058 ;
Copy
54
0.46 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 1812
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 1812 ;
Copy
55
0.51 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 1812
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 1812 ;
Copy
56
0.58 ms
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 1812
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 1812 ;
Copy
57
0.18 ms
SELECT url_file FROM podcasts WHERE idpodcast = 1812
SELECT url_file FROM podcasts WHERE idpodcast = 1812 ;
Copy
58
0.04 ms
SELECT url_file FROM podcasts WHERE idpodcast = 1812
SELECT url_file FROM podcasts WHERE idpodcast = 1812 ;
Copy
59
0.48 ms
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = ?
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = '1677' ;
Copy
60
0.27 ms
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 1677
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 1677 ;
Copy
61
0.40 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 22633
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 22633 ;
Copy
62
0.09 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 26476
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 26476 ;
Copy
63
0.23 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 27303
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 27303 ;
Copy
64
0.33 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 1677
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 1677 ;
Copy
65
0.36 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 1677
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 1677 ;
Copy
66
0.31 ms
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 1677
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 1677 ;
Copy
67
0.23 ms
SELECT url_file FROM podcasts WHERE idpodcast = 1677
SELECT url_file FROM podcasts WHERE idpodcast = 1677 ;
Copy
68
0.04 ms
SELECT url_file FROM podcasts WHERE idpodcast = 1677
SELECT url_file FROM podcasts WHERE idpodcast = 1677 ;
Copy
69
0.26 ms
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = ?
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = '822' ;
Copy
70
0.24 ms
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 822
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 822 ;
Copy
71
0.20 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 822
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 822 ;
Copy
72
0.31 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 822
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 822 ;
Copy
73
0.20 ms
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 822
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 822 ;
Copy
74
0.09 ms
SELECT url_file FROM podcasts WHERE idpodcast = 822
SELECT url_file FROM podcasts WHERE idpodcast = 822 ;
Copy
75
0.04 ms
SELECT url_file FROM podcasts WHERE idpodcast = 822
SELECT url_file FROM podcasts WHERE idpodcast = 822 ;
Copy
76
0.32 ms
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = ?
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = '953' ;
Copy
77
0.38 ms
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 953
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 953 ;
Copy
78
0.20 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 15230
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 15230 ;
Copy
79
0.40 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19768
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19768 ;
Copy
80
0.20 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19791
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19791 ;
Copy
81
0.16 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20319
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20319 ;
Copy
82
0.21 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20512
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20512 ;
Copy
83
0.21 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24822
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24822 ;
Copy
84
0.24 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 953
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 953 ;
Copy
85
0.37 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 953
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 953 ;
Copy
86
0.38 ms
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 953
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 953 ;
Copy
87
0.11 ms
SELECT url_file FROM podcasts WHERE idpodcast = 953
SELECT url_file FROM podcasts WHERE idpodcast = 953 ;
Copy
88
0.04 ms
SELECT url_file FROM podcasts WHERE idpodcast = 953
SELECT url_file FROM podcasts WHERE idpodcast = 953 ;
Copy
89
0.26 ms
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = ?
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = '957' ;
Copy
90
0.29 ms
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 957
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 957 ;
Copy
91
0.22 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 13272
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 13272 ;
Copy
92
0.58 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 17766
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 17766 ;
Copy
93
0.28 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 17988
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 17988 ;
Copy
94
0.15 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19414
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19414 ;
Copy
95
0.14 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19683
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19683 ;
Copy
96
0.14 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19980
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19980 ;
Copy
97
0.26 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 957
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 957 ;
Copy
98
0.34 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 957
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 957 ;
Copy
99
0.22 ms
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 957
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 957 ;
Copy
100
0.10 ms
SELECT url_file FROM podcasts WHERE idpodcast = 957
SELECT url_file FROM podcasts WHERE idpodcast = 957 ;
Copy
101
0.04 ms
SELECT url_file FROM podcasts WHERE idpodcast = 957
SELECT url_file FROM podcasts WHERE idpodcast = 957 ;
Copy
102
0.40 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 (20477 ) 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 (20477 ) AND c . `classification` = 'class_auteur_meme' ;
Copy
103
3.20 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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 ) AND s . date > = '2024-04-20' 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 (
5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 ,
6241 , 6245 , 6527 , 6586 , 6707 , 6944 ,
6994 , 7063 , 7130 , 7599 , 7691 , 8217 ,
8382 , 8496 , 8507 , 8597 , 8942 , 10148 ,
10200 , 10540 , 11531 , 11630 , 11655 ,
12137 , 13156 , 14546 , 14631 , 15135 ,
15914 , 15964 , 16397 , 16431 , 16506 ,
16674 , 16994 , 17234 , 17568 , 17766 ,
17840 , 19389 , 19605 , 19768 , 20033 ,
20286 , 20467 , 20688 , 20890 , 21288 ,
22407 , 22482 , 23620 , 24011 , 24839 ,
25913 , 26040 , 26338 , 26476 , 27755 ,
27856 , 27947 , 28131 , 28141 , 29109 ,
29196 , 29354 , 30308 , 30553 , 30573 ,
30653 , 31429 , 31477 , 31782 , 32213 ,
34892 , 36575 , 37301
)
AND s . date > = '2024-04-20'
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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 ) AND s . date > = '2024-04-20' ORDER BY s . date ASC LIMIT 0 , 1 ;
Copy
104
4.28 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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 )
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 (
5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 ,
6241 , 6245 , 6527 , 6586 , 6707 , 6944 ,
6994 , 7063 , 7130 , 7599 , 7691 , 8217 ,
8382 , 8496 , 8507 , 8597 , 8942 , 10148 ,
10200 , 10540 , 11531 , 11630 , 11655 ,
12137 , 13156 , 14546 , 14631 , 15135 ,
15914 , 15964 , 16397 , 16431 , 16506 ,
16674 , 16994 , 17234 , 17568 , 17766 ,
17840 , 19389 , 19605 , 19768 , 20033 ,
20286 , 20467 , 20688 , 20890 , 21288 ,
22407 , 22482 , 23620 , 24011 , 24839 ,
25913 , 26040 , 26338 , 26476 , 27755 ,
27856 , 27947 , 28131 , 28141 , 29109 ,
29196 , 29354 , 30308 , 30553 , 30573 ,
30653 , 31429 , 31477 , 31782 , 32213 ,
34892 , 36575 , 37301
)
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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 )
GROUP BY spectacles . `idspectacle`
ORDER BY schedules . `date` ;
Copy
105
0.80 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 = 20477 ) 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 = 20477 ) AND T1 . publish = 1 ;
Copy
106
0.89 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 20477
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 = 20477
AND om . object = 'persons'
AND m . publish = 1 ;
Copy
107
0.49 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` = 20477 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` = 20477 AND d . code_franceinter IS NOT NULL ;
Copy
108
0.51 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` = 20477 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` = 20477 AND d . code_soundcloud IS NOT NULL ;
Copy
109
1.57 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 (7642 , 7686 , 8062 , 8484 , 8681 , 8741 , 8770 , 9106 , 9188 , 9189 , 9506 , 9548 , 9568 , 11033 , 11062 , 11370 , 11371 , 11618 , 12215 , 13550 , 13946 , 18473 , 18602 , 20690 , 20951 , 21586 , 23816 , 32253 , 34514 , 10044 , 10713 , 32485 , 34572 , 44853 , 18770 , 10815 , 19222 , 31001 , 25136 , 34815 , 21325 , 25614 , 13947 , 18618 , 18686 , 32254 , 34476 , 7688 , 10712 , 7687 , 8063 , 8485 , 8682 , 8742 , 8771 , 9107 , 11736 , 9193 , 15145 , 38008 , 9190 , 9507 , 9549 , 9582 , 11820 , 25415 , 37961 , 11372 , 11652 , 12229 , 13551 , 18474 , 18617 , 41892 , 20698 , 20952 , 21587 , 23817 ) 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 (
7642 , 7686 , 8062 , 8484 , 8681 , 8741 , 8770 ,
9106 , 9188 , 9189 , 9506 , 9548 , 9568 ,
11033 , 11062 , 11370 , 11371 , 11618 ,
12215 , 13550 , 13946 , 18473 , 18602 ,
20690 , 20951 , 21586 , 23816 , 32253 ,
34514 , 10044 , 10713 , 32485 , 34572 ,
44853 , 18770 , 10815 , 19222 , 31001 ,
25136 , 34815 , 21325 , 25614 , 13947 ,
18618 , 18686 , 32254 , 34476 , 7688 , 10712 ,
7687 , 8063 , 8485 , 8682 , 8742 , 8771 ,
9107 , 11736 , 9193 , 15145 , 38008 , 9190 ,
9507 , 9549 , 9582 , 11820 , 25415 , 37961 ,
11372 , 11652 , 12229 , 13551 , 18474 ,
18617 , 41892 , 20698 , 20952 , 21587 ,
23817
)
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 (7642 , 7686 , 8062 , 8484 , 8681 , 8741 , 8770 , 9106 , 9188 , 9189 , 9506 , 9548 , 9568 , 11033 , 11062 , 11370 , 11371 , 11618 , 12215 , 13550 , 13946 , 18473 , 18602 , 20690 , 20951 , 21586 , 23816 , 32253 , 34514 , 10044 , 10713 , 32485 , 34572 , 44853 , 18770 , 10815 , 19222 , 31001 , 25136 , 34815 , 21325 , 25614 , 13947 , 18618 , 18686 , 32254 , 34476 , 7688 , 10712 , 7687 , 8063 , 8485 , 8682 , 8742 , 8771 , 9107 , 11736 , 9193 , 15145 , 38008 , 9190 , 9507 , 9549 , 9582 , 11820 , 25415 , 37961 , 11372 , 11652 , 12229 , 13551 , 18474 , 18617 , 41892 , 20698 , 20952 , 21587 , 23817 ) ORDER BY publication_year DESC ;
Copy
110
39.12 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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 ) 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 (
5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 ,
6241 , 6245 , 6527 , 6586 , 6707 , 6944 ,
6994 , 7063 , 7130 , 7599 , 7691 , 8217 ,
8382 , 8496 , 8507 , 8597 , 8942 , 10148 ,
10200 , 10540 , 11531 , 11630 , 11655 ,
12137 , 13156 , 14546 , 14631 , 15135 ,
15914 , 15964 , 16397 , 16431 , 16506 ,
16674 , 16994 , 17234 , 17568 , 17766 ,
17840 , 19389 , 19605 , 19768 , 20033 ,
20286 , 20467 , 20688 , 20890 , 21288 ,
22407 , 22482 , 23620 , 24011 , 24839 ,
25913 , 26040 , 26338 , 26476 , 27755 ,
27856 , 27947 , 28131 , 28141 , 29109 ,
29196 , 29354 , 30308 , 30553 , 30573 ,
30653 , 31429 , 31477 , 31782 , 32213 ,
34892 , 36575 , 37301
)
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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 ) ORDER BY sclr_1 DESC ;
Copy
111
6.21 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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 ) 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 (
5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 ,
6241 , 6245 , 6527 , 6586 , 6707 , 6944 ,
6994 , 7063 , 7130 , 7599 , 7691 , 8217 ,
8382 , 8496 , 8507 , 8597 , 8942 , 10148 ,
10200 , 10540 , 11531 , 11630 , 11655 ,
12137 , 13156 , 14546 , 14631 , 15135 ,
15914 , 15964 , 16397 , 16431 , 16506 ,
16674 , 16994 , 17234 , 17568 , 17766 ,
17840 , 19389 , 19605 , 19768 , 20033 ,
20286 , 20467 , 20688 , 20890 , 21288 ,
22407 , 22482 , 23620 , 24011 , 24839 ,
25913 , 26040 , 26338 , 26476 , 27755 ,
27856 , 27947 , 28131 , 28141 , 29109 ,
29196 , 29354 , 30308 , 30553 , 30573 ,
30653 , 31429 , 31477 , 31782 , 32213 ,
34892 , 36575 , 37301
)
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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 ) ORDER BY sclr_1 DESC ;
Copy
112
2.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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 ) 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 (
5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 ,
6241 , 6245 , 6527 , 6586 , 6707 , 6944 ,
6994 , 7063 , 7130 , 7599 , 7691 , 8217 ,
8382 , 8496 , 8507 , 8597 , 8942 , 10148 ,
10200 , 10540 , 11531 , 11630 , 11655 ,
12137 , 13156 , 14546 , 14631 , 15135 ,
15914 , 15964 , 16397 , 16431 , 16506 ,
16674 , 16994 , 17234 , 17568 , 17766 ,
17840 , 19389 , 19605 , 19768 , 20033 ,
20286 , 20467 , 20688 , 20890 , 21288 ,
22407 , 22482 , 23620 , 24011 , 24839 ,
25913 , 26040 , 26338 , 26476 , 27755 ,
27856 , 27947 , 28131 , 28141 , 29109 ,
29196 , 29354 , 30308 , 30553 , 30573 ,
30653 , 31429 , 31477 , 31782 , 32213 ,
34892 , 36575 , 37301
)
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 (5217 , 5229 , 5355 , 5567 , 5798 , 5889 , 6168 , 6241 , 6245 , 6527 , 6586 , 6707 , 6944 , 6994 , 7063 , 7130 , 7599 , 7691 , 8217 , 8382 , 8496 , 8507 , 8597 , 8942 , 10148 , 10200 , 10540 , 11531 , 11630 , 11655 , 12137 , 13156 , 14546 , 14631 , 15135 , 15914 , 15964 , 16397 , 16431 , 16506 , 16674 , 16994 , 17234 , 17568 , 17766 , 17840 , 19389 , 19605 , 19768 , 20033 , 20286 , 20467 , 20688 , 20890 , 21288 , 22407 , 22482 , 23620 , 24011 , 24839 , 25913 , 26040 , 26338 , 26476 , 27755 , 27856 , 27947 , 28131 , 28141 , 29109 , 29196 , 29354 , 30308 , 30553 , 30573 , 30653 , 31429 , 31477 , 31782 , 32213 , 34892 , 36575 , 37301 ) 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
113
0.57 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 :
[
"701b27e808df2b60906dc9589ea99bc2-3fbd "
0
"022a03a266c23482978b481081978728 "
]
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 = '701b27e808df2b60906dc9589ea99bc2-3fbd' AND t0 . idcontent = 0 AND t0 . md5url = '022a03a266c23482978b481081978728' ;
Copy
114
1.51 ms
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/biographies/Bertolt-Brecht/podcasts/ "
"022a03a266c23482978b481081978728 "
0
"persons "
20477
0
"fr "
"701b27e808df2b60906dc9589ea99bc2-3fbd "
"/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/Bertolt-Brecht/podcasts/' , '022a03a266c23482978b481081978728' , 0 , 'persons' , 20477 , 0 , 'fr' , '701b27e808df2b60906dc9589ea99bc2-3fbd' , '/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553' );
Copy
115
0.16 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
116
0.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 = '20477'
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 = '20477'
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
117
0.88 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