1
0.36 ms
SELECT idcontact FROM contacts WHERE url_clean = 'France-Inter'
SELECT idcontact FROM contacts WHERE url_clean = 'France-Inter' ;
Copy
2
0.55 ms
SELECT c0_ . idcontact AS idcontact_0 , c0_ . type AS type_1 , c0_ . organisation AS organisation_2 , c0_ . nom_suite AS nom_suite_3 , c0_ . lastname AS lastname_4 , c0_ . firstname AS firstname_5 , c0_ . idtypestructure AS idtypestructure_6 , c0_ . license AS license_7 , c0_ . comment AS comment_8 , c0_ . private_comment AS private_comment_9 , c0_ . address1 AS address1_10 , c0_ . address2 AS address2_11 , c0_ . zip AS zip_12 , c0_ . city AS city_13 , c0_ . phone1 AS phone1_14 , c0_ . phone2 AS phone2_15 , c0_ . fax AS fax_16 , c0_ . email1 AS email1_17 , c0_ . email1_online AS email1_online_18 , c0_ . email2_online AS email2_online_19 , c0_ . email2 AS email2_20 , c0_ . url AS url_21 , c0_ . url_ticket AS url_ticket_22 , c0_ . facebook AS facebook_23 , c0_ . twitter AS twitter_24 , c0_ . instagram AS instagram_25 , c0_ . mobile AS mobile_26 , c0_ . geocodable AS geocodable_27 , c0_ . x AS x_28 , c0_ . y AS y_29 , c0_ . idmultimedia AS idmultimedia_30 , c0_ . type_view AS type_view_31 , c0_ . stats_access AS stats_access_32 , c0_ . ga_tracking_id AS ga_tracking_id_33 , c0_ . is_festival AS is_festival_34 , c0_ . link_on_video AS link_on_video_35 , c0_ . is_partenaire AS is_partenaire_36 , c0_ . valid_version AS valid_version_37 , c0_ . other_versions AS other_versions_38 , c0_ . url_redirect AS url_redirect_39 , c0_ . url_clean AS url_clean_40 , c0_ . dateupdate AS dateupdate_41 , c0_ . dateinsert AS dateinsert_42 , c0_ . publish AS publish_43 , c0_ . valid AS valid_44 , c1_ . id AS id_45 , c1_ . fr AS fr_46 , c1_ . en AS en_47 , c1_ . es AS es_48 , c1_ . pt AS pt_49 , c1_ . de AS de_50 , c1_ . ru AS ru_51 , c1_ . orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_ . country = c1_ . id WHERE c0_ . idcontact = ?
SELECT
c0_ . idcontact AS idcontact_0 ,
c0_ . type AS type_1 ,
c0_ . organisation AS organisation_2 ,
c0_ . nom_suite AS nom_suite_3 ,
c0_ . lastname AS lastname_4 ,
c0_ . firstname AS firstname_5 ,
c0_ . idtypestructure AS idtypestructure_6 ,
c0_ . license AS license_7 ,
c0_ . comment AS comment_8 ,
c0_ . private_comment AS private_comment_9 ,
c0_ . address1 AS address1_10 ,
c0_ . address2 AS address2_11 ,
c0_ . zip AS zip_12 ,
c0_ . city AS city_13 ,
c0_ . phone1 AS phone1_14 ,
c0_ . phone2 AS phone2_15 ,
c0_ . fax AS fax_16 ,
c0_ . email1 AS email1_17 ,
c0_ . email1_online AS email1_online_18 ,
c0_ . email2_online AS email2_online_19 ,
c0_ . email2 AS email2_20 ,
c0_ . url AS url_21 ,
c0_ . url_ticket AS url_ticket_22 ,
c0_ . facebook AS facebook_23 ,
c0_ . twitter AS twitter_24 ,
c0_ . instagram AS instagram_25 ,
c0_ . mobile AS mobile_26 ,
c0_ . geocodable AS geocodable_27 ,
c0_ . x AS x_28 ,
c0_ . y AS y_29 ,
c0_ . idmultimedia AS idmultimedia_30 ,
c0_ . type_view AS type_view_31 ,
c0_ . stats_access AS stats_access_32 ,
c0_ . ga_tracking_id AS ga_tracking_id_33 ,
c0_ . is_festival AS is_festival_34 ,
c0_ . link_on_video AS link_on_video_35 ,
c0_ . is_partenaire AS is_partenaire_36 ,
c0_ . valid_version AS valid_version_37 ,
c0_ . other_versions AS other_versions_38 ,
c0_ . url_redirect AS url_redirect_39 ,
c0_ . url_clean AS url_clean_40 ,
c0_ . dateupdate AS dateupdate_41 ,
c0_ . dateinsert AS dateinsert_42 ,
c0_ . publish AS publish_43 ,
c0_ . valid AS valid_44 ,
c1_ . id AS id_45 ,
c1_ . fr AS fr_46 ,
c1_ . en AS en_47 ,
c1_ . es AS es_48 ,
c1_ . pt AS pt_49 ,
c1_ . de AS de_50 ,
c1_ . ru AS ru_51 ,
c1_ . orderby AS orderby_52
FROM
contacts c0_
LEFT JOIN countries c1_ ON c0_ . country = c1_ . id
WHERE
c0_ . idcontact = ?
Copy
SELECT c0_ . idcontact AS idcontact_0 , c0_ . type AS type_1 , c0_ . organisation AS organisation_2 , c0_ . nom_suite AS nom_suite_3 , c0_ . lastname AS lastname_4 , c0_ . firstname AS firstname_5 , c0_ . idtypestructure AS idtypestructure_6 , c0_ . license AS license_7 , c0_ . comment AS comment_8 , c0_ . private_comment AS private_comment_9 , c0_ . address1 AS address1_10 , c0_ . address2 AS address2_11 , c0_ . zip AS zip_12 , c0_ . city AS city_13 , c0_ . phone1 AS phone1_14 , c0_ . phone2 AS phone2_15 , c0_ . fax AS fax_16 , c0_ . email1 AS email1_17 , c0_ . email1_online AS email1_online_18 , c0_ . email2_online AS email2_online_19 , c0_ . email2 AS email2_20 , c0_ . url AS url_21 , c0_ . url_ticket AS url_ticket_22 , c0_ . facebook AS facebook_23 , c0_ . twitter AS twitter_24 , c0_ . instagram AS instagram_25 , c0_ . mobile AS mobile_26 , c0_ . geocodable AS geocodable_27 , c0_ . x AS x_28 , c0_ . y AS y_29 , c0_ . idmultimedia AS idmultimedia_30 , c0_ . type_view AS type_view_31 , c0_ . stats_access AS stats_access_32 , c0_ . ga_tracking_id AS ga_tracking_id_33 , c0_ . is_festival AS is_festival_34 , c0_ . link_on_video AS link_on_video_35 , c0_ . is_partenaire AS is_partenaire_36 , c0_ . valid_version AS valid_version_37 , c0_ . other_versions AS other_versions_38 , c0_ . url_redirect AS url_redirect_39 , c0_ . url_clean AS url_clean_40 , c0_ . dateupdate AS dateupdate_41 , c0_ . dateinsert AS dateinsert_42 , c0_ . publish AS publish_43 , c0_ . valid AS valid_44 , c1_ . id AS id_45 , c1_ . fr AS fr_46 , c1_ . en AS en_47 , c1_ . es AS es_48 , c1_ . pt AS pt_49 , c1_ . de AS de_50 , c1_ . ru AS ru_51 , c1_ . orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_ . country = c1_ . id WHERE c0_ . idcontact = 5222 ;
Copy
3
0.06 ms
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
4
0.17 ms
SELECT t0_ . idtypestructure AS idtypestructure_0 , t0_ . typestructure_pluriel AS typestructure_pluriel_1 , t0_ . typestructure AS typestructure_2 , t0_ . public_view AS public_view_3 , t0_ . order_view AS order_view_4 FROM typesstructures t0_ WHERE t0_ . idtypestructure = ?
SELECT t0_ . idtypestructure AS idtypestructure_0 , t0_ . typestructure_pluriel AS typestructure_pluriel_1 , t0_ . typestructure AS typestructure_2 , t0_ . public_view AS public_view_3 , t0_ . order_view AS order_view_4 FROM typesstructures t0_ WHERE t0_ . idtypestructure = 'JL' ;
Copy
5
0.33 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j2 . idoffice , j2 . date_start , j2 . date_end , j3 . idcontact FROM theatreok_dev . persons j1 , theatreok_dev . contact_person j2 , theatreok_dev . contacts j3
WHERE j3 . idcontact = j2 . idcontact
AND j1 . idperson = j2 . idperson
AND j3 . idcontact = 5222 AND j2 . idoffice = 1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j2 . idoffice , j2 . date_start , j2 . date_end , j3 . idcontact FROM theatreok_dev . persons j1 , theatreok_dev . contact_person j2 , theatreok_dev . contacts j3
WHERE j3 . idcontact = j2 . idcontact
AND j1 . idperson = j2 . idperson
AND j3 . idcontact = 5222 AND j2 . idoffice = 1 ;
Copy
6
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . idclassification IN (100 ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . idclassification IN (100 ))) AND contacts = 1 ;
Copy
7
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 = '5222'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (100 ))) 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 = '5222'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (100 ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
8
1.71 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 5222 OR schedules . idcontact_festival = 5222 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 5222 OR schedules . idcontact_festival = 5222 );
Copy
9
103.78 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 5222 OR spectacles . `idcontact_production` = 5222 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 5222 OR spectacles . `idcontact_production` = 5222 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 );
Copy
10
2.76 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 5222 OR spectacles . `idcontact_production` = 5222 ) AND spectacle_contact . `idrole` = 77
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 5222 OR spectacles . `idcontact_production` = 5222 ) AND spectacle_contact . `idrole` = 77 ;
Copy
11
0.97 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 5222
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 5222 ;
Copy
12
0.28 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 5222 AND aides . type_aide IN (2 , 3 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 5222 AND aides . type_aide IN (2 , 3 ) ;
Copy
13
0.23 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 5222 AND aides . type_aide IN (1 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 5222 AND aides . type_aide IN (1 ) ;
Copy
14
0.31 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 5222 AND aides . type_aide IN (4 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 5222 AND aides . type_aide IN (4 ) ;
Copy
15
14.05 ms
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (27986 , 27986 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 5222
)
)
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (27986 , 27986 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 5222
)
);
Copy
16
10.53 ms
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `name_program` = 'l-heure-bleue' AND podcasts . `type_franceinter` = 1
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `name_program` = 'l-heure-bleue' AND podcasts . `type_franceinter` = 1
;
Copy
17
5.03 ms
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `name_program` = 'l-heure-bleue' AND podcasts . `type_franceinter` = 1
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 10
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `name_program` = 'l-heure-bleue' AND podcasts . `type_franceinter` = 1
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 10 ;
Copy
18
0.84 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 = '4893' ;
Copy
19
0.53 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 = 4893
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 = 4893 ;
Copy
20
0.18 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 35590
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 35590 ;
Copy
21
0.32 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 = 4893
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 = 4893 ;
Copy
22
0.90 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 = 4893
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 = 4893 ;
Copy
23
0.21 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 = 4893
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 = 4893 ;
Copy
24
0.25 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4893
SELECT url_file FROM podcasts WHERE idpodcast = 4893 ;
Copy
25
0.19 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4893
SELECT url_file FROM podcasts WHERE idpodcast = 4893 ;
Copy
26
0.97 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 = '4802' ;
Copy
27
0.82 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 = 4802
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 = 4802 ;
Copy
28
0.51 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 = 4802
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 = 4802 ;
Copy
29
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 = 4802
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 = 4802 ;
Copy
30
1.02 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 = 4802
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 = 4802 ;
Copy
31
0.89 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4802
SELECT url_file FROM podcasts WHERE idpodcast = 4802 ;
Copy
32
0.30 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4802
SELECT url_file FROM podcasts WHERE idpodcast = 4802 ;
Copy
33
0.89 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 = '4768' ;
Copy
34
1.54 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 = 4768
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 = 4768 ;
Copy
35
0.72 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 = 4768
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 = 4768 ;
Copy
36
1.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 = 4768
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 = 4768 ;
Copy
37
0.82 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 = 4768
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 = 4768 ;
Copy
38
0.36 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4768
SELECT url_file FROM podcasts WHERE idpodcast = 4768 ;
Copy
39
0.10 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4768
SELECT url_file FROM podcasts WHERE idpodcast = 4768 ;
Copy
40
0.77 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 = '4769' ;
Copy
41
1.50 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 = 4769
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 = 4769 ;
Copy
42
1.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 = 4769
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 = 4769 ;
Copy
43
0.58 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 = 4769
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 = 4769 ;
Copy
44
0.47 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 = 4769
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 = 4769 ;
Copy
45
0.21 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4769
SELECT url_file FROM podcasts WHERE idpodcast = 4769 ;
Copy
46
0.14 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4769
SELECT url_file FROM podcasts WHERE idpodcast = 4769 ;
Copy
47
0.45 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 = '4770' ;
Copy
48
1.12 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 = 4770
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 = 4770 ;
Copy
49
1.13 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 30701
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 30701 ;
Copy
50
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 = 4770
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 = 4770 ;
Copy
51
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 = 4770
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 = 4770 ;
Copy
52
0.68 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 = 4770
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 = 4770 ;
Copy
53
0.18 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4770
SELECT url_file FROM podcasts WHERE idpodcast = 4770 ;
Copy
54
0.07 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4770
SELECT url_file FROM podcasts WHERE idpodcast = 4770 ;
Copy
55
0.88 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 = '4728' ;
Copy
56
0.33 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 = 4728
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 = 4728 ;
Copy
57
0.23 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
58
0.27 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 = 4728
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 = 4728 ;
Copy
59
0.33 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 = 4728
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 = 4728 ;
Copy
60
0.35 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 = 4728
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 = 4728 ;
Copy
61
0.22 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4728
SELECT url_file FROM podcasts WHERE idpodcast = 4728 ;
Copy
62
0.07 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4728
SELECT url_file FROM podcasts WHERE idpodcast = 4728 ;
Copy
63
0.38 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 = '4729' ;
Copy
64
0.35 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 = 4729
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 = 4729 ;
Copy
65
0.22 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
66
0.19 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 = 4729
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 = 4729 ;
Copy
67
0.21 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 = 4729
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 = 4729 ;
Copy
68
0.33 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 = 4729
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 = 4729 ;
Copy
69
0.15 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4729
SELECT url_file FROM podcasts WHERE idpodcast = 4729 ;
Copy
70
0.05 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4729
SELECT url_file FROM podcasts WHERE idpodcast = 4729 ;
Copy
71
0.50 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 = '4686' ;
Copy
72
0.25 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 = 4686
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 = 4686 ;
Copy
73
0.16 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 11684
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 11684 ;
Copy
74
0.14 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 12326
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 12326 ;
Copy
75
0.21 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19379
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 19379 ;
Copy
76
0.29 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20628
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20628 ;
Copy
77
0.15 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 32662
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 32662 ;
Copy
78
0.19 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 = 4686
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 = 4686 ;
Copy
79
0.20 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 = 4686
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 = 4686 ;
Copy
80
0.21 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 = 4686
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 = 4686 ;
Copy
81
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 = 15009 ;
Copy
82
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 = 15009 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 = 15009 ORDER BY j2 . classement ASC ;
Copy
83
0.12 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 = 16038 ;
Copy
84
0.22 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 = 16038 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 = 16038 ORDER BY j2 . classement ASC ;
Copy
85
0.10 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 = 21653 ;
Copy
86
0.23 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 = 21653 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 = 21653 ORDER BY j2 . classement ASC ;
Copy
87
0.14 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 = 22100 ;
Copy
88
0.22 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 = 22100 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 = 22100 ORDER BY j2 . classement ASC ;
Copy
89
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 = 40670 ;
Copy
90
1.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 = 40670 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 = 40670 ORDER BY j2 . classement ASC ;
Copy
91
0.58 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4686
SELECT url_file FROM podcasts WHERE idpodcast = 4686 ;
Copy
92
0.07 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4686
SELECT url_file FROM podcasts WHERE idpodcast = 4686 ;
Copy
93
0.55 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 = '4687' ;
Copy
94
0.52 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 = 4687
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 = 4687 ;
Copy
95
0.58 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 34316
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 34316 ;
Copy
96
0.88 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 = 4687
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 = 4687 ;
Copy
97
0.54 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 = 4687
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 = 4687 ;
Copy
98
0.57 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 = 4687
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 = 4687 ;
Copy
99
0.33 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4687
SELECT url_file FROM podcasts WHERE idpodcast = 4687 ;
Copy
100
0.07 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4687
SELECT url_file FROM podcasts WHERE idpodcast = 4687 ;
Copy
101
0.35 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 = '4688' ;
Copy
102
0.72 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 = 4688
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 = 4688 ;
Copy
103
0.39 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 = 4688
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 = 4688 ;
Copy
104
0.44 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 = 4688
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 = 4688 ;
Copy
105
0.47 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 = 4688
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 = 4688 ;
Copy
106
0.27 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4688
SELECT url_file FROM podcasts WHERE idpodcast = 4688 ;
Copy
107
0.05 ms
SELECT url_file FROM podcasts WHERE idpodcast = 4688
SELECT url_file FROM podcasts WHERE idpodcast = 4688 ;
Copy
108
0.07 ms
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (27986 , 27986 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 5222
)
)
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (27986 , 27986 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 5222
)
);
Copy
109
0.05 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_presentation_structure' ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_presentation_structure' ))) AND contacts = 1 ;
Copy
110
1.90 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 = '5222'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_presentation_structure' ))) 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 = '5222'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_presentation_structure' ))) ORDER BY c . `range` , c . idcontent ;
Copy
111
0.07 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_article' ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_article' ))) AND contacts = 1 ;
Copy
112
1.45 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 = '5222'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '5222'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent ;
Copy
113
0.31 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 2 ;
Copy
114
0.57 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 2 ;
Copy
115
0.37 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 2 ;
Copy
116
0.75 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 2 ;
Copy
117
0.24 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 3
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 3 ;
Copy
118
0.20 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 3
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 3 ;
Copy
119
0.14 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 3
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 3 ;
Copy
120
0.13 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 3
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 3 ;
Copy
121
0.38 ms
SELECT COUNT (p . idplaylist )
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
LEFT JOIN aides a ON a . idcontact = 5222
LEFT JOIN text_aide ta ON a . `idaide` = ta . `idaide`
WHERE 1 AND a . `publish` = 1 AND a . `type_aide` IN (2 , 3 ) AND pc . idclassification = 144 AND p . idtext = ta . idtext
GROUP BY p . idtext
SELECT COUNT (p . idplaylist )
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
LEFT JOIN aides a ON a . idcontact = 5222
LEFT JOIN text_aide ta ON a . `idaide` = ta . `idaide`
WHERE 1 AND a . `publish` = 1 AND a . `type_aide` IN (2 , 3 ) AND pc . idclassification = 144 AND p . idtext = ta . idtext
GROUP BY p . idtext ;
Copy
122
0.21 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 1 ;
Copy
123
0.14 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 1 ;
Copy
124
0.13 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 1 ;
Copy
125
0.21 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 1 ;
Copy
126
0.23 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 4
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 4 ;
Copy
127
0.12 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 4
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 4 ;
Copy
128
0.19 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 4
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 4 ;
Copy
129
0.30 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 4
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 5222
AND aides . `type_aide` = 4 ;
Copy
130
353.43 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE s0_ . textfictif = 0 AND p8_ . code_franceinter IS NOT NULL AND p8_ . type_franceinter = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE s0_ . textfictif = 0 AND p8_ . code_franceinter IS NOT NULL AND p8_ . type_franceinter = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC ;
Copy
131
0.77 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (5222 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-03-29' AND '2026-03-19' )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (5222 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-03-29' AND '2026-03-19' )) ORDER BY s1_ . date ASC ;
Copy
132
1.09 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (5222 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-03-29' ORDER BY s1_ . date DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (5222 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-03-29' ORDER BY s1_ . date DESC ;
Copy
133
0.49 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-03-29' AND (s0_ . publish = 1 AND s1_ . idcontact = 5222 ) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-03-29' AND (s0_ . publish = 1 AND s1_ . idcontact = 5222 ) ORDER BY s1_ . date ASC ;
Copy
134
0.38 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 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 c2_ ON s1_ . idcontact = c2_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND (s0_ . publish = 1 AND s1_ . idcontact = 5222 ) ORDER BY s1_ . date DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 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 c2_ ON s1_ . idcontact = c2_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND (s0_ . publish = 1 AND s1_ . idcontact = 5222 ) ORDER BY s1_ . date DESC ;
Copy
135
0.64 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 5222 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 5222 )) ORDER BY sclr_1 DESC ;
Copy
136
135.60 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 5222 OR s0_ . idcontact_production = 5222 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 5222 OR s0_ . idcontact_production = 5222 )) ORDER BY sclr_1 DESC ;
Copy
137
27.92 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-03-29' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 5222 OR s0_ . idcontact_production = 5222 )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-03-29' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 5222 OR s0_ . idcontact_production = 5222 )) ORDER BY s1_ . date ASC ;
Copy
138
0.98 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE p8_ . code_franceinter IS NOT NULL AND p8_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-03-29' AND (s0_ . publish = 1 AND s1_ . idcontact = 5222 ) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE p8_ . code_franceinter IS NOT NULL AND p8_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-03-29' AND (s0_ . publish = 1 AND s1_ . idcontact = 5222 ) ORDER BY s1_ . date ASC ;
Copy
139
0.57 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 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 c2_ ON s1_ . idcontact = c2_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE p8_ . code_franceinter IS NOT NULL AND p8_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND (s0_ . publish = 1 AND s1_ . idcontact = 5222 ) ORDER BY s1_ . date DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 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 c2_ ON s1_ . idcontact = c2_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE p8_ . code_franceinter IS NOT NULL AND p8_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND (s0_ . publish = 1 AND s1_ . idcontact = 5222 ) ORDER BY s1_ . date DESC ;
Copy
140
0.65 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 5222 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 5222 )) ORDER BY sclr_1 DESC ;
Copy
141
17.59 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 5222 OR s0_ . idcontact_production = 5222 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 5222 OR s0_ . idcontact_production = 5222 )) ORDER BY sclr_1 DESC ;
Copy
142
24.13 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-03-29' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 5222 OR s0_ . idcontact_production = 5222 )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-03-29' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 5222 OR s0_ . idcontact_production = 5222 )) ORDER BY s1_ . date ASC ;
Copy
143
0.65 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (5222 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (5222 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC ;
Copy
144
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_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 5222 ) 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_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 5222 ) AND T1 . publish = 1 ;
Copy
145
0.28 ms
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` IN (27986 ) AND d . code_franceinter IS NOT NULL
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` IN (27986 ) AND d . code_franceinter IS NOT NULL ;
Copy
146
0.22 ms
SELECT count (p0_ . idpodcast ) AS sclr_0 FROM podcasts p0_ INNER JOIN podcast_contact p2_ ON p0_ . idpodcast = p2_ . idpodcast INNER JOIN contacts c1_ ON c1_ . idcontact = p2_ . idcontact WHERE c1_ . idcontact = ?
SELECT count (p0_ . idpodcast ) AS sclr_0 FROM podcasts p0_ INNER JOIN podcast_contact p2_ ON p0_ . idpodcast = p2_ . idpodcast INNER JOIN contacts c1_ ON c1_ . idcontact = p2_ . idcontact WHERE c1_ . idcontact = 5222 ;
Copy
147
9.70 ms
SELECT COUNT (DISTINCT (spectacles . `idspectacle` )) as total FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 5222 OR spectacles . `idcontact_production` = 5222 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 )
SELECT COUNT (DISTINCT (spectacles . `idspectacle` )) as total FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 5222 OR spectacles . `idcontact_production` = 5222 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 ) ;
Copy
148
0.22 ms
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND contacts = 1 AND lagarce ! = 1 AND is_public IN (1 )
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND contacts = 1 AND lagarce ! = 1 AND is_public IN (1 ) ;
Copy
149
0.10 ms
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND spectacles = 1 AND lagarce ! = 1 AND is_public IN (1 )
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND spectacles = 1 AND lagarce ! = 1 AND is_public IN (1 ) ;
Copy
150
0.41 ms
SELECT COUNT (DISTINCT (of . idfile )) as total
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 = '5222'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (112 , 168 , 33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
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 = '5222'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (112 , 168 , 33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
151
0.43 ms
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 5222
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 5222 ;
Copy
152
0.84 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 :
[
"4b9222cf5d39a2bfa772f8242f6a0ca2-1bbc "
0
"34dd31e4f01e6c054a135714ab995188 "
]
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 = '4b9222cf5d39a2bfa772f8242f6a0ca2-1bbc' AND t0 . idcontent = 0 AND t0 . md5url = '34dd31e4f01e6c054a135714ab995188' ;
Copy
153
1.94 ms
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/contacts/France-Inter/podcasts/emission/l-heure-bleue "
"34dd31e4f01e6c054a135714ab995188 "
0
"contacts "
5222
0
"fr "
"4b9222cf5d39a2bfa772f8242f6a0ca2-1bbc "
"/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829 "
]
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES ('article' , 'thnet' , '/contacts/France-Inter/podcasts/emission/l-heure-bleue' , '34dd31e4f01e6c054a135714ab995188' , 0 , 'contacts' , 5222 , 0 , 'fr' , '4b9222cf5d39a2bfa772f8242f6a0ca2-1bbc' , '/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829' );
Copy
154
12.89 ms
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `type_franceinter` = 1
GROUP BY podcasts . `title_program`
ORDER BY title_program
ASC
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `type_franceinter` = 1
GROUP BY podcasts . `title_program`
ORDER BY title_program
ASC
;
Copy
155
1.01 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