Symfony Profiler

SELECT
  idcontact
FROM
  contacts
WHERE
  url_clean = 'Les-Cygnes-Editions'

SELECT idcontact FROM contacts WHERE url_clean='Les-Cygnes-Editions' ;

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

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

SELECT
  fr
FROM
  countries
WHERE
  id = 'France'

SELECT fr FROM countries WHERE id='France';

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;

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 = '1797'
  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='1797'
                   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
  DISTINCT(cl.type)
FROM
  classifications cl
WHERE
  (
    (
      cl.classification IN ('class_pp')
    )
  )
  AND contacts = 1

SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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 = '1797'
  AND of.object = 'contacts'
  AND cl.idclassification = fc.idclassification
  AND (
    (
      cl.classification IN ('class_pp')
    )
  )
  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='1797'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  COUNT(
    DISTINCT(m.idmultimedia)
  )
FROM
  object_multimedia om,
  multimedias m
WHERE
  om.idmultimedia = m.idmultimedia
  AND om.idobject = 1797
  AND om.object = 'contacts'
  AND m.publish = 1
  AND m.audio_video = 2

SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=1797
                AND om.object='contacts'
                AND m.publish=1  AND m.audio_video=2;

SELECT
  COUNT(
    DISTINCT(T1.idperson)
  ) as total
FROM
  persons T1
  JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
  JOIN texts t ON t.`idtext` = T2.`idtext`
WHERE
  1
  AND t.`idcontact_publisher` IN ('1797')
  AND T1.`publish` = 1

SELECT COUNT(DISTINCT(T1.idperson)) as total  FROM persons T1 
                    JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
                    JOIN texts t ON t.`idtext`=T2.`idtext` 
                 WHERE 1  AND t.`idcontact_publisher` IN  ('1797')  AND T1.`publish`=1 ;

SELECT
  idtext,
  idgenretext
FROM
  texts
WHERE
  type = 0
  AND idcontact_publisher = 1797

SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=1797;

SELECT
  idtext
FROM
  texts
WHERE
  type = 1
  AND idcontact_publisher = 1797

SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=1797;

SELECT
  tt.idtext
FROM
  text_traduction tt,
  texts t
WHERE
  t.idtext = tt.idtext
  AND (
    t.idgenretext = 1
    OR t.idgenretext IS NULL
  )
  AND tt.idtexttraduction IN (4167, 16362, 17772, 35109)

SELECT tt.idtext FROM text_traduction tt, texts t
                                        WHERE t.idtext=tt.idtext
                                        AND (t.idgenretext=1 OR t.idgenretext IS NULL)
                                        AND tt.idtexttraduction IN (4167,16362,17772,35109);

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (
    4201,
    5996,
    6765,
    7594,
    7806,
    7899,
    8035,
    8036,
    8175,
    8975,
    11194,
    11691,
    12004,
    12089,
    12725,
    15061,
    15452,
    15456,
    15879,
    16514,
    16663,
    16762,
    16997,
    17019,
    17021,
    17022,
    17023,
    17024,
    17025,
    17026,
    17027,
    17028,
    17029,
    17030,
    17770,
    18385,
    18536,
    18579,
    18792,
    18972,
    19046,
    19450,
    19515,
    19659,
    19870,
    21004,
    21213,
    22061,
    22063,
    23451,
    24503,
    24566,
    24966,
    25860,
    26018,
    27180,
    27289,
    27760,
    27805,
    27939,
    28216,
    28970,
    28971,
    29242,
    29357,
    29692,
    29778,
    29940,
    30021,
    30934,
    31101,
    31228,
    31343,
    31344,
    31883,
    31885,
    32285,
    32286,
    32287,
    32646,
    33208,
    33209,
    33330,
    33877,
    34311,
    34315,
    34951,
    35018,
    35091,
    35093,
    35228,
    35231,
    35618,
    35619,
    36524,
    37285,
    37287,
    37288,
    37527,
    37624,
    37625,
    39204,
    39205,
    39210,
    39559,
    39607,
    39731,
    39732,
    39735,
    39843,
    39947,
    39978,
    40310,
    40350,
    40351,
    40620,
    40821,
    40944,
    41173,
    41463,
    41472,
    41570,
    41690,
    41774,
    41777,
    41870,
    42907,
    43486,
    43803,
    44679,
    44699
  )
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (4201,5996,6765,7594,7806,7899,8035,8036,8175,8975,11194,11691,12004,12089,12725,15061,15452,15456,15879,16514,16663,16762,16997,17019,17021,17022,17023,17024,17025,17026,17027,17028,17029,17030,17770,18385,18536,18579,18792,18972,19046,19450,19515,19659,19870,21004,21213,22061,22063,23451,24503,24566,24966,25860,26018,27180,27289,27760,27805,27939,28216,28970,28971,29242,29357,29692,29778,29940,30021,30934,31101,31228,31343,31344,31883,31885,32285,32286,32287,32646,33208,33209,33330,33877,34311,34315,34951,35018,35091,35093,35228,35231,35618,35619,36524,37285,37287,37288,37527,37624,37625,39204,39205,39210,39559,39607,39731,39732,39735,39843,39947,39978,40310,40350,40351,40620,40821,40944,41173,41463,41472,41570,41690,41774,41777,41870,42907,43486,43803,44679,44699)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (
    4201,
    5996,
    6765,
    7594,
    7806,
    7899,
    8035,
    8036,
    8175,
    8975,
    11194,
    11691,
    12004,
    12089,
    12725,
    15061,
    15452,
    15456,
    15879,
    16514,
    16663,
    16762,
    16997,
    17019,
    17021,
    17022,
    17023,
    17024,
    17025,
    17026,
    17027,
    17028,
    17029,
    17030,
    17770,
    18385,
    18536,
    18579,
    18792,
    18972,
    19046,
    19450,
    19515,
    19659,
    19870,
    21004,
    21213,
    22061,
    22063,
    23451,
    24503,
    24566,
    24966,
    25860,
    26018,
    27180,
    27289,
    27760,
    27805,
    27939,
    28216,
    28970,
    28971,
    29242,
    29357,
    29692,
    29778,
    29940,
    30021,
    30934,
    31101,
    31228,
    31343,
    31344,
    31883,
    31885,
    32285,
    32286,
    32287,
    32646,
    33208,
    33209,
    33330,
    33877,
    34311,
    34315,
    34951,
    35018,
    35091,
    35093,
    35228,
    35231,
    35618,
    35619,
    36524,
    37285,
    37287,
    37288,
    37527,
    37624,
    37625,
    39204,
    39205,
    39210,
    39559,
    39607,
    39731,
    39732,
    39735,
    39843,
    39947,
    39978,
    40310,
    40350,
    40351,
    40620,
    40821,
    40944,
    41173,
    41463,
    41472,
    41570,
    41690,
    41774,
    41777,
    41870,
    42907,
    43486,
    43803,
    44679,
    44699
  )
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (4201,5996,6765,7594,7806,7899,8035,8036,8175,8975,11194,11691,12004,12089,12725,15061,15452,15456,15879,16514,16663,16762,16997,17019,17021,17022,17023,17024,17025,17026,17027,17028,17029,17030,17770,18385,18536,18579,18792,18972,19046,19450,19515,19659,19870,21004,21213,22061,22063,23451,24503,24566,24966,25860,26018,27180,27289,27760,27805,27939,28216,28970,28971,29242,29357,29692,29778,29940,30021,30934,31101,31228,31343,31344,31883,31885,32285,32286,32287,32646,33208,33209,33330,33877,34311,34315,34951,35018,35091,35093,35228,35231,35618,35619,36524,37285,37287,37288,37527,37624,37625,39204,39205,39210,39559,39607,39731,39732,39735,39843,39947,39978,40310,40350,40351,40620,40821,40944,41173,41463,41472,41570,41690,41774,41777,41870,42907,43486,43803,44679,44699)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (4167, 16362, 17772, 35109)
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (4167,16362,17772,35109)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (4167, 16362, 17772, 35109)
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (4167,16362,17772,35109)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1,
  contacts T2
WHERE
  1
  AND T2.idcontact = T1.idcontact_publisher
  AND T1.idcontact_publisher = 1797
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1,contacts T2 WHERE 1  AND T2.idcontact=T1.idcontact_publisher AND T1.idcontact_publisher=1797  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

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 = 1797)
  AND T1.publish = 1
  AND T1.publish = 1
  AND T1.valid = 1
  AND (
    (T3.date >= '2024-04-26')
  )

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=1797 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND (( T3.date>='2024-04-26' ))    ;

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 = 1797)
  AND T1.publish = 1
  AND T1.publish = 1
  AND T1.valid = 1
  AND (
    (T3.date < '2024-04-26')
  )

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=1797 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND (( T3.date<'2024-04-26' ))    ;

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 BETWEEN '2024-04-26'
      AND '2025-04-26'
    )
  )
  AND (
    s0_.publish = 1
    AND s0_.valid = 1
  )
  AND t2_.idcontact_publisher = 1797
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 BETWEEN '2024-04-26' AND '2025-04-26')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 1797 ORDER BY s1_.date ASC;

SELECT
  COUNT(
    DISTINCT (s0_.idspectacle)
  ) AS sclr_0,
  MIN(s1_.date) AS sclr_1,
  o2_.idobject AS idobject_2,
  o2_.object AS object_3,
  o2_.`range` AS range_4,
  o2_.idcontent AS idcontent_5
FROM
  spectacles s0_
  LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle
  LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext
  LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle
  LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle
  LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle
  LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson
  INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact
  LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles')
  LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent)
  LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent
  LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification
WHERE
  s1_.idspectacle = s0_.idspectacle
  AND (
    s1_.idcontact = c8_.idcontact
    OR s1_.idcontact_festival = c8_.idcontact
  )
  AND (
    c9_.valid = 1
    AND c9_.publish = 1
  )
  AND c10_.idclassification IN (101)
  AND s0_.idspectacle = o2_.idobject
  AND c9_.idcontent = o2_.idcontent
  AND (
    s0_.publish = 1
    AND s0_.valid = 1
  )
  AND t3_.idcontact_publisher = 1797
ORDER BY
  s1_.date ASC