Symfony Profiler

SELECT
  *,
  `bigregions`.idbigregion as idbigregion
FROM
  `bigregions`
  JOIN `regions` ON `regions`.`idbigregion` = `bigregions`.`idbigregion`
  JOIN `departements` ON `regions`.`idregion` = `departements`.`idregion`
ORDER BY
  `bigregions`.`bigregion` ASC,
  `departements`.`departement` ASC

SELECT *,`bigregions`.idbigregion as idbigregion
                    FROM `bigregions`
                        JOIN `regions` ON `regions`.`idbigregion`=`bigregions`.`idbigregion`
                        JOIN `departements` ON `regions`.`idregion`=`departements`.`idregion`
                    ORDER BY `bigregions`.`bigregion` ASC, `departements`.`departement` ASC;

SELECT
  a.idannonce,
  a.dateinsert,
  a.sujet,
  c.url_clean,
  c.name,
  c.idcategorie
FROM
  ann_annonces a,
  ann_categories c
WHERE
  c.idcategorie = a.idcategorie
  AND a.online = 1
  AND a.valid = 1
  AND a.pays = 'FR'
  AND (
    SUBSTRING(a.cp, 1, 2) IN ('20', '2A', '2B')
  )
  AND c.idcategorie IN (3)
ORDER BY
  a.dateinsert DESC
LIMIT
  0, 3

SELECT a.idannonce,a.dateinsert,a.sujet,c.url_clean, c.name,c.idcategorie
                FROM ann_annonces a, ann_categories c
                WHERE c.idcategorie=a.idcategorie AND a.online=1 AND a.valid=1  AND  a.pays='FR' AND ( SUBSTRING(a.cp,1,2)  IN ('20','2A','2B')) AND c.idcategorie IN (3)  ORDER BY a.dateinsert DESC LIMIT 0,3;

SELECT
  a.idannonce,
  a.dateinsert,
  a.sujet,
  c.url_clean,
  c.name,
  c.idcategorie
FROM
  ann_annonces a,
  ann_categories c
WHERE
  c.idcategorie = a.idcategorie
  AND a.online = 1
  AND a.valid = 1
  AND a.pays = 'FR'
  AND (
    SUBSTRING(a.cp, 1, 2) IN ('20', '2A', '2B')
  )
  AND c.idcategorie IN (1)
ORDER BY
  a.dateinsert DESC
LIMIT
  0, 3

SELECT a.idannonce,a.dateinsert,a.sujet,c.url_clean, c.name,c.idcategorie
                FROM ann_annonces a, ann_categories c
                WHERE c.idcategorie=a.idcategorie AND a.online=1 AND a.valid=1  AND  a.pays='FR' AND ( SUBSTRING(a.cp,1,2)  IN ('20','2A','2B')) AND c.idcategorie IN (1)  ORDER BY a.dateinsert DESC LIMIT 0,3;

SELECT
  DISTINCT(contacts.idcontact),
  contacts.*
FROM
  `contacts`
WHERE
  1
  AND contacts.`idtypestructure` = 'EC'
  AND contacts.idcontact NOT IN (
    SELECT
      idcontact
    FROM
      contact_classification
    WHERE
      idclassification = 99
  )
  AND contacts.country = 'FR'
  AND (
    SUBSTRING(contacts.zip, 1, 2) IN ('20', '2A', '2B')
  )
  AND contacts.`publish` = 1
GROUP BY
  contacts.idcontact
ORDER BY
  organisation ASC
LIMIT
  0, 300

SELECT  DISTINCT(contacts.idcontact), contacts.* 
FROM  `contacts`  
 WHERE 1  AND contacts.`idtypestructure`='EC'  AND contacts.idcontact NOT IN (SELECT idcontact FROM contact_classification WHERE idclassification=99)   AND  contacts.country='FR' AND ( SUBSTRING(contacts.zip,1,2)  IN ('20','2A','2B'))   AND contacts.`publish`=1 
GROUP BY contacts.idcontact 
ORDER BY organisation 
ASC 
LIMIT 0,300;

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 (
    (
      s0_.date BETWEEN '2024-04-27'
      AND '2025-04-27'
    )
  )
  AND (
    s2_.publish = 1
    AND s2_.valid = 1
  )
  AND (
    c7_.country = 'FR'
    AND (
      SUBSTRING(
        c7_.zip
        FROM
          1 FOR 2
      ) IN ('20', '2A', '2B')
    )
  )
GROUP BY
  s2_.idspectacle
ORDER BY
  s0_.date ASC
LIMIT
  6

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 ((s0_.date BETWEEN '2024-04-27' AND '2025-04-27')) AND (s2_.publish = 1 AND s2_.valid = 1) AND (c7_.country = 'FR' AND (SUBSTRING(c7_.zip FROM 1 FOR 2) IN ('20', '2A', '2B'))) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 6;

SELECT
  ct.idcontact,
  ct.url_clean,
  ct.url,
  ct.organisation,
  ct.idtypestructure,
  cc.idclassification,
  cl.classification
FROM
  contacts ct
  JOIN contact_classification cc ON cc.idcontact = ct.idcontact
  JOIN classifications cl ON cl.idclassification = cc.idclassification
WHERE
  ct.publish = 1
  AND cc.idclassification IN (128, 129, 130, 131)
  AND ct.country = 'FR'
  AND (
    SUBSTRING(ct.zip, 1, 2) IN ('20', '2A', '2B')
  )
ORDER BY
  ct.idcontact

SELECT ct.idcontact,ct.url_clean, ct.url, ct.organisation, ct.idtypestructure, cc.idclassification, cl.classification
                        FROM contacts ct
                            JOIN contact_classification cc ON cc.idcontact=ct.idcontact
                            JOIN classifications cl ON cl.idclassification=cc.idclassification
                        WHERE ct.publish=1  AND cc.idclassification IN (128,129,130,131)  AND  ct.country='FR' AND ( SUBSTRING(ct.zip,1,2)  IN ('20','2A','2B'))  ORDER BY ct.idcontact;

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
  INNER JOIN spectacle_classification s9_ ON s2_.idspectacle = s9_.idspectacle
  INNER JOIN classifications c8_ ON c8_.idclassification = s9_.idclassification
WHERE
  s0_.idspectacle = s2_.idspectacle
  AND (
    s0_.idcontact = c7_.idcontact
    OR s0_.idcontact_festival = c7_.idcontact
  )
  AND c8_.idclassification = 103
  AND (
    (
      s0_.date BETWEEN '2024-04-27'
      AND '2025-04-27'
    )
  )
  AND (
    c7_.country = 'FR'
    AND (
      SUBSTRING(
        c7_.zip
        FROM
          1 FOR 2
      ) IN ('20', '2A', '2B')
    )
  )
GROUP BY
  s2_.idspectacle
ORDER BY
  s0_.date ASC
LIMIT
  20

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 INNER JOIN spectacle_classification s9_ ON s2_.idspectacle = s9_.idspectacle INNER JOIN classifications c8_ ON c8_.idclassification = s9_.idclassification WHERE s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND c8_.idclassification = 103 AND ((s0_.date BETWEEN '2024-04-27' AND '2025-04-27')) AND (c7_.country = 'FR' AND (SUBSTRING(c7_.zip FROM 1 FOR 2) IN ('20', '2A', '2B'))) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 20;

SELECT
  DISTINCT(T1.idperson),
  T1.lastname,
  T1.firstname,
  T1.url_clean
FROM
  persons T1
  JOIN object_file of ON T1.`idperson` = of.`idobject`
  JOIN files f ON of.`idfile` = f.`idfile`
  JOIN file_classification fc ON f.`idfile` = fc.`idfile`
  JOIN spectacle_author sa ON T1.`idperson` = sa.`idperson`
  JOIN spectacles s ON sa.`idspectacle` = s.`idspectacle`
  JOIN text_spectacle ts ON s.`idspectacle` = ts.`idspectacle`
  JOIN texts t ON t.`idtext` = ts.`idtext`
  JOIN schedules sc ON s.`idspectacle` = sc.`idspectacle`
  JOIN contacts ON sc.`idcontact` = contacts.`idcontact`
WHERE
  1
  AND contacts.country = 'FR'
  AND (
    SUBSTRING(contacts.zip, 1, 2) IN ('20', '2A', '2B')
  )
  AND fc.`idclassification` = 14
  AND s.`valid` = 1
  AND s.`publish` = 1
  AND s.`textfictif` = 0
  AND T1.`publish` = 1
  AND t.`type` IN (0, 1)
  AND sc.`date` BETWEEN '2024-04-27'
  AND '2025-04-27'
  AND (
    T1.`dateend` IS NULL
    OR T1.`dateend` = 0
    OR T1.`dateend` >= '1954'
  )
  AND contacts.`country` = 'FR'
GROUP BY
  T1.idperson
ORDER BY
  RAND()
LIMIT
  0, 4

SELECT DISTINCT(T1.idperson), T1.lastname,T1.firstname,T1.url_clean  FROM persons T1
                    JOIN object_file of ON T1.`idperson`=of.`idobject`
                    JOIN files f ON of.`idfile`=f.`idfile`
                    JOIN file_classification fc ON f.`idfile`=fc.`idfile` 
                            JOIN spectacle_author sa ON T1.`idperson`=sa.`idperson`
                            JOIN spectacles s ON sa.`idspectacle`=s.`idspectacle`
                            JOIN text_spectacle ts ON s.`idspectacle`=ts.`idspectacle`
                            JOIN texts t ON t.`idtext`=ts.`idtext` 
                    JOIN schedules sc ON s.`idspectacle`=sc.`idspectacle`  JOIN contacts ON sc.`idcontact`= contacts.`idcontact`  WHERE 1  AND  contacts.country='FR' AND ( SUBSTRING(contacts.zip,1,2)  IN ('20','2A','2B'))
                    AND fc.`idclassification`=14
            
                    AND s.`valid`=1
                    AND s.`publish`=1
                    AND s.`textfictif`=0
                    AND T1.`publish`=1  AND t.`type` IN (0,1)  AND sc.`date` BETWEEN '2024-04-27' AND '2025-04-27'  AND (T1.`dateend` IS NULL OR T1.`dateend` = 0 OR T1.`dateend`>='1954' )  AND contacts.`country`='FR'  GROUP BY T1.idperson  ORDER BY RAND()  LIMIT 0,4;

SELECT
  DISTINCT(multimedias.idmultimedia),
  multimedias.*,
  spectacles.`idspectacle`,
  schedules.`idcontact`
FROM
  `object_multimedia`,
  `schedules`,
  `spectacles`,
  `contacts`,
  `multimedias`
WHERE
  1
  AND contacts.country = 'FR'
  AND (
    SUBSTRING(contacts.zip, 1, 2) IN ('20', '2A', '2B')
  )
  AND multimedias.`publish` = 1
  AND object_multimedia.`object` = 'spectacles'
  AND object_multimedia.`idrole` IS NULL
  AND schedules.`date` BETWEEN '2024-04-27'
  AND '2025-04-27'
  AND multimedias.`idmultimedia` = object_multimedia.`idmultimedia`
  AND schedules.`idspectacle` = spectacles.`idspectacle`
  AND spectacles.`idspectacle` = object_multimedia.`idobject`
  AND contacts.`idcontact` = schedules.`idcontact`
GROUP BY
  object_multimedia.`idobject`
ORDER BY
  schedules.`date` ASC
LIMIT
  0, 5

SELECT  DISTINCT(multimedias.idmultimedia), multimedias.*,spectacles.`idspectacle`,schedules.`idcontact` 
FROM  `object_multimedia` ,
 `schedules` ,
 `spectacles` ,
 `contacts` ,
 `multimedias`  
 WHERE 1  AND contacts.country='FR' AND ( SUBSTRING(contacts.zip,1,2)  IN ('20','2A','2B'))  AND multimedias.`publish`=1  AND object_multimedia.`object`='spectacles'  AND object_multimedia.`idrole` IS NULL  AND schedules.`date` BETWEEN '2024-04-27' AND '2025-04-27'  AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND schedules.`idspectacle`=spectacles.`idspectacle` AND spectacles.`idspectacle`=object_multimedia.`idobject` AND contacts.`idcontact`=schedules.`idcontact` 
 GROUP BY object_multimedia.`idobject` 
ORDER BY schedules.`date` 
ASC 
LIMIT 0,5;

SELECT
  DISTINCT(T1.idnew),
  T1.*,
  T2.idextranetuser,
  T2.lastname,
  T2.firstname,
  T2.signature,
  T2.city as city_extranetuser,
  T2.enseignant_etablissement,
  T2.enseignant_active,
  T3.idnewschedule,
  T3.date,
  T3.hour,
  T3.idcontact,
  T3.note
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
WHERE
  1
  AND T1.publish = 1
  AND T1.publish = 1
  AND T1.valid = 1
  AND T1.type_news = 0
  AND (
    (
      T4.country = 'FR'
      AND (
        SUBSTRING(T4.zip, 1, 2) IN ('20', '2A', '2B')
      )
      AND T3.date >= '2024-04-27'
    )
  )
GROUP BY
  T1.idnew
ORDER BY
  T3.date ASC
LIMIT
  0, 5

SELECT DISTINCT(T1.idnew), T1.*,T2.idextranetuser,T2.lastname,T2.firstname,T2.signature,T2.city as city_extranetuser,T2.enseignant_etablissement,T2.enseignant_active,T3.idnewschedule,T3.date,T3.hour,T3.idcontact,T3.note  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  WHERE 1  AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND T1.type_news=0 AND (( T4.country='FR' AND ( SUBSTRING(T4.zip,1,2)  IN ('20','2A','2B')) AND  T3.date>='2024-04-27' ))  GROUP BY T1.idnew  ORDER BY T3.date ASC LIMIT 0,5;

SELECT
  DISTINCT(T1.idnew),
  T1.*,
  T2.idextranetuser,
  T2.lastname,
  T2.firstname,
  T2.signature,
  T2.city as city_extranetuser,
  T2.enseignant_etablissement,
  T2.enseignant_active,
  T3.idnewschedule,
  T3.date,
  T3.hour,
  T3.idcontact,
  T3.note
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
WHERE
  1
  AND T1.publish = 1
  AND T1.publish = 1
  AND T1.valid = 1
  AND T1.type_news = 0
  AND (
    (
      T4.country = 'FR'
      AND (
        SUBSTRING(T4.zip, 1, 2) IN ('20', '2A', '2B')
      )
      AND T3.date < '2024-04-27'
    )
  )
GROUP BY
  T1.idnew
ORDER BY
  T3.date DESC
LIMIT
  0, 5

SELECT DISTINCT(T1.idnew), T1.*,T2.idextranetuser,T2.lastname,T2.firstname,T2.signature,T2.city as city_extranetuser,T2.enseignant_etablissement,T2.enseignant_active,T3.idnewschedule,T3.date,T3.hour,T3.idcontact,T3.note  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  WHERE 1  AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND T1.type_news=0 AND (( T4.country='FR' AND ( SUBSTRING(T4.zip,1,2)  IN ('20','2A','2B')) AND  T3.date<'2024-04-27' ))  GROUP BY T1.idnew  ORDER BY T3.date DESC LIMIT 0,5;

SELECT
  t0.idnew AS idnew_1,
  t0.title AS title_2,
  t0.type_news AS type_news_3,
  t0.description AS description_4,
  t0.markdown AS markdown_5,
  t0.date_start AS date_start_6,
  t0.date_end AS date_end_7,
  t0.hour AS hour_8,
  t0.location AS location_9,
  t0.city AS city_10,
  t0.zip AS zip_11,
  t0.contacts AS contacts_12,
  t0.url AS url_13,
  t0.url_more AS url_more_14,
  t0.infos_contacts AS infos_contacts_15,
  t0.url_file AS url_file_16,
  t0.copyright_file AS copyright_file_17,
  t0.is_homepage AS is_homepage_18,
  t0.publish AS publish_19,
  t0.valid AS valid_20,
  t0.statut AS statut_21,
  t0.dateinsert AS dateinsert_22,
  t0.dateupdate AS dateupdate_23,
  t0.idextranetuser_lock AS idextranetuser_lock_24,
  t0.idextranetuser AS idextranetuser_25,
  t0.idregion AS idregion_26,
  t0.country AS country_27
FROM
  news t0
WHERE
  t0.idnew = ?