Symfony Profiler

SELECT
  idspectacle
FROM
  spectacles
WHERE
  url_clean = 'Playlist-politique'

SELECT idspectacle FROM spectacles WHERE url_clean='Playlist-politique' ;

SELECT
  s0_.idspectacle AS idspectacle_0,
  s0_.title AS title_1,
  s0_.language AS language_2,
  s0_.creation_date AS creation_date_3,
  s0_.url_page AS url_page_4,
  s0_.infos AS infos_5,
  s0_.tag AS tag_6,
  s0_.id_rubrique AS id_rubrique_7,
  s0_.duration AS duration_8,
  s0_.interlude AS interlude_9,
  s0_.textfictif AS textfictif_10,
  s0_.url_redirect AS url_redirect_11,
  s0_.url_clean AS url_clean_12,
  s0_.dateupdate AS dateupdate_13,
  s0_.dateinsert AS dateinsert_14,
  s0_.publish AS publish_15,
  s0_.statut AS statut_16,
  s0_.valid AS valid_17,
  t1_.idtypespectacle AS idtypespectacle_18,
  c2_.idcontact AS idcontact_19,
  c2_.type AS type_20,
  c2_.organisation AS organisation_21,
  c2_.nom_suite AS nom_suite_22,
  c2_.lastname AS lastname_23,
  c2_.firstname AS firstname_24,
  c2_.idtypestructure AS idtypestructure_25,
  c2_.license AS license_26,
  c2_.comment AS comment_27,
  c2_.private_comment AS private_comment_28,
  c2_.address1 AS address1_29,
  c2_.address2 AS address2_30,
  c2_.zip AS zip_31,
  c2_.city AS city_32,
  c2_.phone1 AS phone1_33,
  c2_.phone2 AS phone2_34,
  c2_.fax AS fax_35,
  c2_.email1 AS email1_36,
  c2_.email1_online AS email1_online_37,
  c2_.email2_online AS email2_online_38,
  c2_.email2 AS email2_39,
  c2_.url AS url_40,
  c2_.url_ticket AS url_ticket_41,
  c2_.facebook AS facebook_42,
  c2_.twitter AS twitter_43,
  c2_.instagram AS instagram_44,
  c2_.mobile AS mobile_45,
  c2_.geocodable AS geocodable_46,
  c2_.x AS x_47,
  c2_.y AS y_48,
  c2_.idmultimedia AS idmultimedia_49,
  c2_.type_view AS type_view_50,
  c2_.stats_access AS stats_access_51,
  c2_.ga_tracking_id AS ga_tracking_id_52,
  c2_.is_festival AS is_festival_53,
  c2_.link_on_video AS link_on_video_54,
  c2_.is_partenaire AS is_partenaire_55,
  c2_.valid_version AS valid_version_56,
  c2_.other_versions AS other_versions_57,
  c2_.url_redirect AS url_redirect_58,
  c2_.url_clean AS url_clean_59,
  c2_.dateupdate AS dateupdate_60,
  c2_.dateinsert AS dateinsert_61,
  c2_.publish AS publish_62,
  c2_.valid AS valid_63,
  c3_.idcontact AS idcontact_64,
  c3_.type AS type_65,
  c3_.organisation AS organisation_66,
  c3_.nom_suite AS nom_suite_67,
  c3_.lastname AS lastname_68,
  c3_.firstname AS firstname_69,
  c3_.idtypestructure AS idtypestructure_70,
  c3_.license AS license_71,
  c3_.comment AS comment_72,
  c3_.private_comment AS private_comment_73,
  c3_.address1 AS address1_74,
  c3_.address2 AS address2_75,
  c3_.zip AS zip_76,
  c3_.city AS city_77,
  c3_.phone1 AS phone1_78,
  c3_.phone2 AS phone2_79,
  c3_.fax AS fax_80,
  c3_.email1 AS email1_81,
  c3_.email1_online AS email1_online_82,
  c3_.email2_online AS email2_online_83,
  c3_.email2 AS email2_84,
  c3_.url AS url_85,
  c3_.url_ticket AS url_ticket_86,
  c3_.facebook AS facebook_87,
  c3_.twitter AS twitter_88,
  c3_.instagram AS instagram_89,
  c3_.mobile AS mobile_90,
  c3_.geocodable AS geocodable_91,
  c3_.x AS x_92,
  c3_.y AS y_93,
  c3_.idmultimedia AS idmultimedia_94,
  c3_.type_view AS type_view_95,
  c3_.stats_access AS stats_access_96,
  c3_.ga_tracking_id AS ga_tracking_id_97,
  c3_.is_festival AS is_festival_98,
  c3_.link_on_video AS link_on_video_99,
  c3_.is_partenaire AS is_partenaire_100,
  c3_.valid_version AS valid_version_101,
  c3_.other_versions AS other_versions_102,
  c3_.url_redirect AS url_redirect_103,
  c3_.url_clean AS url_clean_104,
  c3_.dateupdate AS dateupdate_105,
  c3_.dateinsert AS dateinsert_106,
  c3_.publish AS publish_107,
  c3_.valid AS valid_108,
  e4_.idextranetuser AS idextranetuser_109
FROM
  spectacles s0_
  LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle
  LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact
  LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact
  LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser
WHERE
  s0_.idspectacle = ?

SELECT s0_.idspectacle AS idspectacle_0, s0_.title AS title_1, s0_.language AS language_2, s0_.creation_date AS creation_date_3, s0_.url_page AS url_page_4, s0_.infos AS infos_5, s0_.tag AS tag_6, s0_.id_rubrique AS id_rubrique_7, s0_.duration AS duration_8, s0_.interlude AS interlude_9, s0_.textfictif AS textfictif_10, s0_.url_redirect AS url_redirect_11, s0_.url_clean AS url_clean_12, s0_.dateupdate AS dateupdate_13, s0_.dateinsert AS dateinsert_14, s0_.publish AS publish_15, s0_.statut AS statut_16, s0_.valid AS valid_17, t1_.idtypespectacle AS idtypespectacle_18, c2_.idcontact AS idcontact_19, c2_.type AS type_20, c2_.organisation AS organisation_21, c2_.nom_suite AS nom_suite_22, c2_.lastname AS lastname_23, c2_.firstname AS firstname_24, c2_.idtypestructure AS idtypestructure_25, c2_.license AS license_26, c2_.comment AS comment_27, c2_.private_comment AS private_comment_28, c2_.address1 AS address1_29, c2_.address2 AS address2_30, c2_.zip AS zip_31, c2_.city AS city_32, c2_.phone1 AS phone1_33, c2_.phone2 AS phone2_34, c2_.fax AS fax_35, c2_.email1 AS email1_36, c2_.email1_online AS email1_online_37, c2_.email2_online AS email2_online_38, c2_.email2 AS email2_39, c2_.url AS url_40, c2_.url_ticket AS url_ticket_41, c2_.facebook AS facebook_42, c2_.twitter AS twitter_43, c2_.instagram AS instagram_44, c2_.mobile AS mobile_45, c2_.geocodable AS geocodable_46, c2_.x AS x_47, c2_.y AS y_48, c2_.idmultimedia AS idmultimedia_49, c2_.type_view AS type_view_50, c2_.stats_access AS stats_access_51, c2_.ga_tracking_id AS ga_tracking_id_52, c2_.is_festival AS is_festival_53, c2_.link_on_video AS link_on_video_54, c2_.is_partenaire AS is_partenaire_55, c2_.valid_version AS valid_version_56, c2_.other_versions AS other_versions_57, c2_.url_redirect AS url_redirect_58, c2_.url_clean AS url_clean_59, c2_.dateupdate AS dateupdate_60, c2_.dateinsert AS dateinsert_61, c2_.publish AS publish_62, c2_.valid AS valid_63, c3_.idcontact AS idcontact_64, c3_.type AS type_65, c3_.organisation AS organisation_66, c3_.nom_suite AS nom_suite_67, c3_.lastname AS lastname_68, c3_.firstname AS firstname_69, c3_.idtypestructure AS idtypestructure_70, c3_.license AS license_71, c3_.comment AS comment_72, c3_.private_comment AS private_comment_73, c3_.address1 AS address1_74, c3_.address2 AS address2_75, c3_.zip AS zip_76, c3_.city AS city_77, c3_.phone1 AS phone1_78, c3_.phone2 AS phone2_79, c3_.fax AS fax_80, c3_.email1 AS email1_81, c3_.email1_online AS email1_online_82, c3_.email2_online AS email2_online_83, c3_.email2 AS email2_84, c3_.url AS url_85, c3_.url_ticket AS url_ticket_86, c3_.facebook AS facebook_87, c3_.twitter AS twitter_88, c3_.instagram AS instagram_89, c3_.mobile AS mobile_90, c3_.geocodable AS geocodable_91, c3_.x AS x_92, c3_.y AS y_93, c3_.idmultimedia AS idmultimedia_94, c3_.type_view AS type_view_95, c3_.stats_access AS stats_access_96, c3_.ga_tracking_id AS ga_tracking_id_97, c3_.is_festival AS is_festival_98, c3_.link_on_video AS link_on_video_99, c3_.is_partenaire AS is_partenaire_100, c3_.valid_version AS valid_version_101, c3_.other_versions AS other_versions_102, c3_.url_redirect AS url_redirect_103, c3_.url_clean AS url_clean_104, c3_.dateupdate AS dateupdate_105, c3_.dateinsert AS dateinsert_106, c3_.publish AS publish_107, c3_.valid AS valid_108, e4_.idextranetuser AS idextranetuser_109 FROM spectacles s0_ LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser WHERE s0_.idspectacle = '34838';

SELECT
  t.title
FROM
  texts t,
  text_spectacle ts
WHERE
  t.idtext = ts.idtext
  AND ts.idspectacle = 34838

SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=34838;

SELECT
  lt.fr
FROM
  typesspectacles e,
  langterms lt
WHERE
  typespectacle = lt.id
  AND idtypespectacle = 4

SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4;

SELECT
  p.`idperson` as id,
  p.`idperson` as idperson,
  p.`lastname`,
  p.`firstname`,
  p.`url_clean`,
  p.`valid`,
  lt.`fr`,
  r.`idrole`,
  r.`role`,
  r.`type`,
  sp.`comment`,
  sp.`date_start`,
  sp.`date_end`
FROM
  persons p
  JOIN spectacle_person sp ON sp.`idperson` = p.`idperson`
  JOIN roles r ON r.`idrole` = sp.`idrole`
  JOIN langterms lt ON r.`role` = lt.`id`
WHERE
  sp.idspectacle = 34838
  AND r.type_creator = 1
ORDER BY
  sp.`classement`

SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
                        lt.`fr`,
                        r.`idrole`, r.`role`, r.`type`,
                        sp.`comment`,sp.`date_start`,sp.`date_end`
                        FROM persons p
                            JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
                            JOIN roles r ON r.`idrole`=sp.`idrole`
                            JOIN langterms lt ON r.`role`=lt.`id`
                        WHERE sp.idspectacle=34838  AND r.type_creator=1 ORDER BY sp.`classement` ;

SELECT
  p.`idperson` as id,
  p.`idperson` as idperson,
  p.`lastname`,
  p.`firstname`,
  p.`url_clean`,
  p.`valid`,
  lt.`fr`,
  r.`idrole`,
  r.`role`,
  r.`type`,
  sp.`comment`,
  sp.`date_start`,
  sp.`date_end`
FROM
  persons p
  JOIN spectacle_person sp ON sp.`idperson` = p.`idperson`
  JOIN roles r ON r.`idrole` = sp.`idrole`
  JOIN langterms lt ON r.`role` = lt.`id`
WHERE
  sp.idspectacle = 34838
  AND r.type_creator = 1
ORDER BY
  sp.`classement`

SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
                        lt.`fr`,
                        r.`idrole`, r.`role`, r.`type`,
                        sp.`comment`,sp.`date_start`,sp.`date_end`
                        FROM persons p
                            JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
                            JOIN roles r ON r.`idrole`=sp.`idrole`
                            JOIN langterms lt ON r.`role`=lt.`id`
                        WHERE sp.idspectacle=34838  AND r.type_creator=1 ORDER BY sp.`classement` ;

SELECT
  t.idtext,
  t.title,
  t.type,
  t.url_clean,
  t.textfictif
FROM
  texts t,
  text_spectacle ts
WHERE
  1
  AND ts.idspectacle = 34838
  AND t.idtext = ts.idtext

SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=34838
                AND t.idtext=ts.idtext;

SELECT
  DISTINCT(cl.type)
FROM
  classifications cl
WHERE
  (
    (
      cl.classification IN ('class_affiche_spec')
    )
  )
  AND spectacles = 1

SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_affiche_spec'))) AND spectacles=1;

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 = '34838'
  AND of.object = 'spectacles'
  AND cl.idclassification = fc.idclassification
  AND (
    (
      cl.classification IN ('class_affiche_spec')
    )
  )
  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='34838'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_affiche_spec'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  COUNT(
    DISTINCT(podcasts.idpodcast)
  ) as total,
  podcasts.*
FROM
  `podcast_spectacle`,
  `podcasts`
WHERE
  1
  AND podcasts.`publish` = 1
  AND podcast_spectacle.`idspectacle` = 34838
  AND (
    `podcasts`.`code_franceinter` IS NOT NULL
  )
  AND (
    `podcasts`.`type_diffusion` IS NULL
    OR `podcasts`.`type_diffusion` = 0
  )
  AND (
    podcasts.type_franceinter is NULL
    OR podcasts.type_franceinter = 0
  )
  AND podcasts.`idpodcast` = podcast_spectacle.`idpodcast`
LIMIT
  0, 200

SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_spectacle` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_spectacle.`idspectacle`=34838  AND ( `podcasts`.`code_franceinter` IS NOT NULL ) AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND (podcasts.type_franceinter is NULL OR podcasts.type_franceinter = 0) AND podcasts.`idpodcast`=podcast_spectacle.`idpodcast` 
LIMIT 0,200;

SELECT
  COUNT(
    DISTINCT(podcasts.idpodcast)
  ) as total,
  podcasts.*
FROM
  `podcast_spectacle`,
  `podcasts`
WHERE
  1
  AND podcasts.`publish` = 1
  AND podcast_spectacle.`idspectacle` = 34838
  AND (
    `podcasts`.`code_franceinter` IS NOT NULL
  )
  AND (
    `podcasts`.`type_diffusion` IS NULL
    OR `podcasts`.`type_diffusion` = 0
  )
  AND podcasts.`type_franceinter` = 1
  AND podcasts.`idpodcast` = podcast_spectacle.`idpodcast`
LIMIT
  0, 200

SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_spectacle` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_spectacle.`idspectacle`=34838  AND ( `podcasts`.`code_franceinter` IS NOT NULL ) AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0)  AND podcasts.`type_franceinter`=1 AND podcasts.`idpodcast`=podcast_spectacle.`idpodcast` 
LIMIT 0,200;

SELECT
  COUNT(
    DISTINCT(podcasts.idpodcast)
  ) as total,
  podcasts.*
FROM
  `podcast_spectacle`,
  `podcasts`
WHERE
  1
  AND podcasts.`publish` = 1
  AND podcast_spectacle.`idspectacle` = 34838
  AND podcasts.`code_soundcloud` IS NOT NULL
  AND (
    `podcasts`.`type_diffusion` IS NULL
    OR `podcasts`.`type_diffusion` = 0
  )
  AND podcasts.`idpodcast` = podcast_spectacle.`idpodcast`
LIMIT
  0, 200

SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_spectacle` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_spectacle.`idspectacle`=34838  AND podcasts.`code_soundcloud` IS NOT NULL AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_spectacle.`idpodcast` 
LIMIT 0,200;

SELECT
  DISTINCT(podcasts.idpodcast),
  podcasts.*
FROM
  `podcast_spectacle`,
  `podcasts`
WHERE
  1
  AND podcasts.`publish` = 1
  AND podcast_spectacle.`idspectacle` = 34838
  AND (
    `podcasts`.`code_franceinter` IS NOT NULL
    OR `podcasts`.`code_soundcloud` IS NOT NULL
  )
  AND (
    `podcasts`.`type_diffusion` IS NULL
    OR `podcasts`.`type_diffusion` = 0
  )
  AND podcasts.`idpodcast` = podcast_spectacle.`idpodcast`
GROUP BY
  podcasts.idpodcast
ORDER BY
  podcasts.`date_podcast` DESC
LIMIT
  0, 200

SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_spectacle` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_spectacle.`idspectacle`=34838  AND ( `podcasts`.`code_franceinter` IS NOT NULL  OR `podcasts`.`code_soundcloud` IS NOT NULL ) AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_spectacle.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,200;

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 = '4720';

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 = 4720

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=4720;

SELECT
  t.title
FROM
  texts t,
  text_spectacle ts
WHERE
  t.idtext = ts.idtext
  AND ts.idspectacle = 34838

SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=34838;

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 = 4720

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=4720;

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 = 4720

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=4720;

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 = 4720

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=4720;

SELECT
  url_file
FROM
  podcasts
WHERE
  idpodcast = 4720

SELECT url_file FROM podcasts WHERE idpodcast=4720;

SELECT
  url_file
FROM
  podcasts
WHERE
  idpodcast = 4720

SELECT url_file FROM podcasts WHERE idpodcast=4720;

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 = '4710';