Symfony Profiler

Last 10 Latest Search
Settings
Query Metrics

422 Database Queries
262 Different statements
10358.05 ms Query time
1 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts
Queries

Group similar statements

SELECT idcontact FROM contacts WHERE url_clean='Theatre-de-Cornouaille'
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 fr FROM countries WHERE id='FR'
SELECT t0_.idtypestructure AS idtypestructure_0, t0_.typestructure_pluriel AS typestructure_pluriel_1, t0_.typestructure AS typestructure_2, t0_.public_view AS public_view_3, t0_.order_view AS order_view_4 FROM typesstructures t0_ WHERE t0_.idtypestructure = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j2.idoffice,j2.date_start,j2.date_end ,j3.idcontact FROM theatreok_dev.persons j1, theatreok_dev.contact_person j2, theatreok_dev.contacts j3
                        WHERE j3.idcontact=j2.idcontact
                        AND j1.idperson=j2.idperson
                        AND j3.idcontact=536  AND j2.idoffice=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='536'
                   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 *
                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='536'
                   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 DISTINCT(spectacles.`idspectacle`)  FROM schedules, spectacles  WHERE schedules.idspectacle=spectacles.idspectacle
                AND spectacles.publish=1
                AND (schedules.idcontact=536 OR schedules.idcontact_festival=536)
SELECT DISTINCT(spectacles.`idspectacle`)  FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle`  WHERE  spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=536 OR spectacles.`idcontact_production`=536) AND spectacle_contact.`idrole` IN (17,18,19)
SELECT DISTINCT(spectacles.`idspectacle`)  FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle`  WHERE  spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=536 OR spectacles.`idcontact_production`=536) AND spectacle_contact.`idrole` = 77
SELECT DISTINCT(spectacles.`idspectacle`)  FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle`
                                  INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide`  WHERE  spectacles.`publish`=1 AND aides.`idcontact`=536
SELECT DISTINCT(spectacles.`idspectacle`)  FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle`
                                  INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide`  WHERE  spectacles.`publish`=1 AND aides.`idcontact`=536 AND aides.type_aide IN (2,3)
SELECT DISTINCT(spectacles.`idspectacle`)  FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle`
                                  INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide`  WHERE  spectacles.`publish`=1 AND aides.`idcontact`=536 AND aides.type_aide IN (1)
SELECT DISTINCT(spectacles.`idspectacle`)  FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle`
                                  INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide`  WHERE  spectacles.`publish`=1 AND aides.`idcontact`=536 AND aides.type_aide IN (4)
SELECT COUNT(DISTINCT(multimedias.idmultimedia))
            FROM multimedias
            WHERE
            multimedias.`publish`=1
            AND (multimedias.`idmultimedia` IN (
                            SELECT multimedias.`idmultimedia`
                            FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia`
                            AND object_multimedia.`object` IN ('contacts', 'spectacles')
                            AND object_multimedia.idobject IN (28,868,915,929,1086,1254,1898,1243,1522,2611,2710,2998,3033,3235,3364,1456,2205,1763,2074,3490,3793,3816,3850,3859,4040,10,4079,3210,4147,4187,3377,4198,3908,3536,4307,4661,4462,4695,3888,4310,3667,4339,4372,5299,5303,4817,5273,5383,5022,5712,5798,4787,4131,2642,6037,5578,6076,5140,6704,6722,6457,6962,6736,7140,7408,5278,8417,8016,10974,8421,12064,12073,8388,7832,14947,14010,11194,15079,14648,14861,14718,17583,17656,14727,16588,18140,8041,19183,17766,1980,15268,20190,20327,5406,15266,20746,15803,15279,17558,18086,11720,15181,19638,18853,20736,14555,18265,17231,18216,21071,17664,17760,18508,8442,21844,21659,21311,23895,17662,17702,24151,21321,17995,20215,21398,24544,14425,18446,18154,10614,22473,21376,21387,24157,22320,12778,18183,19062,21442,20897,26917,27058,23746,20994,26836,23987,21613,27611,21269,27676,27935,17580,26800,22730,26786,22560,23819,27184,23883,29140,22322,27338,26763,26484,23892,30628,29213,29770,31847,26887,32209,26594,23701,32637,16684,22619,29843,32163,31041,5945,33772,34132,29338,31201,33658,28114,31548,35091,32581,25497,25498,27091,15029,30225,26155,36206,34570,29845,36405,28536,33751,36825,28511,36956,2136,2137,3859,4695,6037,6434,12064,12954,17766,18140,21071,21208,21284,21892,24151,24157,24544,25327,26579,29834,29843,29984,30867,31847,32197,32209,32581,32637,33169,33658,33700,33751,33772,35091,36206,36226,36825,37021)
                        ) OR multimedias.`idmultimedia` IN (    
                        SELECT multimedias.idmultimedia
                        FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia`
                        AND object_multimedia.object IN ('contacts')
                        AND object_multimedia.idobject=536
                    )
            )
SELECT COUNT(DISTINCT(ct.`idcontent`))
            FROM schedules sc
            JOIN spectacles s ON s.`idspectacle`=sc.`idspectacle`
            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 (
                sc.`idspectacle` IN ('2136','2137','3859','4695','6037','6434','12064','12954','17766','18140','21071','21208','21284','21892','24151','24157','24544','25327','26579','29834','29843','29984','30867','31847','32197','32209','32581','32637','33169','33658','33700','33751','33772','35091','36206','36226','36825','37021','28','868','915','929','1086','1254','1898','1243','1522','2611','2710','2998','3033','3235','3364','1456','2205','1763','2074','3490','3793','3816','3850','4040','10','4079','3210','4147','4187','3377','4198','3908','3536','4307','4661','4462','3888','4310','3667','4339','4372','5299','5303','4817','5273','5383','5022','5712','5798','4787','4131','2642','5578','6076','5140','6704','6722','6457','6962','6736','7140','7408','5278','8417','8016','10974','8421','12073','8388','7832','14947','14010','11194','15079','14648','14861','14718','17583','17656','14727','16588','8041','19183','1980','15268','20190','20327','5406','15266','20746','15803','15279','17558','18086','11720','15181','19638','18853','20736','14555','18265','17231','18216','17664','17760','18508','8442','21844','21659','21311','23895','17662','17702','21321','17995','20215','21398','14425','18446','18154','10614','22473','21376','21387','22320','12778','18183','19062','21442','20897','26917','27058','23746','20994','26836','23987','21613','27611','21269','27676','27935','17580','26800','22730','26786','22560','23819','27184','23883','29140','22322','27338','26763','26484','23892','30628','29213','29770','26887','26594','23701','16684','22619','32163','31041','5945','34132','29338','31201','28114','31548','25497','25498','27091','15029','30225','26155','34570','29845','36405','28536','28511','36956')
                OR (
                    sc.`idcontact`=536 OR sc.`idcontact_festival`=536
                )
            )
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 LEFT JOIN text_aide t8_ ON t1_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE a9_.idcontact IN (536) AND a9_.type_aide IN (2, 3) AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND ((s0_.date BETWEEN '2024-03-11' AND '2024-09-07')) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 2
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 LEFT JOIN text_aide t8_ ON t1_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE a9_.idcontact IN (536) AND a9_.type_aide IN (1) AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND ((s0_.date BETWEEN '2024-03-11' AND '2024-09-07')) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 4
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 LEFT JOIN text_aide t8_ ON t1_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE a9_.idcontact IN (536) AND a9_.type_aide IN (4) AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND ((s0_.date BETWEEN '2024-03-11' AND '2024-09-07')) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 4
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 LEFT JOIN spectacle_aide s8_ ON s2_.idspectacle = s8_.idspectacle AND (s8_.idspectacle = s2_.idspectacle) INNER JOIN aides a9_ ON s8_.idaide = a9_.idaide WHERE s8_.idaide = a9_.idaide AND a9_.idcontact IN (536) AND a9_.type_aide IN (2, 3) AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND ((s0_.date BETWEEN '2024-03-11' AND '2024-09-07')) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 10
SELECT  DISTINCT(files.idfile), files.*,file_classification.*,typesfiles.*,object_file.*,contacts.`url_clean`,contacts.`organisation`,contacts.`nom_suite`,contacts.`city` 
FROM  `files` ,
 `file_classification` ,
 `typesfiles` ,
 `object_file` ,
 `contacts`  
 WHERE 1  AND files.`publish`=1  AND object_file.`object`='contacts'  AND file_classification.`idclassification` IN (112)  AND contacts.`idcontact`=536  AND ( (files.`date_start`='2023-09-01' AND files.`date_end`='2024-08-31') )  AND files.`idfile`=object_file.`idfile` AND typesfiles.`idtype`=files.`idtype` AND file_classification.`idfile`=files.`idfile` AND object_file.`idobject`=contacts.`idcontact` 
GROUP BY files.idfile 
ORDER BY files.dateinsert 
DESC 
LIMIT 0,10
SELECT  DISTINCT(files.idfile), files.*,file_classification.*,typesfiles.*,object_file.*,contacts.`url_clean`,contacts.`organisation`,contacts.`nom_suite`,contacts.`city` 
FROM  `files` ,
 `file_classification` ,
 `typesfiles` ,
 `object_file` ,
 `contacts`  
 WHERE 1  AND files.`publish`=1  AND object_file.`object`='contacts'  AND file_classification.`idclassification` IN (112)  AND contacts.`idcontact`=536 AND files.`idfile`=object_file.`idfile` AND typesfiles.`idtype`=files.`idtype` AND file_classification.`idfile`=files.`idfile` AND object_file.`idobject`=contacts.`idcontact` 
GROUP BY files.idfile 
ORDER BY files.`date_end` 
DESC 
LIMIT 0,1
SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=101354
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
                            INNER JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idcontact=536 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND T1.type_news=0 AND (( T3.date>='2024-03-11' ))  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
                            INNER JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idcontact=536 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND T1.type_news=0 AND (( T3.date<'2024-03-11' ))  GROUP BY T1.idnew  ORDER BY T3.date DESC LIMIT 0,5
SELECT DISTINCT(ct.`idcontent`), ct.title as title, ct.*, e.`login`, e.`idextranetuser`  FROM contents ct
                JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent`
                JOIN object_content oc ON ct.`idcontent`=oc.`idcontent`
                JOIN spectacles s ON oc.`idobject`=s.`idspectacle`
                JOIN schedules sc ON s.`idspectacle`=sc.`idspectacle`
                JOIN extranetusers e ON ct.`idextranetuser`=e.`idextranetuser`  WHERE s.`publish`=1 AND s.`valid`=1
                        AND ct.`publish`=1 AND ct.`valid`=1
                        AND cc.`idclassification`=101
                        AND (sc.`idcontact`=536
                        OR sc.`idcontact_festival`=536)  ORDER BY  ct.`date_article` DESC LIMIT 0,4
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='131889'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=38615  ORDER BY j2.classement ASC
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=31041  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 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='131865'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
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 = 34570 GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 10
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=42848  ORDER BY j2.classement ASC
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=34570  ORDER BY p.`lastname`
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=34570  AND r.type_creator=1 ORDER BY sp.`classement`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 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='131826'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
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 = 31201 GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 10
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=38779  ORDER BY j2.classement ASC
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=31201  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 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='131807'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=38779  ORDER BY j2.classement ASC
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=31201  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT t0.idextranetuser AS idextranetuser_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.avatar AS avatar_4, t0.signature AS signature_5, t0.email AS email_6, t0.token AS token_7, t0.public_api_token AS public_api_token_8, t0.public_api_desc AS public_api_desc_9, t0.address AS address_10, t0.zip AS zip_11, t0.city AS city_12, t0.secteur AS secteur_13, t0.structure AS structure_14, t0.fonction AS fonction_15, t0.phone AS phone_16, t0.enseignant_fonction AS enseignant_fonction_17, t0.enseignant_matiere AS enseignant_matiere_18, t0.enseignant_etablissement AS enseignant_etablissement_19, t0.enseignant_qualite AS enseignant_qualite_20, t0.enseignant_precision_qualite AS enseignant_precision_qualite_21, t0.enseignant_active AS enseignant_active_22, t0.stats_acces AS stats_acces_23, t0.alerte_bac AS alerte_bac_24, t0.email_validation AS email_validation_25, t0.connexion_theduc AS connexion_theduc_26, t0.inscription_from AS inscription_from_27, t0.private_comment AS private_comment_28, t0.login AS login_29, t0.other_email AS other_email_30, t0.code_chge_email AS code_chge_email_31, t0.old_login AS old_login_32, t0.password AS password_33, t0.thnetuser AS thnetuser_34, t0.last_visit_annonces AS last_visit_annonces_35, t0.address_ip AS address_ip_36, t0.verified AS verified_37, t0.activekey AS activekey_38, t0.token_cookie AS token_cookie_39, t0.date_resend AS date_resend_40, t0.tokenpass AS tokenpass_41, t0.sub_subscriber_id AS sub_subscriber_id_42, t0.userrights AS userrights_43, t0.special_user AS special_user_44, t0.pseudo_streaming AS pseudo_streaming_45, t0.contact_owner AS contact_owner_46, t0.justification AS justification_47, t0.sent AS sent_48, t0.dateupdate AS dateupdate_49, t0.dateinsert AS dateinsert_50, t0.active AS active_51, t0.country AS country_52, t0.idregion AS idregion_53 FROM extranetusers t0 WHERE t0.idextranetuser = ?
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-03-11' AND '2025-07-24')) AND (s0_.idcontact = 536 AND s2_.publish = 1) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 6
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=42848  ORDER BY j2.classement ASC
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=34570  ORDER BY p.`lastname`
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=34570  AND r.type_creator=1 ORDER BY sp.`classement`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? AND s0_.idcontact = ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=34570
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=34570 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='34570'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=34570 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=34570 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=34570 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=44677  ORDER BY j2.classement ASC
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=36405  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? AND s0_.idcontact = ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36405
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=36405 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='36405'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36405 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36405 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36405 AND cc.idclassification=101 LIMIT 1
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, c2_.idcontact AS idcontact_2, s3_.idspectacle AS idspectacle_3, s3_.title AS title_4, s3_.language AS language_5, s3_.creation_date AS creation_date_6, s3_.url_page AS url_page_7, s3_.infos AS infos_8, s3_.tag AS tag_9, s3_.id_rubrique AS id_rubrique_10, s3_.duration AS duration_11, s3_.interlude AS interlude_12, s3_.textfictif AS textfictif_13, s3_.url_redirect AS url_redirect_14, s3_.url_clean AS url_clean_15, s3_.dateupdate AS dateupdate_16, s3_.dateinsert AS dateinsert_17, s3_.publish AS publish_18, s3_.statut AS statut_19, s3_.valid AS valid_20, t1_.idtext AS idtext_21, t1_.type AS type_22, t1_.idtypetext AS idtypetext_23, t1_.special_text AS special_text_24, t1_.title AS title_25, t1_.subtitle AS subtitle_26, t1_.date AS date_27, t1_.language AS language_28, t1_.markdown AS markdown_29, t1_.abstract AS abstract_30, t1_.abstract_author AS abstract_author_31, t1_.abstract_date AS abstract_date_32, t1_.abstract_url AS abstract_url_33, t1_.publisher_url_text AS publisher_url_text_34, t1_.publication_year AS publication_year_35, t1_.publication_month AS publication_month_36, t1_.isbn AS isbn_37, t1_.ean AS ean_38, t1_.publishinfos AS publishinfos_39, t1_.urltextaccess AS urltextaccess_40, t1_.emailtextaccess AS emailtextaccess_41, t1_.idfiletextaccess AS idfiletextaccess_42, t1_.filetextaccesssave AS filetextaccesssave_43, t1_.textaccessmore AS textaccessmore_44, t1_.request_translation_text AS request_translation_text_45, t1_.request_performing_text AS request_performing_text_46, t1_.help_translation AS help_translation_47, t1_.help_publishing AS help_publishing_48, t1_.help_other AS help_other_49, t1_.moreinfo AS moreinfo_50, t1_.nmale AS nmale_51, t1_.nfemale AS nfemale_52, t1_.npeople AS npeople_53, t1_.textorder AS textorder_54, t1_.nbpages AS nbpages_55, t1_.price AS price_56, t1_.selection_aneth AS selection_aneth_57, t1_.idtext_aneth AS idtext_aneth_58, t1_.aide_creation AS aide_creation_59, t1_.comments AS comments_60, t1_.url_clean AS url_clean_61, t1_.textfictif AS textfictif_62, t1_.valid_opendata AS valid_opendata_63, t1_.dateupdate AS dateupdate_64, t1_.dateinsert AS dateinsert_65, t1_.publish AS publish_66, t1_.statut AS statut_67, t1_.valid AS valid_68, t4_.idtypespectacle AS idtypespectacle_69 FROM spectacles s3_ LEFT JOIN text_spectacle t5_ ON s3_.idspectacle = t5_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t5_.idtext LEFT JOIN typesspectacles t4_ ON s3_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s0_ ON s3_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s7_ ON s3_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c2_ ON s0_.idcontact = c2_.idcontact LEFT JOIN spectacle_contact s8_ ON (s8_.idspectacle = s3_.idspectacle) WHERE s0_.idspectacle = s3_.idspectacle AND (s0_.idcontact = c2_.idcontact OR s0_.idcontact_festival = c2_.idcontact) AND ((s0_.date BETWEEN '2024-03-11' AND '2025-07-24')) AND (s3_.publish = 1 AND s8_.idrole IN (17, 18, 19) AND s8_.idcontact = 536 AND s3_.idspectacle NOT IN (34570, 36405)) GROUP BY s3_.idspectacle ORDER BY s0_.date ASC LIMIT 4
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=44502  ORDER BY j2.classement ASC
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=36226  ORDER BY p.`lastname`
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=36226  AND r.type_creator=1 ORDER BY sp.`classement`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36226
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=36226 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='36226'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36226 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36226 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36226 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=44622  ORDER BY j2.classement ASC
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=36206  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36206
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=36206 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='36206'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36206 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36206 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36206 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=42027  ORDER BY j2.classement ASC
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=33751  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=33751
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=33751 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='33751'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33751 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33751 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33751 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=41932  ORDER BY j2.classement ASC
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=33658  ORDER BY p.`lastname`
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=33658  AND r.type_creator=1 ORDER BY sp.`classement`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=33658
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=33658 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='33658'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33658 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33658 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33658 AND cc.idclassification=101 LIMIT 1
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, c2_.idcontact AS idcontact_2, s3_.idspectacle AS idspectacle_3, s3_.title AS title_4, s3_.language AS language_5, s3_.creation_date AS creation_date_6, s3_.url_page AS url_page_7, s3_.infos AS infos_8, s3_.tag AS tag_9, s3_.id_rubrique AS id_rubrique_10, s3_.duration AS duration_11, s3_.interlude AS interlude_12, s3_.textfictif AS textfictif_13, s3_.url_redirect AS url_redirect_14, s3_.url_clean AS url_clean_15, s3_.dateupdate AS dateupdate_16, s3_.dateinsert AS dateinsert_17, s3_.publish AS publish_18, s3_.statut AS statut_19, s3_.valid AS valid_20, t1_.idtext AS idtext_21, t1_.type AS type_22, t1_.idtypetext AS idtypetext_23, t1_.special_text AS special_text_24, t1_.title AS title_25, t1_.subtitle AS subtitle_26, t1_.date AS date_27, t1_.language AS language_28, t1_.markdown AS markdown_29, t1_.abstract AS abstract_30, t1_.abstract_author AS abstract_author_31, t1_.abstract_date AS abstract_date_32, t1_.abstract_url AS abstract_url_33, t1_.publisher_url_text AS publisher_url_text_34, t1_.publication_year AS publication_year_35, t1_.publication_month AS publication_month_36, t1_.isbn AS isbn_37, t1_.ean AS ean_38, t1_.publishinfos AS publishinfos_39, t1_.urltextaccess AS urltextaccess_40, t1_.emailtextaccess AS emailtextaccess_41, t1_.idfiletextaccess AS idfiletextaccess_42, t1_.filetextaccesssave AS filetextaccesssave_43, t1_.textaccessmore AS textaccessmore_44, t1_.request_translation_text AS request_translation_text_45, t1_.request_performing_text AS request_performing_text_46, t1_.help_translation AS help_translation_47, t1_.help_publishing AS help_publishing_48, t1_.help_other AS help_other_49, t1_.moreinfo AS moreinfo_50, t1_.nmale AS nmale_51, t1_.nfemale AS nfemale_52, t1_.npeople AS npeople_53, t1_.textorder AS textorder_54, t1_.nbpages AS nbpages_55, t1_.price AS price_56, t1_.selection_aneth AS selection_aneth_57, t1_.idtext_aneth AS idtext_aneth_58, t1_.aide_creation AS aide_creation_59, t1_.comments AS comments_60, t1_.url_clean AS url_clean_61, t1_.textfictif AS textfictif_62, t1_.valid_opendata AS valid_opendata_63, t1_.dateupdate AS dateupdate_64, t1_.dateinsert AS dateinsert_65, t1_.publish AS publish_66, t1_.statut AS statut_67, t1_.valid AS valid_68, t4_.idtypespectacle AS idtypespectacle_69 FROM spectacles s3_ LEFT JOIN text_spectacle t5_ ON s3_.idspectacle = t5_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t5_.idtext LEFT JOIN typesspectacles t4_ ON s3_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s0_ ON s3_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s7_ ON s3_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c2_ ON s0_.idcontact = c2_.idcontact WHERE s0_.idspectacle = s3_.idspectacle AND (s0_.idcontact = c2_.idcontact OR s0_.idcontact_festival = c2_.idcontact) AND (s0_.idcontact = 536 AND s3_.publish = 1) GROUP BY s3_.idspectacle HAVING MAX(s0_.date) < '2024-03-11' ORDER BY s0_.date DESC LIMIT 4
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=44622  ORDER BY j2.classement ASC
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=36206  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date < ? GROUP BY s0_.idcontact ORDER BY s0_.date DESC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36206
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=36206 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='36206'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36206 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36206 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36206 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=42027  ORDER BY j2.classement ASC
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=33751  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date < ? GROUP BY s0_.idcontact ORDER BY s0_.date DESC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=33751
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=33751 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='33751'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33751 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33751 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33751 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=45212  ORDER BY j2.classement ASC
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=36956  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date < ? GROUP BY s0_.idcontact ORDER BY s0_.date DESC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36956
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=36956 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='36956'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36956 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36956 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36956 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=45088  ORDER BY j2.classement ASC
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=36825  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date < ? GROUP BY s0_.idcontact ORDER BY s0_.date DESC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36825
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=36825 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='36825'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36825 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36825 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36825 AND cc.idclassification=101 LIMIT 1
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, c2_.idcontact AS idcontact_2, s3_.idspectacle AS idspectacle_3, s3_.title AS title_4, s3_.language AS language_5, s3_.creation_date AS creation_date_6, s3_.url_page AS url_page_7, s3_.infos AS infos_8, s3_.tag AS tag_9, s3_.id_rubrique AS id_rubrique_10, s3_.duration AS duration_11, s3_.interlude AS interlude_12, s3_.textfictif AS textfictif_13, s3_.url_redirect AS url_redirect_14, s3_.url_clean AS url_clean_15, s3_.dateupdate AS dateupdate_16, s3_.dateinsert AS dateinsert_17, s3_.publish AS publish_18, s3_.statut AS statut_19, s3_.valid AS valid_20, t1_.idtext AS idtext_21, t1_.type AS type_22, t1_.idtypetext AS idtypetext_23, t1_.special_text AS special_text_24, t1_.title AS title_25, t1_.subtitle AS subtitle_26, t1_.date AS date_27, t1_.language AS language_28, t1_.markdown AS markdown_29, t1_.abstract AS abstract_30, t1_.abstract_author AS abstract_author_31, t1_.abstract_date AS abstract_date_32, t1_.abstract_url AS abstract_url_33, t1_.publisher_url_text AS publisher_url_text_34, t1_.publication_year AS publication_year_35, t1_.publication_month AS publication_month_36, t1_.isbn AS isbn_37, t1_.ean AS ean_38, t1_.publishinfos AS publishinfos_39, t1_.urltextaccess AS urltextaccess_40, t1_.emailtextaccess AS emailtextaccess_41, t1_.idfiletextaccess AS idfiletextaccess_42, t1_.filetextaccesssave AS filetextaccesssave_43, t1_.textaccessmore AS textaccessmore_44, t1_.request_translation_text AS request_translation_text_45, t1_.request_performing_text AS request_performing_text_46, t1_.help_translation AS help_translation_47, t1_.help_publishing AS help_publishing_48, t1_.help_other AS help_other_49, t1_.moreinfo AS moreinfo_50, t1_.nmale AS nmale_51, t1_.nfemale AS nfemale_52, t1_.npeople AS npeople_53, t1_.textorder AS textorder_54, t1_.nbpages AS nbpages_55, t1_.price AS price_56, t1_.selection_aneth AS selection_aneth_57, t1_.idtext_aneth AS idtext_aneth_58, t1_.aide_creation AS aide_creation_59, t1_.comments AS comments_60, t1_.url_clean AS url_clean_61, t1_.textfictif AS textfictif_62, t1_.valid_opendata AS valid_opendata_63, t1_.dateupdate AS dateupdate_64, t1_.dateinsert AS dateinsert_65, t1_.publish AS publish_66, t1_.statut AS statut_67, t1_.valid AS valid_68, t4_.idtypespectacle AS idtypespectacle_69 FROM spectacles s3_ LEFT JOIN text_spectacle t5_ ON s3_.idspectacle = t5_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t5_.idtext LEFT JOIN typesspectacles t4_ ON s3_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s0_ ON s3_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s7_ ON s3_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c2_ ON s0_.idcontact = c2_.idcontact LEFT JOIN spectacle_contact s8_ ON (s8_.idspectacle = s3_.idspectacle) WHERE s0_.idspectacle = s3_.idspectacle AND (s0_.idcontact = c2_.idcontact OR s0_.idcontact_festival = c2_.idcontact) AND s0_.date < '2024-03-11' AND (s3_.publish = 1 AND (s8_.idrole IN (17, 18, 19) AND s8_.idcontact = 536) AND s3_.idspectacle NOT IN (36226, 36206, 33751, 33658)) GROUP BY s3_.idspectacle ORDER BY s0_.date DESC LIMIT 4
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=45088  ORDER BY j2.classement ASC
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=36825  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date < ? GROUP BY s0_.idcontact ORDER BY s0_.date DESC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36825
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=36825 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='36825'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36825 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36825 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=36825 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=45275  ORDER BY j2.classement ASC
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=37021  ORDER BY p.`lastname`
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=37021  AND r.type_creator=1 ORDER BY sp.`classement`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date < ? GROUP BY s0_.idcontact ORDER BY s0_.date DESC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=37021
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=37021 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='37021'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=37021 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=37021 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=37021 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT DISTINCT(p.`idperson`),p.`lastname`,p.`firstname`,p.`url_clean`
                FROM persons p
                    JOIN text_author ta ON ta.`idperson`=p.`idperson`
                    JOIN text_spectacle ts ON ts.`idtext`=ta.`idtext`
                WHERE ts.`idspectacle`=35091
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=35091  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date < ? GROUP BY s0_.idcontact ORDER BY s0_.date DESC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=35091
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=35091 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='35091'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=35091 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=35091 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=35091 AND cc.idclassification=101 LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=42065  ORDER BY j2.classement ASC
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=33772  ORDER BY p.`lastname`
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=33772  AND r.type_creator=1 ORDER BY sp.`classement`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date < ? GROUP BY s0_.idcontact ORDER BY s0_.date DESC LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=33772
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=33772 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='33772'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33772 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33772 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=33772 AND cc.idclassification=101 LIMIT 1
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, c2_.idcontact AS idcontact_2, s3_.idspectacle AS idspectacle_3, s3_.title AS title_4, s3_.language AS language_5, s3_.creation_date AS creation_date_6, s3_.url_page AS url_page_7, s3_.infos AS infos_8, s3_.tag AS tag_9, s3_.id_rubrique AS id_rubrique_10, s3_.duration AS duration_11, s3_.interlude AS interlude_12, s3_.textfictif AS textfictif_13, s3_.url_redirect AS url_redirect_14, s3_.url_clean AS url_clean_15, s3_.dateupdate AS dateupdate_16, s3_.dateinsert AS dateinsert_17, s3_.publish AS publish_18, s3_.statut AS statut_19, s3_.valid AS valid_20, t1_.idtext AS idtext_21, t1_.type AS type_22, t1_.idtypetext AS idtypetext_23, t1_.special_text AS special_text_24, t1_.title AS title_25, t1_.subtitle AS subtitle_26, t1_.date AS date_27, t1_.language AS language_28, t1_.markdown AS markdown_29, t1_.abstract AS abstract_30, t1_.abstract_author AS abstract_author_31, t1_.abstract_date AS abstract_date_32, t1_.abstract_url AS abstract_url_33, t1_.publisher_url_text AS publisher_url_text_34, t1_.publication_year AS publication_year_35, t1_.publication_month AS publication_month_36, t1_.isbn AS isbn_37, t1_.ean AS ean_38, t1_.publishinfos AS publishinfos_39, t1_.urltextaccess AS urltextaccess_40, t1_.emailtextaccess AS emailtextaccess_41, t1_.idfiletextaccess AS idfiletextaccess_42, t1_.filetextaccesssave AS filetextaccesssave_43, t1_.textaccessmore AS textaccessmore_44, t1_.request_translation_text AS request_translation_text_45, t1_.request_performing_text AS request_performing_text_46, t1_.help_translation AS help_translation_47, t1_.help_publishing AS help_publishing_48, t1_.help_other AS help_other_49, t1_.moreinfo AS moreinfo_50, t1_.nmale AS nmale_51, t1_.nfemale AS nfemale_52, t1_.npeople AS npeople_53, t1_.textorder AS textorder_54, t1_.nbpages AS nbpages_55, t1_.price AS price_56, t1_.selection_aneth AS selection_aneth_57, t1_.idtext_aneth AS idtext_aneth_58, t1_.aide_creation AS aide_creation_59, t1_.comments AS comments_60, t1_.url_clean AS url_clean_61, t1_.textfictif AS textfictif_62, t1_.valid_opendata AS valid_opendata_63, t1_.dateupdate AS dateupdate_64, t1_.dateinsert AS dateinsert_65, t1_.publish AS publish_66, t1_.statut AS statut_67, t1_.valid AS valid_68, t4_.idtypespectacle AS idtypespectacle_69 FROM spectacles s3_ LEFT JOIN text_spectacle t5_ ON s3_.idspectacle = t5_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t5_.idtext LEFT JOIN typesspectacles t4_ ON s3_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s0_ ON s3_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s7_ ON s3_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c2_ ON s0_.idcontact = c2_.idcontact LEFT JOIN spectacle_contact s8_ ON (s8_.idspectacle = s3_.idspectacle) WHERE s0_.idspectacle = s3_.idspectacle AND (s0_.idcontact = c2_.idcontact OR s0_.idcontact_festival = c2_.idcontact) AND s0_.date < '2024-03-11' AND (s3_.publish = 1 AND (s8_.idrole IN (77) AND s8_.idcontact = 536)) GROUP BY s3_.idspectacle ORDER BY s0_.date DESC LIMIT 4
SELECT COUNT(DISTINCT(sct.idspectacle))
                             FROM spectacles s
                             INNER JOIN spectacle_contact sct ON sct.idspectacle = s.idspectacle
                             INNER JOIN schedules sc ON sc.idspectacle = s.idspectacle
                             WHERE (
                                (sct.idrole IN (17,18,19) AND sct.idcontact=536)
                                OR (sc.idcontact=536)
                             )  AND s.idspectacle NOT IN (36825,37021,35091,33772,36206,33751,36956,36825,36226,36206,33751,33658,34570,36405)
SELECT  DISTINCT(multimedias.idmultimedia), multimedias.* 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1  AND multimedias.`audio_video`=2  AND multimedias.`publish`=1  AND object_multimedia.`object` IN ('contacts')  AND object_multimedia.`idobject`=536 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.date 
DESC 
LIMIT 0,4
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=1981
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=1981
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=1981
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=1981
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=1981
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=1981
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=1981
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=4695
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=4695
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=1981
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=1981 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=1979
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=1979
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=1979
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=1979
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=1979
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=1979
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=1979
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=4695
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=4695
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=1979
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=1979 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_contact` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_contact.`idcontact` IN (536)  AND podcasts.`code_franceinter` IS NOT NULL AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_contact.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,7
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_contact` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_contact.`idcontact` IN (536)  AND podcasts.`code_ft` IS NOT NULL AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_contact.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,1
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, m2_.idmultimedia AS idmultimedia_2, s3_.idspectacle AS idspectacle_3, s3_.title AS title_4, s3_.language AS language_5, s3_.creation_date AS creation_date_6, s3_.url_page AS url_page_7, s3_.infos AS infos_8, s3_.tag AS tag_9, s3_.id_rubrique AS id_rubrique_10, s3_.duration AS duration_11, s3_.interlude AS interlude_12, s3_.textfictif AS textfictif_13, s3_.url_redirect AS url_redirect_14, s3_.url_clean AS url_clean_15, s3_.dateupdate AS dateupdate_16, s3_.dateinsert AS dateinsert_17, s3_.publish AS publish_18, s3_.statut AS statut_19, s3_.valid AS valid_20, t1_.idtext AS idtext_21, t1_.type AS type_22, t1_.idtypetext AS idtypetext_23, t1_.special_text AS special_text_24, t1_.title AS title_25, t1_.subtitle AS subtitle_26, t1_.date AS date_27, t1_.language AS language_28, t1_.markdown AS markdown_29, t1_.abstract AS abstract_30, t1_.abstract_author AS abstract_author_31, t1_.abstract_date AS abstract_date_32, t1_.abstract_url AS abstract_url_33, t1_.publisher_url_text AS publisher_url_text_34, t1_.publication_year AS publication_year_35, t1_.publication_month AS publication_month_36, t1_.isbn AS isbn_37, t1_.ean AS ean_38, t1_.publishinfos AS publishinfos_39, t1_.urltextaccess AS urltextaccess_40, t1_.emailtextaccess AS emailtextaccess_41, t1_.idfiletextaccess AS idfiletextaccess_42, t1_.filetextaccesssave AS filetextaccesssave_43, t1_.textaccessmore AS textaccessmore_44, t1_.request_translation_text AS request_translation_text_45, t1_.request_performing_text AS request_performing_text_46, t1_.help_translation AS help_translation_47, t1_.help_publishing AS help_publishing_48, t1_.help_other AS help_other_49, t1_.moreinfo AS moreinfo_50, t1_.nmale AS nmale_51, t1_.nfemale AS nfemale_52, t1_.npeople AS npeople_53, t1_.textorder AS textorder_54, t1_.nbpages AS nbpages_55, t1_.price AS price_56, t1_.selection_aneth AS selection_aneth_57, t1_.idtext_aneth AS idtext_aneth_58, t1_.aide_creation AS aide_creation_59, t1_.comments AS comments_60, t1_.url_clean AS url_clean_61, t1_.textfictif AS textfictif_62, t1_.valid_opendata AS valid_opendata_63, t1_.dateupdate AS dateupdate_64, t1_.dateinsert AS dateinsert_65, t1_.publish AS publish_66, t1_.statut AS statut_67, t1_.valid AS valid_68, t4_.idtypespectacle AS idtypespectacle_69 FROM spectacles s3_ LEFT JOIN text_spectacle t5_ ON s3_.idspectacle = t5_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t5_.idtext LEFT JOIN typesspectacles t4_ ON s3_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s0_ ON s3_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s7_ ON s3_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s0_.idcontact = c8_.idcontact LEFT JOIN object_multimedia o9_ ON (s3_.idspectacle = o9_.idobject) LEFT JOIN multimedias m2_ ON (m2_.idmultimedia = o9_.idmultimedia) WHERE s0_.idspectacle = s3_.idspectacle AND (s0_.idcontact = c8_.idcontact OR s0_.idcontact_festival = c8_.idcontact) AND o9_.object = 'spectacles' AND m2_.publish = 1 AND s0_.date >= '2024-03-11' AND (s3_.publish = 1 AND s0_.idcontact = 536) GROUP BY s3_.idspectacle ORDER BY s0_.date ASC LIMIT 20
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=42848  ORDER BY j2.classement ASC
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=34570  ORDER BY p.`lastname`
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=34570  AND r.type_creator=1 ORDER BY sp.`classement`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=44677  ORDER BY j2.classement ASC
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=36405  ORDER BY p.`lastname`
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT DISTINCT om.idmultimedia
                FROM object_multimedia om
                WHERE om.idobject = 34570 AND object like 'spectacles'
                LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=34570
                AND om.object='spectacles'
                AND m.publish=1
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=17363
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=17363
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=17363
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=17363
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=17363
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=17363
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=17363
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=34570
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? AND s0_.idcontact = ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT DISTINCT om.idmultimedia
                FROM object_multimedia om
                WHERE om.idobject = 36405 AND object like 'spectacles'
                LIMIT 1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36405
                AND om.object='spectacles'
                AND m.publish=1
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18200
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18200
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18200
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18200
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18200
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18200
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18200
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=36405
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? AND s0_.idcontact = ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
SELECT DISTINCT(spectacles.`idspectacle`)  FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle`  WHERE  spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=536 OR spectacles.`idcontact_production`=536) AND spectacle_contact.`idrole` IN (17,18,19)
SELECT DISTINCT(spectacles.`idspectacle`)  FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle`  WHERE  spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=536 OR spectacles.`idcontact_production`=536) AND spectacle_contact.`idrole` = 77
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle,
                    c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,
                    ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean
                    FROM schedules s
                    JOIN contacts c ON s.idcontact=c.idcontact
                    LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact
                    WHERE 1 AND s.idspectacle IN (2136,2137,3859,4695,6037,6434,12064,12954,17766,18140,21071,21208,21284,21892,24151,24157,24544,25327,26579,29834,29843,29984,30867,31847,32197,32209,32581,32637,33169,33658,33700,33751,33772,35091,36206,36226,36825,37021) AND s.date>='2024-03-11' ORDER BY s.date ASC LIMIT 0,3
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4
SELECT fr FROM languages WHERE id='fr'
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=36226
                AND t.idtext=ts.idtext
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=44502  ORDER BY j2.classement ASC
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=36226  AND r.type_creator=1 ORDER BY sp.`classement`
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4
SELECT fr FROM languages WHERE id='fr'
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=36226
                AND t.idtext=ts.idtext
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=44502  ORDER BY j2.classement ASC
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=36226  AND r.type_creator=1 ORDER BY sp.`classement`
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4
SELECT fr FROM languages WHERE id='fr'
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=36226
                AND t.idtext=ts.idtext
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=44502  ORDER BY j2.classement ASC
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=36226  AND r.type_creator=1 ORDER BY sp.`classement`
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_presentation_structure'))) AND contacts=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='536'
                   AND oc.object='contacts'
                   AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_presentation_structure'))) ORDER BY c.`range`,c.idcontent
SELECT DISTINCT(spectacles.`idspectacle`)  FROM schedules, spectacles  WHERE schedules.idspectacle=spectacles.idspectacle
                AND spectacles.publish=1
                AND (schedules.idcontact=536 OR schedules.idcontact_festival=536)
SELECT DISTINCT(spectacles.`idspectacle`)  FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle`  WHERE  spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=536 OR spectacles.`idcontact_production`=536) AND spectacle_contact.`idrole` = 77
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle,
                    c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,
                    ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean
                    FROM schedules s
                    JOIN contacts c ON s.idcontact=c.idcontact
                    LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact
                    WHERE 1 AND s.idspectacle IN (28,868,915,929,1086,1254,1898,1243,1522,2611,2710,2998,3033,3235,3364,1456,2205,1763,2074,3490,3793,3816,3850,3859,4040,10,4079,3210,4147,4187,3377,4198,3908,3536,4307,4661,4462,4695,3888,4310,3667,4339,4372,5299,5303,4817,5273,5383,5022,5712,5798,4787,4131,2642,6037,5578,6076,5140,6704,6722,6457,6962,6736,7140,7408,5278,8417,8016,10974,8421,12064,12073,8388,7832,14947,14010,11194,15079,14648,14861,14718,17583,17656,14727,16588,18140,8041,19183,17766,1980,15268,20190,20327,5406,15266,20746,15803,15279,17558,18086,11720,15181,19638,18853,20736,14555,18265,17231,18216,21071,17664,17760,18508,8442,21844,21659,21311,23895,17662,17702,24151,21321,17995,20215,21398,24544,14425,18446,18154,10614,22473,21376,21387,24157,22320,12778,18183,19062,21442,20897,26917,27058,23746,20994,26836,23987,21613,27611,21269,27676,27935,17580,26800,22730,26786,22560,23819,27184,23883,29140,22322,27338,26763,26484,23892,30628,29213,29770,31847,26887,32209,26594,23701,32637,16684,22619,29843,32163,31041,5945,33772,34132,29338,31201,33658,28114,31548,35091,32581,25497,25498,27091,15029,30225,26155,36206,34570,29845,36405,28536,33751,36825,28511,36956) AND s.date>='2024-03-11' AND c.idcontact = 536  ORDER BY s.date ASC LIMIT 0,3
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4
SELECT fr FROM languages WHERE id='fr'
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=34570
                AND t.idtext=ts.idtext
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=42848  ORDER BY j2.classement ASC
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=34570  AND r.type_creator=1 ORDER BY sp.`classement`
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4
SELECT fr FROM languages WHERE id='fr'
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=34570
                AND t.idtext=ts.idtext
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=42848  ORDER BY j2.classement ASC
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=34570  AND r.type_creator=1 ORDER BY sp.`classement`
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4
SELECT fr FROM languages WHERE id='fr'
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=34570
                AND t.idtext=ts.idtext
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=42848  ORDER BY j2.classement ASC
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=34570  AND r.type_creator=1 ORDER BY sp.`classement`
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.`idcontact`=536  AND aides.`type_aide` IN (2) AND aides.`idaide`=text_aide.`idaide`
SELECT  COUNT(DISTINCT(spectacle_aide.idspectacleaide)) as total , spectacle_aide.*,aides.*,`spectacle_aide`.`publish` as spectacle_aide_publish 
FROM  `aides` ,
 `spectacle_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (2) AND aides.`idaide`=spectacle_aide.`idaide`
SELECT  COUNT(DISTINCT(person_aide.idpersonaide)) as total , person_aide.*,aides.* 
FROM  `aides` ,
 `person_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (2) AND aides.`idaide`=person_aide.`idaide`
SELECT  COUNT(DISTINCT(contact_aide.idcontactaide)) as total , contact_aide.*,aides.*,`contact_aide`.`idcontact` as contact_aide_idcontact,`contact_aide`.`publish` as contact_aide_publish 
FROM  `aides` ,
 `contact_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (2) AND aides.`idaide`=contact_aide.`idaide`
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 LEFT JOIN spectacle_aide s8_ ON s2_.idspectacle = s8_.idspectacle AND (s8_.idspectacle = s2_.idspectacle) INNER JOIN aides a9_ ON s8_.idaide = a9_.idaide WHERE s8_.idaide = a9_.idaide AND a9_.idcontact IN (536) AND a9_.type_aide IN (1) AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND s2_.publish = 1 GROUP BY s2_.idspectacle ORDER BY s8_.date_start DESC LIMIT 4
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 LEFT JOIN spectacle_aide s8_ ON s2_.idspectacle = s8_.idspectacle AND (s8_.idspectacle = s2_.idspectacle) INNER JOIN aides a9_ ON s8_.idaide = a9_.idaide WHERE s8_.idaide = a9_.idaide AND a9_.idcontact IN (536) AND a9_.type_aide IN (1) AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND s0_.date >= '2024-03-11' AND s2_.publish = 1 GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 4
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 LEFT JOIN spectacle_aide s8_ ON s2_.idspectacle = s8_.idspectacle AND (s8_.idspectacle = s2_.idspectacle) INNER JOIN aides a9_ ON s8_.idaide = a9_.idaide WHERE s8_.idaide = a9_.idaide AND a9_.idcontact IN (536) AND a9_.type_aide IN (4) AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND s2_.publish = 1 GROUP BY s2_.idspectacle ORDER BY s8_.date_start DESC LIMIT 4
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 LEFT JOIN spectacle_aide s8_ ON s2_.idspectacle = s8_.idspectacle AND (s8_.idspectacle = s2_.idspectacle) INNER JOIN aides a9_ ON s8_.idaide = a9_.idaide WHERE s8_.idaide = a9_.idaide AND a9_.idcontact IN (536) AND a9_.type_aide IN (4) AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND s0_.date >= '2024-03-11' AND s2_.publish = 1 GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 4
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.`idcontact`=536  AND aides.`type_aide` IN (2,3) AND aides.`idaide`=text_aide.`idaide`
SELECT  COUNT(DISTINCT(spectacle_aide.idspectacleaide)) as total , spectacle_aide.*,aides.*,`spectacle_aide`.`publish` as spectacle_aide_publish 
FROM  `aides` ,
 `spectacle_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (2,3) AND aides.`idaide`=spectacle_aide.`idaide`
SELECT  COUNT(DISTINCT(person_aide.idpersonaide)) as total , person_aide.*,aides.* 
FROM  `aides` ,
 `person_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (2,3) AND aides.`idaide`=person_aide.`idaide`
SELECT  COUNT(DISTINCT(contact_aide.idcontactaide)) as total , contact_aide.*,aides.*,`contact_aide`.`idcontact` as contact_aide_idcontact,`contact_aide`.`publish` as contact_aide_publish 
FROM  `aides` ,
 `contact_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (2,3) AND aides.`idaide`=contact_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.`idcontact`=536  AND aides.`type_aide` IN (4) AND aides.`idaide`=text_aide.`idaide`
SELECT  COUNT(DISTINCT(spectacle_aide.idspectacleaide)) as total , spectacle_aide.*,aides.*,`spectacle_aide`.`publish` as spectacle_aide_publish 
FROM  `aides` ,
 `spectacle_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (4) AND aides.`idaide`=spectacle_aide.`idaide`
SELECT  COUNT(DISTINCT(person_aide.idpersonaide)) as total , person_aide.*,aides.* 
FROM  `aides` ,
 `person_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (4) AND aides.`idaide`=person_aide.`idaide`
SELECT  COUNT(DISTINCT(contact_aide.idcontactaide)) as total , contact_aide.*,aides.*,`contact_aide`.`idcontact` as contact_aide_idcontact,`contact_aide`.`publish` as contact_aide_publish 
FROM  `aides` ,
 `contact_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (4) AND aides.`idaide`=contact_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.`idcontact`=536  AND aides.`type_aide` IN (1) AND aides.`idaide`=text_aide.`idaide`
SELECT  COUNT(DISTINCT(spectacle_aide.idspectacleaide)) as total , spectacle_aide.*,aides.*,`spectacle_aide`.`publish` as spectacle_aide_publish 
FROM  `aides` ,
 `spectacle_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (1) AND aides.`idaide`=spectacle_aide.`idaide`
SELECT  COUNT(DISTINCT(person_aide.idpersonaide)) as total , person_aide.*,aides.* 
FROM  `aides` ,
 `person_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (1) AND aides.`idaide`=person_aide.`idaide`
SELECT  COUNT(DISTINCT(contact_aide.idcontactaide)) as total , contact_aide.*,aides.*,`contact_aide`.`idcontact` as contact_aide_idcontact,`contact_aide`.`publish` as contact_aide_publish 
FROM  `aides` ,
 `contact_aide`  
 WHERE 1  AND aides.`publish`=1  AND aides.`idcontact`=536  AND aides.`type_aide` IN (1) AND aides.`idaide`=contact_aide.`idaide`
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, p4_.idpodcast AS idpodcast_69, p4_.title AS title_70, p4_.description AS description_71, p4_.title_program AS title_program_72, p4_.name_program AS name_program_73, p4_.date_podcast AS date_podcast_74, p4_.hour_podcast AS hour_podcast_75, p4_.code_franceinter AS code_franceinter_76, p4_.type_franceinter AS type_franceinter_77, p4_.integrate_player AS integrate_player_78, p4_.link AS link_79, p4_.duration AS duration_80, p4_.code_ft AS code_ft_81, p4_.is_integrale AS is_integrale_82, p4_.type_diffusion AS type_diffusion_83, p4_.fin_visionnage_ft AS fin_visionnage_ft_84, p4_.date_captation_ft AS date_captation_ft_85, p4_.debut_visionnage_ft AS debut_visionnage_ft_86, p4_.code_arte AS code_arte_87, p4_.code_soundcloud AS code_soundcloud_88, p4_.code_spotify AS code_spotify_89, p4_.url_file AS url_file_90, p4_.url_clean AS url_clean_91, p4_.dateupdate AS dateupdate_92, p4_.dateinsert AS dateinsert_93, p4_.publish AS publish_94, p4_.valid AS valid_95, p4_.idextranetuser AS idextranetuser_96 FROM spectacles s2_ LEFT JOIN text_spectacle t5_ ON s2_.idspectacle = t5_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t5_.idtext LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s7_ ON s2_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s0_.idcontact = c8_.idcontact INNER JOIN podcast_spectacle p9_ ON s2_.idspectacle = p9_.idspectacle INNER JOIN podcasts p4_ ON p4_.idpodcast = p9_.idpodcast WHERE s2_.textfictif = 0 AND p4_.code_franceinter IS NOT NULL AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c8_.idcontact OR s0_.idcontact_festival = c8_.idcontact) AND s0_.date >= '2024-03-11' AND (s2_.publish = 1 AND s0_.idcontact = 536) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 2
SELECT person_ecole.*, contacts.`organisation`, contacts.`url_clean` 
                FROM person_ecole 
                    JOIN contacts ON contacts.`idcontact`=person_ecole.`idcontact` 
                WHERE  person_ecole.`idcontact`=536
SELECT COUNT(DISTINCT(multimedias.idmultimedia))
            FROM multimedias
            WHERE
            multimedias.`publish`=1
            AND (multimedias.`idmultimedia` IN (
                            SELECT multimedias.`idmultimedia`
                            FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia`
                            AND object_multimedia.`object` IN ('contacts', 'spectacles')
                            AND object_multimedia.idobject IN (28,868,915,929,1086,1254,1898,1243,1522,2611,2710,2998,3033,3235,3364,1456,2205,1763,2074,3490,3793,3816,3850,3859,4040,10,4079,3210,4147,4187,3377,4198,3908,3536,4307,4661,4462,4695,3888,4310,3667,4339,4372,5299,5303,4817,5273,5383,5022,5712,5798,4787,4131,2642,6037,5578,6076,5140,6704,6722,6457,6962,6736,7140,7408,5278,8417,8016,10974,8421,12064,12073,8388,7832,14947,14010,11194,15079,14648,14861,14718,17583,17656,14727,16588,18140,8041,19183,17766,1980,15268,20190,20327,5406,15266,20746,15803,15279,17558,18086,11720,15181,19638,18853,20736,14555,18265,17231,18216,21071,17664,17760,18508,8442,21844,21659,21311,23895,17662,17702,24151,21321,17995,20215,21398,24544,14425,18446,18154,10614,22473,21376,21387,24157,22320,12778,18183,19062,21442,20897,26917,27058,23746,20994,26836,23987,21613,27611,21269,27676,27935,17580,26800,22730,26786,22560,23819,27184,23883,29140,22322,27338,26763,26484,23892,30628,29213,29770,31847,26887,32209,26594,23701,32637,16684,22619,29843,32163,31041,5945,33772,34132,29338,31201,33658,28114,31548,35091,32581,25497,25498,27091,15029,30225,26155,36206,34570,29845,36405,28536,33751,36825,28511,36956,2136,2137,3859,4695,6037,6434,12064,12954,17766,18140,21071,21208,21284,21892,24151,24157,24544,25327,26579,29834,29843,29984,30867,31847,32197,32209,32581,32637,33169,33658,33700,33751,33772,35091,36206,36226,36825,37021)
                        ) OR multimedias.`idmultimedia` IN (    
                        SELECT multimedias.idmultimedia
                        FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia`
                        AND object_multimedia.object IN ('contacts')
                        AND object_multimedia.idobject=536
                    )
            )
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_presentation_structure'))) AND contacts=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='536'
                   AND oc.object='contacts'
                   AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_presentation_structure'))) ORDER BY c.`range`,c.idcontent
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_article'))) AND contacts=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='536'
                   AND oc.object='contacts'
                   AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_article'))) ORDER BY c.`range`,c.idcontent
SELECT COUNT(spectacle_aide.`idaide`)
                    FROM aides
                    JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=2
SELECT COUNT(text_aide.`idaide`)
                    FROM aides
                    JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=2
SELECT COUNT(person_aide.`idaide`)
                    FROM aides
                    JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=2
SELECT COUNT(contact_aide.`idaide`)
                    FROM aides
                    JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=2
SELECT COUNT(spectacle_aide.`idaide`)
                    FROM aides
                    JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=3
SELECT COUNT(text_aide.`idaide`)
                    FROM aides
                    JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=3
SELECT COUNT(person_aide.`idaide`)
                    FROM aides
                    JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=3
SELECT COUNT(contact_aide.`idaide`)
                    FROM aides
                    JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=3
SELECT COUNT(p.idplaylist)
              FROM playlists p
              LEFT JOIN playlist_classification pc ON p.idplaylist = pc.idplaylist
              LEFT JOIN aides a ON a.idcontact=536
              LEFT JOIN text_aide ta ON a.`idaide`=ta.`idaide`
              WHERE 1 AND a.`publish`=1 AND a.`type_aide` IN (2,3) AND pc.idclassification = 144 AND p.idtext = ta.idtext
              GROUP BY p.idtext
SELECT COUNT(spectacle_aide.`idaide`)
                    FROM aides
                    JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=1
SELECT COUNT(text_aide.`idaide`)
                    FROM aides
                    JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=1
SELECT COUNT(person_aide.`idaide`)
                    FROM aides
                    JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=1
SELECT COUNT(contact_aide.`idaide`)
                    FROM aides
                    JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=1
SELECT COUNT(spectacle_aide.`idaide`)
                    FROM aides
                    JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=4
SELECT COUNT(text_aide.`idaide`)
                    FROM aides
                    JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=4
SELECT COUNT(person_aide.`idaide`)
                    FROM aides
                    JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=4
SELECT COUNT(contact_aide.`idaide`)
                    FROM aides
                    JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=536
                    AND aides.`type_aide`=4
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 LEFT JOIN text_aide t8_ ON t2_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE s0_.textfictif = 0 AND a9_.idcontact IN (536) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-03-11' AND '2026-03-01')) 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 LEFT JOIN text_aide t8_ ON t2_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE s0_.textfictif = 0 AND a9_.idcontact IN (536) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date < '2024-03-11' ORDER BY s1_.date 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 s1_.date >= '2024-03-11' AND (s0_.publish = 1 AND s1_.idcontact = 536) ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, c2_.idcontact AS idcontact_2 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 c2_ ON s1_.idcontact = c2_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c2_.idcontact OR s1_.idcontact_festival = c2_.idcontact) AND (s0_.publish = 1 AND s1_.idcontact = 536) ORDER BY s1_.date 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 INNER JOIN spectacle_contact s8_ WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND (s8_.idrole IN (77) AND s8_.idcontact = 536)) 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 INNER JOIN spectacle_contact s8_ WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 536 OR s0_.idcontact_production = 536)) 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 INNER JOIN spectacle_contact s8_ WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-03-11' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 536 OR s0_.idcontact_production = 536)) 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 INNER JOIN podcast_spectacle p9_ ON s0_.idspectacle = p9_.idspectacle INNER JOIN podcasts p8_ ON p8_.idpodcast = p9_.idpodcast WHERE p8_.code_franceinter IS NOT NULL AND p8_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-03-11' AND (s0_.publish = 1 AND s1_.idcontact = 536) ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, c2_.idcontact AS idcontact_2 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 c2_ ON s1_.idcontact = c2_.idcontact INNER JOIN podcast_spectacle p9_ ON s0_.idspectacle = p9_.idspectacle INNER JOIN podcasts p8_ ON p8_.idpodcast = p9_.idpodcast WHERE p8_.code_franceinter IS NOT NULL AND p8_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c2_.idcontact OR s1_.idcontact_festival = c2_.idcontact) AND (s0_.publish = 1 AND s1_.idcontact = 536) ORDER BY s1_.date 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 INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_.idspectacle = p10_.idspectacle INNER JOIN podcasts p9_ ON p9_.idpodcast = p10_.idpodcast WHERE p9_.code_franceinter IS NOT NULL AND p9_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND (s8_.idrole IN (77) AND s8_.idcontact = 536)) 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 INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_.idspectacle = p10_.idspectacle INNER JOIN podcasts p9_ ON p9_.idpodcast = p10_.idpodcast WHERE p9_.code_franceinter IS NOT NULL AND p9_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 536 OR s0_.idcontact_production = 536)) 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 INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_.idspectacle = p10_.idspectacle INNER JOIN podcasts p9_ ON p9_.idpodcast = p10_.idpodcast WHERE p9_.code_franceinter IS NOT NULL AND p9_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-03-11' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 536 OR s0_.idcontact_production = 536)) 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 LEFT JOIN text_aide t8_ ON t2_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE s0_.textfictif = 0 AND a9_.idcontact IN (536) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) ORDER BY s1_.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=536 ) AND T1.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle` IN(2136,2137,3859,4695,6037,6434,12064,12954,17766,18140,21071,21208,21284,21892,24151,24157,24544,25327,26579,29834,29843,29984,30867,31847,32197,32209,32581,32637,33169,33658,33700,33751,33772,35091,36206,36226,36825,37021,28,868,915,929,1086,1254,1898,1243,1522,2611,2710,2998,3033,3235,3364,1456,2205,1763,2074,3490,3793,3816,3850,4040,10,4079,3210,4147,4187,3377,4198,3908,3536,4307,4661,4462,3888,4310,3667,4339,4372,5299,5303,4817,5273,5383,5022,5712,5798,4787,4131,2642,5578,6076,5140,6704,6722,6457,6962,6736,7140,7408,5278,8417,8016,10974,8421,12073,8388,7832,14947,14010,11194,15079,14648,14861,14718,17583,17656,14727,16588,8041,19183,1980,15268,20190,20327,5406,15266,20746,15803,15279,17558,18086,11720,15181,19638,18853,20736,14555,18265,17231,18216,17664,17760,18508,8442,21844,21659,21311,23895,17662,17702,21321,17995,20215,21398,14425,18446,18154,10614,22473,21376,21387,22320,12778,18183,19062,21442,20897,26917,27058,23746,20994,26836,23987,21613,27611,21269,27676,27935,17580,26800,22730,26786,22560,23819,27184,23883,29140,22322,27338,26763,26484,23892,30628,29213,29770,26887,26594,23701,16684,22619,32163,31041,5945,34132,29338,31201,28114,31548,25497,25498,27091,15029,30225,26155,34570,29845,36405,28536,28511,36956) AND d.code_franceinter IS NOT NULL
SELECT count(p0_.idpodcast) AS sclr_0 FROM podcasts p0_ INNER JOIN podcast_contact p2_ ON p0_.idpodcast = p2_.idpodcast INNER JOIN contacts c1_ ON c1_.idcontact = p2_.idcontact WHERE c1_.idcontact = ?
SELECT COUNT(DISTINCT(spectacles.`idspectacle`)) as total  FROM schedules, spectacles  JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle`  JOIN object_content ON spectacle_contact.`idspectacle`=object_content.`idobject`
                           JOIN contents ON contents.`idcontent`=object_content.`idcontent`
                           JOIN content_classification ON contents.`idcontent`=content_classification.`idcontent`  WHERE schedules.idspectacle=spectacles.idspectacle
                AND spectacles.publish=1
                AND (schedules.idcontact=536 OR schedules.idcontact_festival=536)
                AND contents.`publish`=1
                AND contents.`valid`=1
                AND object_content.`object`='spectacles'
                AND content_classification.`idclassification` IN (125)
SELECT COUNT(DISTINCT(spectacles.`idspectacle`)) as total  FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle`  JOIN object_content ON spectacle_contact.`idspectacle`=object_content.`idobject`
                           JOIN contents ON contents.`idcontent`=object_content.`idcontent`
                           JOIN content_classification ON contents.`idcontent`=content_classification.`idcontent`  WHERE  spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=536 OR spectacles.`idcontact_production`=536) AND spectacle_contact.`idrole` IN (17,18,19)
                AND contents.`publish`=1
                AND contents.`valid`=1
                AND object_content.`object`='spectacles'
                AND content_classification.`idclassification` IN (125)
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND contacts=1 AND lagarce!=1 AND is_public IN (1)
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='536'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (112,168,33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(DISTINCT(idperson)) 
                FROM person_ecole WHERE 1  AND idcontact=536
SELECT t0.idstat AS idstat_1, t0.type AS type_2, t0.module AS module_3, t0.url AS url_4, t0.idcontent AS idcontent_5, t0.object AS object_6, t0.idobject AS idobject_7, t0.video AS video_8, t0.remote_addr AS remote_addr_9, t0.lng AS lng_10, t0.source AS source_11, t0.md5url AS md5url_12, t0.dateinsert AS dateinsert_13 FROM stats t0 WHERE t0.remote_addr = ? AND t0.idcontent = ? AND t0.md5url = ?
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
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
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

0 Hits
0 Misses
0 Puts
Entities Mapping

Class	Mapping errors
TheatreCore\Entity\Extranetusers	No errors.
TheatreCore\Entity\Contacts	No errors.
TheatreCore\Entity\Contents	No errors.
TheatreCore\Entity\Multimedias	No errors.
TheatreCore\Entity\Countries	No errors.
TheatreCore\Entity\Typesstructures	No errors.
TheatreCore\Entity\Persons	No errors.
TheatreCore\Entity\Files	No errors.
TheatreCore\Entity\Classifications	No errors.
TheatreCore\Entity\Aides	No errors.
TheatreCore\Entity\Spectacles	No errors.
TheatreCore\Entity\Texts	No errors.
TheatreCore\Entity\Typesspectacles	No errors.
TheatreCore\Entity\Schedules	No errors.
TheatreCore\Entity\TextAide	No errors.
TheatreCore\Entity\SpectacleAide	No errors.
TheatreCore\Entity\News	No errors.
TheatreCore\Entity\Podcasts	No errors.
TheatreCore\Entity\ContactAide	No errors.
TheatreCore\Entity\Contactsaisons	No errors.
TheatreCore\Entity\Regions	No errors.
TheatreCore\Entity\Exports	No errors.
TheatreCore\Entity\Messages	No errors.
TheatreCore\Entity\SpectacleContact	No errors.
TheatreCore\Entity\Typesmultimedias	No errors.
TheatreCore\Entity\Dvds	No errors.
TheatreCore\Entity\Keywords	No errors.
TheatreCore\Entity\Playlists	No errors.
TheatreCore\Entity\ObjectMultimedia	No errors.
TheatreCore\Entity\Spectaclegenres	No errors.
TheatreCore\Entity\PersonAide	No errors.
TheatreCore\Entity\PersonEcole	The referenced column name 'idcontact' has to be a primary key column on the target entity class 'TheatreCore\Entity\PersonEcole'. The referenced column name 'idcontact' has to be a primary key column on the target entity class 'TheatreCore\Entity\PersonEcole'.
TheatreCore\Entity\BookmarkExtranetuser	No errors.
TheatreCore\Entity\Stats	No errors.
TheatreCore\Entity\Bannieres	No errors.
Symfony Profiler

https://preprod.theatre-contemporain.net/contacts/Theatre-de-Cornouaille/?path=contacts%2FTheatre-de-Cornouaille%2F

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
