Symfony Profiler

SELECT
  DISTINCT s.`idspectacle`
FROM
  spectacles s
  LEFT JOIN spectacle_person sp ON sp.`idspectacle` = s.`idspectacle`
  LEFT JOIN text_spectacle ts ON ts.`idspectacle` = s.`idspectacle`
WHERE
  s.`publish` = 1
  AND s.`valid` = 1
  AND (
    sp.`idperson` = 1558
    OR ts.`idtext` IN (
      2180, 5233, 6618, 15401, 20669, 25633,
      28314, 34162, 40075
    )
  )

SELECT DISTINCT s.`idspectacle`
                               FROM spectacles s
                               LEFT JOIN spectacle_person sp ON sp.`idspectacle`=s.`idspectacle`
                               LEFT JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle`
                               WHERE s.`publish`=1 AND s.`valid`=1
                               AND (sp.`idperson`=1558 OR ts.`idtext` IN (2180,5233,6618,15401,20669,25633,28314,34162,40075 ) );

SELECT
  DISTINCT s.`idspectacle`
FROM
  spectacles s
  LEFT JOIN spectacle_person sp ON sp.`idspectacle` = s.`idspectacle`
  LEFT JOIN text_spectacle ts ON ts.`idspectacle` = s.`idspectacle`
WHERE
  s.`publish` = 1
  AND s.`valid` = 1
  AND (
    sp.`idperson` = 75215
    OR ts.`idtext` IN (29593, 41198)
  )

SELECT DISTINCT s.`idspectacle`
                               FROM spectacles s
                               LEFT JOIN spectacle_person sp ON sp.`idspectacle`=s.`idspectacle`
                               LEFT JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle`
                               WHERE s.`publish`=1 AND s.`valid`=1
                               AND (sp.`idperson`=75215 OR ts.`idtext` IN (29593,41198 ) );

SELECT
  COUNT(
    DISTINCT(ct.`idcontent`)
  )
FROM
  spectacles s
  JOIN object_content oc ON s.`idspectacle` = oc.`idobject`
  JOIN contents ct ON oc.`idcontent` = ct.`idcontent`
  JOIN content_classification cc ON ct.`idcontent` = cc.`idcontent`
WHERE
  s.`publish` = 1
  AND s.`valid` = 1
  AND ct.`publish` = 1
  AND ct.`valid` = 1
  AND cc.`idclassification` = 101
  AND s.`idspectacle` IN (
    915, 1960, 1980, 2183, 3291, 3340, 3740,
    4072, 5099, 5123, 5204, 5205, 5206,
    5333, 5334, 5618, 5629, 6068, 6251,
    6307, 6506, 6735, 7673, 8245, 8542,
    8845, 11291, 11574, 11803, 12132, 12961,
    14387, 15056, 15239, 15307, 15328,
    17529, 17907, 18426, 19816, 19817,
    20130, 20190, 20220, 20858, 21070,
    21353, 21868, 21879, 21892, 23500,
    23818, 23869, 23871, 26349, 26489,
    26833, 26900, 29364, 29774, 29851,
    33054, 33702, 34294, 34748, 35477,
    36635, 36806
  )

SELECT COUNT(DISTINCT(ct.`idcontent`))
                    FROM spectacles s
                    JOIN object_content oc ON s.`idspectacle`=oc.`idobject`
                    JOIN contents ct ON oc.`idcontent`=ct.`idcontent`
                    JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent`
                    WHERE s.`publish`=1 AND s.`valid`=1
                    AND ct.`publish`=1 AND ct.`valid`=1
                    AND cc.`idclassification`=101
                    AND s.`idspectacle` IN (915,1960,1980,2183,3291,3340,3740,4072,5099,5123,5204,5205,5206,5333,5334,5618,5629,6068,6251,6307,6506,6735,7673,8245,8542,8845,11291,11574,11803,12132,12961,14387,15056,15239,15307,15328,17529,17907,18426,19816,19817,20130,20190,20220,20858,21070,21353,21868,21879,21892,23500,23818,23869,23871,26349,26489,26833,26900,29364,29774,29851,33054,33702,34294,34748,35477,36635,36806) ;

SELECT
  COUNT(
    DISTINCT(ct.`idcontent`)
  )
FROM
  spectacles s
  JOIN object_content oc ON s.`idspectacle` = oc.`idobject`
  JOIN contents ct ON oc.`idcontent` = ct.`idcontent`
  JOIN content_classification cc ON ct.`idcontent` = cc.`idcontent`
WHERE
  s.`publish` = 1
  AND s.`valid` = 1
  AND ct.`publish` = 1
  AND ct.`valid` = 1
  AND cc.`idclassification` = 101
  AND s.`idspectacle` IN (
    726, 1714, 3011, 3092, 3785, 4661, 5342,
    11798, 15089, 16376, 20472, 22738,
    23911, 26357, 27543, 32170, 33054,
    36136
  )

SELECT COUNT(DISTINCT(ct.`idcontent`))
                    FROM spectacles s
                    JOIN object_content oc ON s.`idspectacle`=oc.`idobject`
                    JOIN contents ct ON oc.`idcontent`=ct.`idcontent`
                    JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent`
                    WHERE s.`publish`=1 AND s.`valid`=1
                    AND ct.`publish`=1 AND ct.`valid`=1
                    AND cc.`idclassification`=101
                    AND s.`idspectacle` IN (726,1714,3011,3092,3785,4661,5342,11798,15089,16376,20472,22738,23911,26357,27543,32170,33054,36136) ;

SELECT
  DISTINCT(T1.`idtext`),
  T1.`title`,
  T1.`url_clean`,
  T1.`publication_year`,
  T1.`publication_month`,
  T1.`isbn`,
  T1.`textfictif`,
  T1.`dateinsert`,
  T1.`textorder`,
  T1.`type`,
  T1.`publish`,
  T1.`statut`,
  T1.`valid`,
  T2.`idcontact`,
  T2.`url_clean` as `url_clean_publisher`,
  T2.`organisation`,
  CONCAT(
    T1.`publication_year`, T1.`publication_month`
  ) AS publication_date,
  CAST(
    CONCAT(
      T1.`publication_year`, T1.`publication_month`
    ) AS DATE
  ) AS publication_date_full
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`,
  object_content oc2,
  contents c2,
  content_classification cc2
WHERE
  1
  AND oc2.idcontent = c2.idcontent
  AND cc2.idcontent = c2.idcontent
  AND oc2.idobject = T1.idtext
  AND cc2.idclassification IN (125)
  AND oc2.object = 'texts'
  AND T1.`idtext` IN (
    2180, 5233, 6618, 15401, 20669, 25633,
    28314, 34162, 40075
  )
GROUP BY
  T1.idtext
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC
LIMIT
  0, 10

SELECT DISTINCT(T1.`idtext`), T1.`title`,T1.`url_clean`,T1.`publication_year`,T1.`publication_month`,T1.`isbn`,T1.`textfictif`,T1.`dateinsert`,T1.`textorder`,T1.`type`,T1.`publish`,T1.`statut`,T1.`valid`,T2.`idcontact`,T2.`url_clean` as `url_clean_publisher`,T2.`organisation`,
                        CONCAT(T1.`publication_year`, T1.`publication_month`) AS publication_date,
                        CAST(CONCAT(T1.`publication_year`, T1.`publication_month`) AS DATE) AS publication_date_full  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  ,object_content oc2, contents c2, content_classification cc2  WHERE 1  AND oc2.idcontent=c2.idcontent
                            AND cc2.idcontent=c2.idcontent
                            AND oc2.idobject=T1.idtext
                            AND cc2.idclassification IN (125)
                            AND oc2.object='texts'  AND T1.`idtext` IN (2180,5233,6618,15401,20669,25633,28314,34162,40075)  GROUP BY T1.idtext  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC LIMIT 0,10;

INSERT INTO stats (
  type, module, url, md5url, idcontent,
  object, idobject, video, lng, remote_addr,
  source
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES ('article', 'thnet', '/spectacles/Singulis-et-Simul/biographies/', '1422ff3303fb4adff687d25bc3c1cacb', 0, 'spectacles', 33054, 0, 'fr', '3b4df75563e5b8e881389b80fb8d69b7-38c8', '/home/web/theatre-contemporain.net/dev/src/Controller/SpectacleController.php:518');

SELECT
  COUNT(
    DISTINCT(ct.`idcontent`)
  )
FROM
  spectacles s
  JOIN object_content oc ON s.`idspectacle` = oc.`idobject`
  JOIN contents ct ON oc.`idcontent` = ct.`idcontent`
  JOIN content_classification cc ON ct.`idcontent` = cc.`idcontent`
WHERE
  s.`publish` = 1
  AND s.`valid` = 1
  AND ct.`publish` = 1
  AND ct.`valid` = 1
  AND cc.`idclassification` = 101
  AND s.`idspectacle` IN (
    3855, 4351, 4759, 4919, 5321, 6056, 6154,
    6225, 6494, 6499, 6940, 8899, 9858,
    9993, 11819, 13161, 15014, 16693, 21068,
    24020, 26627, 29343, 30021, 31165,
    33054, 33674, 36297
  )

SELECT COUNT(DISTINCT(ct.`idcontent`))
                    FROM spectacles s
                    JOIN object_content oc ON s.`idspectacle`=oc.`idobject`
                    JOIN contents ct ON oc.`idcontent`=ct.`idcontent`
                    JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent`
                    WHERE s.`publish`=1 AND s.`valid`=1
                    AND ct.`publish`=1 AND ct.`valid`=1
                    AND cc.`idclassification`=101
                    AND s.`idspectacle` IN (3855,4351,4759,4919,5321,6056,6154,6225,6494,6499,6940,8899,9858,9993,11819,13161,15014,16693,21068,24020,26627,29343,30021,31165,33054,33674,36297) ;

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;

SELECT
  COUNT(
    DISTINCT(text_aide.idtextaide)
  ) as total,
  text_aide.*,
  aides.*,
  `text_aide`.`publish` as text_aide_publish
FROM
  `aides`,
  `text_aide`
WHERE
  1
  AND aides.`publish` = 1
  AND aides.`type_aide` IN (2, 3, 1, 4)
  AND text_aide.`idtext` IN ('')
  AND aides.`idaide` = text_aide.`idaide`

SELECT  COUNT(DISTINCT(text_aide.idtextaide)) as total , text_aide.*,aides.*,`text_aide`.`publish` as text_aide_publish 
FROM  `aides` ,
 `text_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`type_aide` IN (2,3,1,4)  AND text_aide.`idtext` IN ('') AND aides.`idaide`=text_aide.`idaide` 
;

SELECT
  idclassification,
  classification,
  public_name
FROM
  classifications
WHERE
  1
  AND type = "files"
  AND persons = 1
  AND lagarce != 1
  AND is_public IN (1)

SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND persons=1 AND lagarce!=1 AND is_public IN (1) ;

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

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

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 = '75215'
  AND of.object = 'persons'
  AND cl.idclassification = fc.idclassification
  AND f.publish = 1
  AND (
    (
      cl.classification IN ('class_photo_person')
    )
  )
  AND f.idtype = tf.idtype
ORDER BY
  f.`range`,
  f.idfile

SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='75215'
                   AND of.object='persons'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  DISTINCT(T1.`idtext`),
  T1.`title`,
  T1.`url_clean`,
  T1.`publication_year`,
  T1.`publication_month`,
  T1.`isbn`,
  T1.`textfictif`,
  T1.`dateinsert`,
  T1.`textorder`,
  T1.`type`,
  T1.`publish`,
  T1.`statut`,
  T1.`valid`,
  T2.`idcontact`,
  T2.`url_clean` as `url_clean_publisher`,
  T2.`organisation`,
  CONCAT(
    T1.`publication_year`, T1.`publication_month`
  ) AS publication_date,
  CAST(
    CONCAT(
      T1.`publication_year`, T1.`publication_month`
    ) AS DATE
  ) AS publication_date_full
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`,
  object_content oc2,
  contents c2,
  content_classification cc2
WHERE
  1
  AND oc2.idcontent = c2.idcontent
  AND cc2.idcontent = c2.idcontent
  AND oc2.idobject = T1.idtext
  AND cc2.idclassification IN (125)
  AND oc2.object = 'texts'
  AND T1.`idtext` IN (29593, 41198)
GROUP BY
  T1.idtext
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC
LIMIT
  0, 10

SELECT DISTINCT(T1.`idtext`), T1.`title`,T1.`url_clean`,T1.`publication_year`,T1.`publication_month`,T1.`isbn`,T1.`textfictif`,T1.`dateinsert`,T1.`textorder`,T1.`type`,T1.`publish`,T1.`statut`,T1.`valid`,T2.`idcontact`,T2.`url_clean` as `url_clean_publisher`,T2.`organisation`,
                        CONCAT(T1.`publication_year`, T1.`publication_month`) AS publication_date,
                        CAST(CONCAT(T1.`publication_year`, T1.`publication_month`) AS DATE) AS publication_date_full  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  ,object_content oc2, contents c2, content_classification cc2  WHERE 1  AND oc2.idcontent=c2.idcontent
                            AND cc2.idcontent=c2.idcontent
                            AND oc2.idobject=T1.idtext
                            AND cc2.idclassification IN (125)
                            AND oc2.object='texts'  AND T1.`idtext` IN (29593,41198)  GROUP BY T1.idtext  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC LIMIT 0,10;

SELECT
  COUNT(
    DISTINCT(playlists.idplaylist)
  ) as total,
  playlists.*
FROM
  `playlist_classification`,
  `playlists`
WHERE
  1
  AND playlists.`publish` = 1
  AND playlists.`idtext` IN (33054)
  AND playlist_classification.`idclassification` = 144
  AND playlists.`idplaylist` = playlist_classification.`idplaylist`

SELECT  COUNT(DISTINCT(playlists.idplaylist)) as total , playlists.* 
FROM  `playlist_classification` ,
 `playlists`  
 WHERE 1  AND playlists.`publish`=1  AND playlists.`idtext` IN (33054)  AND playlist_classification.`idclassification`=144 AND playlists.`idplaylist`=playlist_classification.`idplaylist` 
;

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 = '33054'
  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='33054'
                   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(ct.`idcontent`)
  )
FROM
  spectacles s
  JOIN object_content oc ON s.`idspectacle` = oc.`idobject`
  JOIN contents ct ON oc.`idcontent` = ct.`idcontent`
  JOIN content_classification cc ON ct.`idcontent` = cc.`idcontent`
WHERE
  s.`publish` = 1
  AND s.`valid` = 1
  AND ct.`publish` = 1
  AND ct.`valid` = 1
  AND cc.`idclassification` = 101
  AND s.`idspectacle` IN (
    4034, 5099, 5385, 6251, 9612, 11574,
    21440, 23818, 26900, 28614, 32502,
    33054, 34748, 36635
  )

SELECT COUNT(DISTINCT(ct.`idcontent`))
                    FROM spectacles s
                    JOIN object_content oc ON s.`idspectacle`=oc.`idobject`
                    JOIN contents ct ON oc.`idcontent`=ct.`idcontent`
                    JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent`
                    WHERE s.`publish`=1 AND s.`valid`=1
                    AND ct.`publish`=1 AND ct.`valid`=1
                    AND cc.`idclassification`=101
                    AND s.`idspectacle` IN (4034,5099,5385,6251,9612,11574,21440,23818,26900,28614,32502,33054,34748,36635) ;

SELECT
  COUNT(
    DISTINCT(ct.`idcontent`)
  )
FROM
  spectacles s
  JOIN object_content oc ON s.`idspectacle` = oc.`idobject`
  JOIN contents ct ON oc.`idcontent` = ct.`idcontent`
  JOIN content_classification cc ON ct.`idcontent` = cc.`idcontent`
WHERE
  s.`publish` = 1
  AND s.`valid` = 1
  AND ct.`publish` = 1
  AND ct.`valid` = 1
  AND cc.`idclassification` = 101
  AND s.`idspectacle` IN (33054)

SELECT COUNT(DISTINCT(ct.`idcontent`))
                    FROM spectacles s
                    JOIN object_content oc ON s.`idspectacle`=oc.`idobject`
                    JOIN contents ct ON oc.`idcontent`=ct.`idcontent`
                    JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent`
                    WHERE s.`publish`=1 AND s.`valid`=1
                    AND ct.`publish`=1 AND ct.`valid`=1
                    AND cc.`idclassification`=101
                    AND s.`idspectacle` IN (33054) ;

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 = '101267'
  AND of.object = 'persons'
  AND cl.idclassification = fc.idclassification
  AND f.publish = 1
  AND (
    (
      cl.classification IN ('class_photo_person')
    )
  )
  AND f.idtype = tf.idtype
ORDER BY
  f.`range`,
  f.idfile

SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='101267'
                   AND of.object='persons'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  *
FROM
  object_file of,
  files f,
  file_classification fc,
  classifications cl,
  typesfiles tf
WHERE
  of.idfile = f.idfile
  AND f.idfile = fc.idfile
  AND of.idobject = '101260'
  AND of.object = 'persons'
  AND cl.idclassification = fc.idclassification
  AND f.publish = 1
  AND (
    (
      cl.classification IN ('class_photo_person')
    )
  )
  AND f.idtype = tf.idtype
ORDER BY
  f.`range`,
  f.idfile

SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='101260'
                   AND of.object='persons'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  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 = ?