Symfony Profiler

SELECT
  idperson
FROM
  persons
WHERE
  url_clean = 'WALSER-Robert'

SELECT idperson FROM persons WHERE url_clean='WALSER-Robert' ;

SELECT
  p0_.idperson AS idperson_0,
  p0_.lastname AS lastname_1,
  p0_.firstname AS firstname_2,
  p0_.sexe AS sexe_3,
  p0_.datestart AS datestart_4,
  p0_.dateend AS dateend_5,
  p0_.language AS language_6,
  p0_.language2 AS language2_7,
  p0_.email AS email_8,
  p0_.comment AS comment_9,
  p0_.cname AS cname_10,
  p0_.caddress AS caddress_11,
  p0_.czip AS czip_12,
  p0_.ccity AS ccity_13,
  p0_.ccountry AS ccountry_14,
  p0_.cphone AS cphone_15,
  p0_.cfax AS cfax_16,
  p0_.cemail AS cemail_17,
  p0_.cmobile AS cmobile_18,
  p0_.url_redirect AS url_redirect_19,
  p0_.url_clean AS url_clean_20,
  p0_.url_mav AS url_mav_21,
  p0_.dateupdate AS dateupdate_22,
  p0_.dateinsert AS dateinsert_23,
  p0_.publish AS publish_24,
  p0_.valid AS valid_25,
  p0_.idcorvin AS idcorvin_26,
  p0_.country AS country_27,
  p0_.idrole AS idrole_28,
  p0_.idextranetuser AS idextranetuser_29
FROM
  persons p0_
WHERE
  p0_.idperson = ?

SELECT p0_.idperson AS idperson_0, p0_.lastname AS lastname_1, p0_.firstname AS firstname_2, p0_.sexe AS sexe_3, p0_.datestart AS datestart_4, p0_.dateend AS dateend_5, p0_.language AS language_6, p0_.language2 AS language2_7, p0_.email AS email_8, p0_.comment AS comment_9, p0_.cname AS cname_10, p0_.caddress AS caddress_11, p0_.czip AS czip_12, p0_.ccity AS ccity_13, p0_.ccountry AS ccountry_14, p0_.cphone AS cphone_15, p0_.cfax AS cfax_16, p0_.cemail AS cemail_17, p0_.cmobile AS cmobile_18, p0_.url_redirect AS url_redirect_19, p0_.url_clean AS url_clean_20, p0_.url_mav AS url_mav_21, p0_.dateupdate AS dateupdate_22, p0_.dateinsert AS dateinsert_23, p0_.publish AS publish_24, p0_.valid AS valid_25, p0_.idcorvin AS idcorvin_26, p0_.country AS country_27, p0_.idrole AS idrole_28, p0_.idextranetuser AS idextranetuser_29 FROM persons p0_ WHERE p0_.idperson = 11434;

SELECT
  COUNT(
    DISTINCT(t.idtext)
  )
FROM
  text_author ta,
  texts t
WHERE
  t.idtext = ta.idtext
  AND t.textfictif = 0
  AND ta.idperson = 11434
  AND t.publish = 1
  AND t.type IN (0, 2)

SELECT COUNT(DISTINCT(t.idtext))
                FROM text_author ta, texts t
                WHERE t.idtext=ta.idtext AND t.textfictif=0
                AND ta.idperson=11434 AND t.publish=1 AND t.type IN (0,2) ;

SELECT
  COUNT(
    DISTINCT(tt.idtext)
  ) as total
FROM
  text_translator tt,
  texts t
WHERE
  1
  AND t.idtext = tt.idtext
  AND t.textfictif = 0
  AND tt.idperson = 11434
  AND t.publish = 1

SELECT COUNT(DISTINCT(tt.idtext)) as total
                FROM text_translator tt, texts t
                WHERE 1
                AND t.idtext=tt.idtext
                AND t.textfictif=0
                AND tt.idperson=11434 AND t.publish=1;

SELECT
  COUNT(
    DISTINCT(sp.idspectacle)
  ) as total
FROM
  spectacle_person sp,
  spectacles s
WHERE
  1
  AND sp.idspectacle = s.idspectacle
  AND sp.idperson = 11434
  AND sp.idrole = 1
  AND s.publish = 1

SELECT COUNT(DISTINCT(sp.idspectacle)) as total
                FROM spectacle_person sp, spectacles s
                WHERE 1
                AND sp.idspectacle=s.idspectacle
                AND sp.idperson=11434
                AND sp.idrole=1 AND s.publish=1;

SELECT
  fr
FROM
  countries
WHERE
  id = 'CH'

SELECT fr FROM countries WHERE id='CH';

SELECT
  fr
FROM
  languages
WHERE
  id = 'de'

SELECT fr FROM languages WHERE id='de';

SELECT
  j1.idcontact,
  j1.organisation,
  j1.url_clean,
  j2.idoffice,
  j2.date_start,
  j2.date_end,
  j3.idperson
FROM
  theatreok_dev.contacts j1,
  theatreok_dev.contact_person j2,
  theatreok_dev.persons j3
WHERE
  j3.idperson = j2.idperson
  AND j1.idcontact = j2.idcontact
  AND j3.idperson = 11434
  AND j2.idoffice = 1

SELECT j1.idcontact,j1.organisation,j1.url_clean,j2.idoffice,j2.date_start,j2.date_end ,j3.idperson FROM theatreok_dev.contacts j1, theatreok_dev.contact_person j2, theatreok_dev.persons j3
                        WHERE j3.idperson=j2.idperson
                        AND j1.idcontact=j2.idcontact
                        AND j3.idperson=11434  AND j2.idoffice=1;

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

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

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 = '11434'
  AND oc.object = 'persons'
  AND cl.idclassification = cc.idclassification
  AND c.publish = 1
  AND (
    (
      cl.classification IN ('class_biotxt')
    )
  )
ORDER BY
  c.`range`,
  c.idcontent

SELECT *
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='11434'
                   AND oc.object='persons'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_biotxt'))) ORDER BY c.`range`,c.idcontent;

SELECT
  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 = '11434'
  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='11434'
                   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
  t.`idtext`
FROM
  text_author ta
  JOIN texts t ON ta.`idtext` = t.`idtext`
WHERE
  ta.`idperson` IN (11434)

SELECT t.`idtext`
                           FROM text_author ta
                           JOIN texts t ON ta.`idtext`=t.`idtext`
                           WHERE ta.`idperson` IN (11434) ;

SELECT
  tad.`idtextadaptation`
FROM
  text_adaptation tad
  JOIN texts t ON t.`idtext` = tad.`idtext`
  JOIN text_author ta ON t.`idtext` = ta.`idtext`
WHERE
  ta.`idperson` IN (11434)

SELECT tad.`idtextadaptation`
                               FROM text_adaptation tad
                               JOIN texts t ON t.`idtext`=tad.`idtext`
                               JOIN text_author ta ON t.`idtext`=ta.`idtext`
                               WHERE ta.`idperson` IN (11434) ;

SELECT
  t.`idtext`
FROM
  text_translator tt
  JOIN texts t ON tt.`idtext` = t.`idtext`
WHERE
  tt.`idperson` IN (11434)

SELECT t.`idtext`
                               FROM text_translator tt
                               JOIN texts t ON tt.`idtext`=t.`idtext`
                               WHERE
                               tt.`idperson` IN (11434) ;

SELECT
  tt.`idtexttraduction`
FROM
  text_traduction tt
  JOIN text_author ta ON tt.`idtext` = ta.`idtext`
  JOIN texts t ON tt.`idtext` = t.`idtext`
WHERE
  ta.`idperson` IN (11434)

SELECT tt.`idtexttraduction`
                                FROM text_traduction tt
                                JOIN text_author ta ON tt.`idtext`=ta.`idtext`
                                JOIN texts t ON tt.`idtext`=t.`idtext`
                                WHERE ta.`idperson` IN (11434) ;

SELECT
  s.`idspectacle`
FROM
  spectacles s
  LEFT JOIN spectacle_person sp ON sp.`idspectacle` = s.`idspectacle`
  LEFT JOIN text_spectacle ts ON ts.`idspectacle` = s.`idspectacle`
WHERE
  s.`publish` = 1
  AND s.`valid` = 1
  AND (
    sp.`idperson` = 11434
    OR ts.`idtext` IN (
      4783, 9150, 9258, 10250, 15784, 15820,
      15821, 15822, 20781, 22913, 24020,
      45052, 45258, 4784, 21998, 33266, 9262,
      32025, 10251, 21092, 15823, 15823,
      15823, 15823, 20782, 44296, 9151, 24021,
      45110, 45259
    )
  )

SELECT s.`idspectacle`
                               FROM spectacles s
                               LEFT JOIN spectacle_person sp ON sp.`idspectacle`=s.`idspectacle`
                               LEFT JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle`
                               WHERE s.`publish`=1 AND s.`valid`=1
                               AND (sp.`idperson`=11434 OR ts.`idtext` IN (4783,9150,9258,10250,15784,15820,15821,15822,20781,22913,24020,45052,45258,4784,21998,33266,9262,32025,10251,21092,15823,15823,15823,15823,20782,44296,9151,24021,45110,45259) );

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 (
    3631, 6204, 6308, 12068, 16516, 16791,
    17620, 18242, 25738, 26700, 34908,
    35953
  )

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 (3631,6204,6308,12068,16516,16791,17620,18242,25738,26700,34908,35953) ;

SELECT
  r.idrole,
  r.role,
  r.role_male,
  r.role_female,
  lg.fr
FROM
  spectacle_person sp
  JOIN roles r ON sp.idrole = r.idrole
  JOIN langterms lg ON lg.id = r.role
WHERE
  sp.idperson = 11434
GROUP BY
  r.idrole

SELECT r.idrole, r.role, r.role_male, r.role_female, lg.fr
                FROM
                    spectacle_person sp
                    JOIN roles r ON sp.idrole=r.idrole
                    JOIN langterms lg ON lg.id=r.role
                WHERE sp.idperson=11434
                GROUP BY r.idrole ;

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 t2_.idtext IN (
    4783, 9150, 9258, 10250, 15784, 15820,
    15821, 15822, 20781, 22913, 24020,
    45052, 45258, 4784, 21998, 33266, 9262,
    32025, 10251, 21092, 15823, 15823,
    15823, 15823, 20782, 44296, 9151, 24021,
    45110, 45259
  )
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 t2_.idtext IN (4783, 9150, 9258, 10250, 15784, 15820, 15821, 15822, 20781, 22913, 24020, 45052, 45258, 4784, 21998, 33266, 9262, 32025, 10251, 21092, 15823, 15823, 15823, 15823, 20782, 44296, 9151, 24021, 45110, 45259) ORDER BY s1_.date ASC;

SELECT
  schedules.`date`,
  YEAR(schedules.`date`) as annee
FROM
  schedules,
  spectacles
WHERE
  schedules.`idspectacle` = spectacles.`idspectacle`
  AND spectacles.`publish` = 1
  AND schedules.`idspectacle` IN (
    3631, 6204, 6308, 12068, 16516, 16791,
    17620, 18242, 25738, 26700, 34908,
    35953
  )
ORDER BY
  schedules.`date`

SELECT schedules.`date`, YEAR(schedules.`date`) as annee
            FROM schedules, spectacles
            WHERE schedules.`idspectacle`=spectacles.`idspectacle`
            AND spectacles.`publish`=1
            AND schedules.`idspectacle` IN (3631,6204,6308,12068,16516,16791,17620,18242,25738,26700,34908,35953)
            ORDER BY schedules.`date`;

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 s0_.idspectacle IN (
    3631, 6204, 6308, 12068, 16516, 16791,
    17620, 18242, 25738, 26700, 34908,
    35953
  )
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 WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s0_.idspectacle IN (3631, 6204, 6308, 12068, 16516, 16791, 17620, 18242, 25738, 26700, 34908, 35953) 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
WHERE
  s1_.idspectacle = s0_.idspectacle
  AND (
    s1_.idcontact = c7_.idcontact
    OR s1_.idcontact_festival = c7_.idcontact
  )
  AND s0_.idspectacle IN (
    3631, 6204, 6308, 12068, 16516, 16791,
    17620, 18242, 25738, 26700, 34908,
    35953
  )
  AND (
    (
      s1_.date BETWEEN '2024-04-18'
      AND '2026-04-08'
    )
  )
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 s0_.idspectacle IN (3631, 6204, 6308, 12068, 16516, 16791, 17620, 18242, 25738, 26700, 34908, 35953) AND ((s1_.date BETWEEN '2024-04-18' AND '2026-04-08')) ORDER BY s1_.date ASC;

SELECT
  DISTINCT MIN(s0_.date) AS sclr_0,
  t1_.url_clean AS url_clean_1,
  s2_.idspectacle AS idspectacle_2,
  s2_.title AS title_3,
  s2_.language AS language_4,
  s2_.creation_date AS creation_date_5,
  s2_.url_page AS url_page_6,
  s2_.infos AS infos_7,
  s2_.tag AS tag_8,
  s2_.id_rubrique AS id_rubrique_9,
  s2_.duration AS duration_10,
  s2_.interlude AS interlude_11,
  s2_.textfictif AS textfictif_12,
  s2_.url_redirect AS url_redirect_13,
  s2_.url_clean AS url_clean_14,
  s2_.dateupdate AS dateupdate_15,
  s2_.dateinsert AS dateinsert_16,
  s2_.publish AS publish_17,
  s2_.statut AS statut_18,
  s2_.valid AS valid_19,
  t1_.idtext AS idtext_20,
  t1_.type AS type_21,
  t1_.idtypetext AS idtypetext_22,
  t1_.special_text AS special_text_23,
  t1_.title AS title_24,
  t1_.subtitle AS subtitle_25,
  t1_.date AS date_26,
  t1_.language AS language_27,
  t1_.markdown AS markdown_28,
  t1_.abstract AS abstract_29,
  t1_.abstract_author AS abstract_author_30,
  t1_.abstract_date AS abstract_date_31,
  t1_.abstract_url AS abstract_url_32,
  t1_.publisher_url_text AS publisher_url_text_33,
  t1_.publication_year AS publication_year_34,
  t1_.publication_month AS publication_month_35,
  t1_.isbn AS isbn_36,
  t1_.ean AS ean_37,
  t1_.publishinfos AS publishinfos_38,
  t1_.urltextaccess AS urltextaccess_39,
  t1_.emailtextaccess AS emailtextaccess_40,
  t1_.idfiletextaccess AS idfiletextaccess_41,
  t1_.filetextaccesssave AS filetextaccesssave_42,
  t1_.textaccessmore AS textaccessmore_43,
  t1_.request_translation_text AS request_translation_text_44,
  t1_.request_performing_text AS request_performing_text_45,
  t1_.help_translation AS help_translation_46,
  t1_.help_publishing AS help_publishing_47,
  t1_.help_other AS help_other_48,
  t1_.moreinfo AS moreinfo_49,
  t1_.nmale AS nmale_50,
  t1_.nfemale AS nfemale_51,
  t1_.npeople AS npeople_52,
  t1_.textorder AS textorder_53,
  t1_.nbpages AS nbpages_54,
  t1_.price AS price_55,
  t1_.selection_aneth AS selection_aneth_56,
  t1_.idtext_aneth AS idtext_aneth_57,
  t1_.aide_creation AS aide_creation_58,
  t1_.comments AS comments_59,
  t1_.url_clean AS url_clean_60,
  t1_.textfictif AS textfictif_61,
  t1_.valid_opendata AS valid_opendata_62,
  t1_.dateupdate AS dateupdate_63,
  t1_.dateinsert AS dateinsert_64,
  t1_.publish AS publish_65,
  t1_.statut AS statut_66,
  t1_.valid AS valid_67,
  t3_.idtypespectacle AS idtypespectacle_68
FROM
  spectacles s2_
  LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle
  LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext
  LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle
  LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle
  LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle
  LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson
  INNER JOIN contacts c7_ ON s0_.idcontact = c7_.idcontact
WHERE
  s0_.idspectacle = s2_.idspectacle
  AND (
    s0_.idcontact = c7_.idcontact
    OR s0_.idcontact_festival = c7_.idcontact
  )
  AND s2_.idspectacle IN (
    3631, 6204, 6308, 12068, 16516, 16791,
    17620, 18242, 25738, 26700, 34908,
    35953
  )
GROUP BY
  s2_.idspectacle
ORDER BY
  sclr_0 DESC
LIMIT
  20