122.17 ms (22.35%)
1
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 = 18661 OR s0_ . idcontact_production = 18661 )) 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 = 18661 OR s0_ . idcontact_production = 18661 )) ORDER BY sclr_1 DESC ;
Copy
88.48 ms (16.19%)
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` = 18661 OR spectacles . `idcontact_production` = 18661 ) 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` = 18661 OR spectacles . `idcontact_production` = 18661 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 );
Copy
73.81 ms (13.50%)
1
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 (18661 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-04-20' 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 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 (18661 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-04-20' ORDER BY s1_ . date DESC ;
Copy
53.96 ms (9.87%)
1
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 (18661 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) 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 (18661 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC ;
Copy
19.19 ms (3.51%)
1
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 = 18661 OR s0_ . idcontact_production = 18661 )) 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 = 18661 OR s0_ . idcontact_production = 18661 )) ORDER BY sclr_1 DESC ;
Copy
18.79 ms (3.44%)
1
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-04-20' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 18661 OR s0_ . idcontact_production = 18661 )) 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 spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-20' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 18661 OR s0_ . idcontact_production = 18661 )) ORDER BY s1_ . date ASC ;
Copy
15.22 ms (2.78%)
1
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-04-20' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 18661 OR s0_ . idcontact_production = 18661 )) 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 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-04-20' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 18661 OR s0_ . idcontact_production = 18661 )) ORDER BY s1_ . date ASC ;
Copy
13.01 ms (2.38%)
71
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = '161' ;
Copy
12.30 ms (2.25%)
72
SELECT a0_ . idaide AS idaide_0 , a0_ . aide AS aide_1 , a0_ . type_aide AS type_aide_2 , a0_ . description AS description_3 , a0_ . mention_spectacles AS mention_spectacles_4 , a0_ . mention_texts AS mention_texts_5 , a0_ . mention_contacts AS mention_contacts_6 , a0_ . mention_persons AS mention_persons_7 , a0_ . url_clean AS url_clean_8 , a0_ . dateupdate AS dateupdate_9 , a0_ . dateinsert AS dateinsert_10 , a0_ . publish AS publish_11 , a1_ . idaidecontact AS idaidecontact_12 , a1_ . title AS title_13 , a1_ . description AS description_14 , a1_ . url_clean AS url_clean_15 , a1_ . dateupdate AS dateupdate_16 , a1_ . dateinsert AS dateinsert_17 , a1_ . publish AS publish_18 , c2_ . idcontact AS idcontact_19 , c2_ . type AS type_20 , c2_ . organisation AS organisation_21 , c2_ . nom_suite AS nom_suite_22 , c2_ . lastname AS lastname_23 , c2_ . firstname AS firstname_24 , c2_ . idtypestructure AS idtypestructure_25 , c2_ . license AS license_26 , c2_ . comment AS comment_27 , c2_ . private_comment AS private_comment_28 , c2_ . address1 AS address1_29 , c2_ . address2 AS address2_30 , c2_ . zip AS zip_31 , c2_ . city AS city_32 , c2_ . phone1 AS phone1_33 , c2_ . phone2 AS phone2_34 , c2_ . fax AS fax_35 , c2_ . email1 AS email1_36 , c2_ . email1_online AS email1_online_37 , c2_ . email2_online AS email2_online_38 , c2_ . email2 AS email2_39 , c2_ . url AS url_40 , c2_ . url_ticket AS url_ticket_41 , c2_ . facebook AS facebook_42 , c2_ . twitter AS twitter_43 , c2_ . instagram AS instagram_44 , c2_ . mobile AS mobile_45 , c2_ . geocodable AS geocodable_46 , c2_ . x AS x_47 , c2_ . y AS y_48 , c2_ . idmultimedia AS idmultimedia_49 , c2_ . type_view AS type_view_50 , c2_ . stats_access AS stats_access_51 , c2_ . ga_tracking_id AS ga_tracking_id_52 , c2_ . is_festival AS is_festival_53 , c2_ . link_on_video AS link_on_video_54 , c2_ . is_partenaire AS is_partenaire_55 , c2_ . valid_version AS valid_version_56 , c2_ . other_versions AS other_versions_57 , c2_ . url_redirect AS url_redirect_58 , c2_ . url_clean AS url_clean_59 , c2_ . dateupdate AS dateupdate_60 , c2_ . dateinsert AS dateinsert_61 , c2_ . publish AS publish_62 , c2_ . valid AS valid_63 FROM aides a0_ LEFT JOIN aidecontacts a1_ ON a0_ . idaidecontact = a1_ . idaidecontact LEFT JOIN contacts c2_ ON a0_ . idcontact = c2_ . idcontact WHERE a0_ . idaide = ?
SELECT
a0_ . idaide AS idaide_0 ,
a0_ . aide AS aide_1 ,
a0_ . type_aide AS type_aide_2 ,
a0_ . description AS description_3 ,
a0_ . mention_spectacles AS mention_spectacles_4 ,
a0_ . mention_texts AS mention_texts_5 ,
a0_ . mention_contacts AS mention_contacts_6 ,
a0_ . mention_persons AS mention_persons_7 ,
a0_ . url_clean AS url_clean_8 ,
a0_ . dateupdate AS dateupdate_9 ,
a0_ . dateinsert AS dateinsert_10 ,
a0_ . publish AS publish_11 ,
a1_ . idaidecontact AS idaidecontact_12 ,
a1_ . title AS title_13 ,
a1_ . description AS description_14 ,
a1_ . url_clean AS url_clean_15 ,
a1_ . dateupdate AS dateupdate_16 ,
a1_ . dateinsert AS dateinsert_17 ,
a1_ . publish AS publish_18 ,
c2_ . idcontact AS idcontact_19 ,
c2_ . type AS type_20 ,
c2_ . organisation AS organisation_21 ,
c2_ . nom_suite AS nom_suite_22 ,
c2_ . lastname AS lastname_23 ,
c2_ . firstname AS firstname_24 ,
c2_ . idtypestructure AS idtypestructure_25 ,
c2_ . license AS license_26 ,
c2_ . comment AS comment_27 ,
c2_ . private_comment AS private_comment_28 ,
c2_ . address1 AS address1_29 ,
c2_ . address2 AS address2_30 ,
c2_ . zip AS zip_31 ,
c2_ . city AS city_32 ,
c2_ . phone1 AS phone1_33 ,
c2_ . phone2 AS phone2_34 ,
c2_ . fax AS fax_35 ,
c2_ . email1 AS email1_36 ,
c2_ . email1_online AS email1_online_37 ,
c2_ . email2_online AS email2_online_38 ,
c2_ . email2 AS email2_39 ,
c2_ . url AS url_40 ,
c2_ . url_ticket AS url_ticket_41 ,
c2_ . facebook AS facebook_42 ,
c2_ . twitter AS twitter_43 ,
c2_ . instagram AS instagram_44 ,
c2_ . mobile AS mobile_45 ,
c2_ . geocodable AS geocodable_46 ,
c2_ . x AS x_47 ,
c2_ . y AS y_48 ,
c2_ . idmultimedia AS idmultimedia_49 ,
c2_ . type_view AS type_view_50 ,
c2_ . stats_access AS stats_access_51 ,
c2_ . ga_tracking_id AS ga_tracking_id_52 ,
c2_ . is_festival AS is_festival_53 ,
c2_ . link_on_video AS link_on_video_54 ,
c2_ . is_partenaire AS is_partenaire_55 ,
c2_ . valid_version AS valid_version_56 ,
c2_ . other_versions AS other_versions_57 ,
c2_ . url_redirect AS url_redirect_58 ,
c2_ . url_clean AS url_clean_59 ,
c2_ . dateupdate AS dateupdate_60 ,
c2_ . dateinsert AS dateinsert_61 ,
c2_ . publish AS publish_62 ,
c2_ . valid AS valid_63
FROM
aides a0_
LEFT JOIN aidecontacts a1_ ON a0_ . idaidecontact = a1_ . idaidecontact
LEFT JOIN contacts c2_ ON a0_ . idcontact = c2_ . idcontact
WHERE
a0_ . idaide = ?
Copy
SELECT a0_ . idaide AS idaide_0 , a0_ . aide AS aide_1 , a0_ . type_aide AS type_aide_2 , a0_ . description AS description_3 , a0_ . mention_spectacles AS mention_spectacles_4 , a0_ . mention_texts AS mention_texts_5 , a0_ . mention_contacts AS mention_contacts_6 , a0_ . mention_persons AS mention_persons_7 , a0_ . url_clean AS url_clean_8 , a0_ . dateupdate AS dateupdate_9 , a0_ . dateinsert AS dateinsert_10 , a0_ . publish AS publish_11 , a1_ . idaidecontact AS idaidecontact_12 , a1_ . title AS title_13 , a1_ . description AS description_14 , a1_ . url_clean AS url_clean_15 , a1_ . dateupdate AS dateupdate_16 , a1_ . dateinsert AS dateinsert_17 , a1_ . publish AS publish_18 , c2_ . idcontact AS idcontact_19 , c2_ . type AS type_20 , c2_ . organisation AS organisation_21 , c2_ . nom_suite AS nom_suite_22 , c2_ . lastname AS lastname_23 , c2_ . firstname AS firstname_24 , c2_ . idtypestructure AS idtypestructure_25 , c2_ . license AS license_26 , c2_ . comment AS comment_27 , c2_ . private_comment AS private_comment_28 , c2_ . address1 AS address1_29 , c2_ . address2 AS address2_30 , c2_ . zip AS zip_31 , c2_ . city AS city_32 , c2_ . phone1 AS phone1_33 , c2_ . phone2 AS phone2_34 , c2_ . fax AS fax_35 , c2_ . email1 AS email1_36 , c2_ . email1_online AS email1_online_37 , c2_ . email2_online AS email2_online_38 , c2_ . email2 AS email2_39 , c2_ . url AS url_40 , c2_ . url_ticket AS url_ticket_41 , c2_ . facebook AS facebook_42 , c2_ . twitter AS twitter_43 , c2_ . instagram AS instagram_44 , c2_ . mobile AS mobile_45 , c2_ . geocodable AS geocodable_46 , c2_ . x AS x_47 , c2_ . y AS y_48 , c2_ . idmultimedia AS idmultimedia_49 , c2_ . type_view AS type_view_50 , c2_ . stats_access AS stats_access_51 , c2_ . ga_tracking_id AS ga_tracking_id_52 , c2_ . is_festival AS is_festival_53 , c2_ . link_on_video AS link_on_video_54 , c2_ . is_partenaire AS is_partenaire_55 , c2_ . valid_version AS valid_version_56 , c2_ . other_versions AS other_versions_57 , c2_ . url_redirect AS url_redirect_58 , c2_ . url_clean AS url_clean_59 , c2_ . dateupdate AS dateupdate_60 , c2_ . dateinsert AS dateinsert_61 , c2_ . publish AS publish_62 , c2_ . valid AS valid_63 FROM aides a0_ LEFT JOIN aidecontacts a1_ ON a0_ . idaidecontact = a1_ . idaidecontact LEFT JOIN contacts c2_ ON a0_ . idcontact = c2_ . idcontact WHERE a0_ . idaide = '63' ;
Copy
9.35 ms (1.71%)
72
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_ . url_clean = ?
Parameters :
[
"Les-Molieres-18661 "
]
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_ . url_clean = ?
Copy
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_ . url_clean = 'Les-Molieres-18661' ;
Copy
9.11 ms (1.67%)
1
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` = 18661 OR spectacles . `idcontact_production` = 18661 ) 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 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` = 18661 OR spectacles . `idcontact_production` = 18661 ) 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 ) ;
Copy
6.14 ms (1.12%)
1
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 s0_ . idspectacle IN (20572 , 25851 , 26667 , 27891 , 28561 , 27091 , 2840 , 4870 , 5328 , 5710 , 7735 , 14727 , 15292 , 17393 , 23999 , 31278 , 27 , 800 , 1216 , 1403 , 3307 , 4083 , 4106 , 4307 , 4528 , 5081 , 5206 , 5334 , 5379 , 8323 , 8388 , 8423 , 8623 , 10410 , 10918 , 10990 , 12551 , 14586 , 15279 , 16932 , 17511 , 17656 , 17988 , 20215 , 21315 , 21720 , 23997 , 26603 , 26850 , 31041 , 31106 , 1243 , 3301 , 12778 , 22344 , 28597 , 9329 , 13532 , 17635 , 17644 , 17645 , 20377 , 23875 , 24067 , 29300 , 29301 , 29856 , 17979 , 20372 , 20371 , 23686 , 25347 , 27923 , 26003 , 11720 , 20571 , 24269 , 29859 , 17580 , 21204 , 21207 , 22262 , 24271 , 24337 , 24754 , 25223 , 27995 , 28521 , 29302 , 31096 , 33702 , 18183 , 19792 , 21071 , 1029 , 8507 , 25923 , 32215 , 26389 ) AND s1_ . date > = '2024-04-20' 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 s0_ . idspectacle IN (
20572 , 25851 , 26667 , 27891 , 28561 , 27091 ,
2840 , 4870 , 5328 , 5710 , 7735 , 14727 ,
15292 , 17393 , 23999 , 31278 , 27 , 800 ,
1216 , 1403 , 3307 , 4083 , 4106 , 4307 ,
4528 , 5081 , 5206 , 5334 , 5379 , 8323 ,
8388 , 8423 , 8623 , 10410 , 10918 , 10990 ,
12551 , 14586 , 15279 , 16932 , 17511 ,
17656 , 17988 , 20215 , 21315 , 21720 ,
23997 , 26603 , 26850 , 31041 , 31106 ,
1243 , 3301 , 12778 , 22344 , 28597 , 9329 ,
13532 , 17635 , 17644 , 17645 , 20377 ,
23875 , 24067 , 29300 , 29301 , 29856 ,
17979 , 20372 , 20371 , 23686 , 25347 ,
27923 , 26003 , 11720 , 20571 , 24269 ,
29859 , 17580 , 21204 , 21207 , 22262 ,
24271 , 24337 , 24754 , 25223 , 27995 ,
28521 , 29302 , 31096 , 33702 , 18183 ,
19792 , 21071 , 1029 , 8507 , 25923 , 32215 ,
26389
)
AND s1_ . date > = '2024-04-20'
ORDER BY
s1_ . date ASC
Copy
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 s0_ . idspectacle IN (20572 , 25851 , 26667 , 27891 , 28561 , 27091 , 2840 , 4870 , 5328 , 5710 , 7735 , 14727 , 15292 , 17393 , 23999 , 31278 , 27 , 800 , 1216 , 1403 , 3307 , 4083 , 4106 , 4307 , 4528 , 5081 , 5206 , 5334 , 5379 , 8323 , 8388 , 8423 , 8623 , 10410 , 10918 , 10990 , 12551 , 14586 , 15279 , 16932 , 17511 , 17656 , 17988 , 20215 , 21315 , 21720 , 23997 , 26603 , 26850 , 31041 , 31106 , 1243 , 3301 , 12778 , 22344 , 28597 , 9329 , 13532 , 17635 , 17644 , 17645 , 20377 , 23875 , 24067 , 29300 , 29301 , 29856 , 17979 , 20372 , 20371 , 23686 , 25347 , 27923 , 26003 , 11720 , 20571 , 24269 , 29859 , 17580 , 21204 , 21207 , 22262 , 24271 , 24337 , 24754 , 25223 , 27995 , 28521 , 29302 , 31096 , 33702 , 18183 , 19792 , 21071 , 1029 , 8507 , 25923 , 32215 , 26389 ) AND s1_ . date > = '2024-04-20' ORDER BY s1_ . date ASC ;
Copy
5.77 ms (1.06%)
1
SELECT DISTINCT (T1 . `idtext` ), T1 . `title` , T1 . `url_clean` , T1 . `publication_year` , T1 . `publication_month` , T1 . `isbn` , T1 . `textfictif` , T1 . `dateinsert` , T1 . `textorder` , T1 . `type` , T1 . `publish` , T1 . `statut` , T1 . `valid` , T2 . `idcontact` , T2 . `url_clean` as `url_clean_publisher` , T2 . `organisation` ,
CONCAT (T1 . `publication_year` , T1 . `publication_month` ) AS publication_date ,
CAST (CONCAT (T1 . `publication_year` , T1 . `publication_month` ) AS DATE ) AS publication_date_full FROM texts T1
LEFT JOIN contacts T2 ON T2 . `idcontact` = T1 . `idcontact_publisher` WHERE 1 AND T1 . `idtext` IN (33691 , 34683 , 37401 , 41214 , 41215 , 41218 , 22833 , 29528 , 29697 , 31101 , 31726 , 32904 , 25262 , 25326 , 26702 , 24966 , 25486 , 17058 , 20636 , 22344 , 22430 , 25485 , 15008 , 15940 , 18792 , 20447 , 21591 , 18813 , 7086 , 11622 , 14996 , 16311 , 20110 , 2253 , 7275 , 9639 , 11773 , 12861 , 16997 , 3102 , 6348 , 6351 , 20111 , 20112 , 2671 , 3501 , 6086 , 20114 , 8502 , 4124 , 4385 , 6432 , 8201 , 9953 , 5119 , 3424 , 9144 , 20115 , 3745 , 20113 , 1200 , 8097 , 1219 , 2929 , 4585 , 161 , 2928 , 14372 , 4737 , 16542 , 166 ) GROUP BY T1 . idtext ORDER BY CAST (CONCAT (T1 . `publication_year` , '-' , T1 . `publication_month` , '-00' ) AS DATE ) ASC
SELECT
DISTINCT (T1 . `idtext` ),
T1 . `title` ,
T1 . `url_clean` ,
T1 . `publication_year` ,
T1 . `publication_month` ,
T1 . `isbn` ,
T1 . `textfictif` ,
T1 . `dateinsert` ,
T1 . `textorder` ,
T1 . `type` ,
T1 . `publish` ,
T1 . `statut` ,
T1 . `valid` ,
T2 . `idcontact` ,
T2 . `url_clean` as `url_clean_publisher` ,
T2 . `organisation` ,
CONCAT (
T1 . `publication_year` , T1 . `publication_month`
) AS publication_date ,
CAST (
CONCAT (
T1 . `publication_year` , T1 . `publication_month`
) AS DATE
) AS publication_date_full
FROM
texts T1
LEFT JOIN contacts T2 ON T2 . `idcontact` = T1 . `idcontact_publisher`
WHERE
1
AND T1 . `idtext` IN (
33691 , 34683 , 37401 , 41214 , 41215 , 41218 ,
22833 , 29528 , 29697 , 31101 , 31726 ,
32904 , 25262 , 25326 , 26702 , 24966 ,
25486 , 17058 , 20636 , 22344 , 22430 ,
25485 , 15008 , 15940 , 18792 , 20447 ,
21591 , 18813 , 7086 , 11622 , 14996 , 16311 ,
20110 , 2253 , 7275 , 9639 , 11773 , 12861 ,
16997 , 3102 , 6348 , 6351 , 20111 , 20112 ,
2671 , 3501 , 6086 , 20114 , 8502 , 4124 ,
4385 , 6432 , 8201 , 9953 , 5119 , 3424 ,
9144 , 20115 , 3745 , 20113 , 1200 , 8097 ,
1219 , 2929 , 4585 , 161 , 2928 , 14372 ,
4737 , 16542 , 166
)
GROUP BY
T1 . idtext
ORDER BY
CAST (
CONCAT (
T1 . `publication_year` , '-' , T1 . `publication_month` ,
'-00'
) AS DATE
) ASC
Copy
SELECT DISTINCT (T1 . `idtext` ), T1 . `title` , T1 . `url_clean` , T1 . `publication_year` , T1 . `publication_month` , T1 . `isbn` , T1 . `textfictif` , T1 . `dateinsert` , T1 . `textorder` , T1 . `type` , T1 . `publish` , T1 . `statut` , T1 . `valid` , T2 . `idcontact` , T2 . `url_clean` as `url_clean_publisher` , T2 . `organisation` ,
CONCAT (T1 . `publication_year` , T1 . `publication_month` ) AS publication_date ,
CAST (CONCAT (T1 . `publication_year` , T1 . `publication_month` ) AS DATE ) AS publication_date_full FROM texts T1
LEFT JOIN contacts T2 ON T2 . `idcontact` = T1 . `idcontact_publisher` WHERE 1 AND T1 . `idtext` IN (33691 , 34683 , 37401 , 41214 , 41215 , 41218 , 22833 , 29528 , 29697 , 31101 , 31726 , 32904 , 25262 , 25326 , 26702 , 24966 , 25486 , 17058 , 20636 , 22344 , 22430 , 25485 , 15008 , 15940 , 18792 , 20447 , 21591 , 18813 , 7086 , 11622 , 14996 , 16311 , 20110 , 2253 , 7275 , 9639 , 11773 , 12861 , 16997 , 3102 , 6348 , 6351 , 20111 , 20112 , 2671 , 3501 , 6086 , 20114 , 8502 , 4124 , 4385 , 6432 , 8201 , 9953 , 5119 , 3424 , 9144 , 20115 , 3745 , 20113 , 1200 , 8097 , 1219 , 2929 , 4585 , 161 , 2928 , 14372 , 4737 , 16542 , 166 ) GROUP BY T1 . idtext ORDER BY CAST (CONCAT (T1 . `publication_year` , '-' , T1 . `publication_month` , '-00' ) AS DATE ) ASC ;
Copy
5.60 ms (1.02%)
72
SELECT DISTINCT (aides . idaide ), aides . *
FROM `contacts` ,
`text_aide` ,
`aides`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaidecontact` = 33 AND aides . `idcontact` = contacts . `idcontact` AND aides . `idaide` = text_aide . `idaide`
GROUP BY aides . idaide
ORDER BY aides . dateinsert
DESC
LIMIT 0 , 100
SELECT DISTINCT (aides . idaide ), aides . *
FROM `contacts` ,
`text_aide` ,
`aides`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaidecontact` = 33 AND aides . `idcontact` = contacts . `idcontact` AND aides . `idaide` = text_aide . `idaide`
GROUP BY aides . idaide
ORDER BY aides . dateinsert
DESC
LIMIT 0 , 100 ;
Copy
4.99 ms (0.91%)
1
SELECT text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 400
SELECT text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 400 ;
Copy
4.36 ms (0.80%)
72
SELECT a0_ . idaidecontact AS idaidecontact_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . url_clean AS url_clean_3 , a0_ . dateupdate AS dateupdate_4 , a0_ . dateinsert AS dateinsert_5 , a0_ . publish AS publish_6 FROM aidecontacts a0_ WHERE a0_ . idaidecontact = ?
SELECT a0_ . idaidecontact AS idaidecontact_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . url_clean AS url_clean_3 , a0_ . dateupdate AS dateupdate_4 , a0_ . dateinsert AS dateinsert_5 , a0_ . publish AS publish_6 FROM aidecontacts a0_ WHERE a0_ . idaidecontact = NULL ;
Copy
3.70 ms (0.68%)
1
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s0_ . idspectacle IN (20572 , 25851 , 26667 , 27891 , 28561 , 27091 , 2840 , 4870 , 5328 , 5710 , 7735 , 14727 , 15292 , 17393 , 23999 , 31278 , 27 , 800 , 1216 , 1403 , 3307 , 4083 , 4106 , 4307 , 4528 , 5081 , 5206 , 5334 , 5379 , 8323 , 8388 , 8423 , 8623 , 10410 , 10918 , 10990 , 12551 , 14586 , 15279 , 16932 , 17511 , 17656 , 17988 , 20215 , 21315 , 21720 , 23997 , 26603 , 26850 , 31041 , 31106 , 1243 , 3301 , 12778 , 22344 , 28597 , 9329 , 13532 , 17635 , 17644 , 17645 , 20377 , 23875 , 24067 , 29300 , 29301 , 29856 , 17979 , 20372 , 20371 , 23686 , 25347 , 27923 , 26003 , 11720 , 20571 , 24269 , 29859 , 17580 , 21204 , 21207 , 22262 , 24271 , 24337 , 24754 , 25223 , 27995 , 28521 , 29302 , 31096 , 33702 , 18183 , 19792 , 21071 , 1029 , 8507 , 25923 , 32215 , 26389 ) AND s1_ . date > = '2024-04-20' ORDER BY s1_ . date ASC
SELECT
COUNT (
DISTINCT (s0_ . idspectacle )
) AS sclr_0 ,
MIN (s1_ . date ) AS sclr_1
FROM
spectacles s0_
LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle
LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext
LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle
LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle
LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle
LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson
INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact
WHERE
s1_ . idspectacle = s0_ . idspectacle
AND (
s1_ . idcontact = c7_ . idcontact
OR s1_ . idcontact_festival = c7_ . idcontact
)
AND s0_ . idspectacle IN (
20572 , 25851 , 26667 , 27891 , 28561 , 27091 ,
2840 , 4870 , 5328 , 5710 , 7735 , 14727 ,
15292 , 17393 , 23999 , 31278 , 27 , 800 ,
1216 , 1403 , 3307 , 4083 , 4106 , 4307 ,
4528 , 5081 , 5206 , 5334 , 5379 , 8323 ,
8388 , 8423 , 8623 , 10410 , 10918 , 10990 ,
12551 , 14586 , 15279 , 16932 , 17511 ,
17656 , 17988 , 20215 , 21315 , 21720 ,
23997 , 26603 , 26850 , 31041 , 31106 ,
1243 , 3301 , 12778 , 22344 , 28597 , 9329 ,
13532 , 17635 , 17644 , 17645 , 20377 ,
23875 , 24067 , 29300 , 29301 , 29856 ,
17979 , 20372 , 20371 , 23686 , 25347 ,
27923 , 26003 , 11720 , 20571 , 24269 ,
29859 , 17580 , 21204 , 21207 , 22262 ,
24271 , 24337 , 24754 , 25223 , 27995 ,
28521 , 29302 , 31096 , 33702 , 18183 ,
19792 , 21071 , 1029 , 8507 , 25923 , 32215 ,
26389
)
AND s1_ . date > = '2024-04-20'
ORDER BY
s1_ . date ASC
Copy
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s0_ . idspectacle IN (20572 , 25851 , 26667 , 27891 , 28561 , 27091 , 2840 , 4870 , 5328 , 5710 , 7735 , 14727 , 15292 , 17393 , 23999 , 31278 , 27 , 800 , 1216 , 1403 , 3307 , 4083 , 4106 , 4307 , 4528 , 5081 , 5206 , 5334 , 5379 , 8323 , 8388 , 8423 , 8623 , 10410 , 10918 , 10990 , 12551 , 14586 , 15279 , 16932 , 17511 , 17656 , 17988 , 20215 , 21315 , 21720 , 23997 , 26603 , 26850 , 31041 , 31106 , 1243 , 3301 , 12778 , 22344 , 28597 , 9329 , 13532 , 17635 , 17644 , 17645 , 20377 , 23875 , 24067 , 29300 , 29301 , 29856 , 17979 , 20372 , 20371 , 23686 , 25347 , 27923 , 26003 , 11720 , 20571 , 24269 , 29859 , 17580 , 21204 , 21207 , 22262 , 24271 , 24337 , 24754 , 25223 , 27995 , 28521 , 29302 , 31096 , 33702 , 18183 , 19792 , 21071 , 1029 , 8507 , 25923 , 32215 , 26389 ) AND s1_ . date > = '2024-04-20' ORDER BY s1_ . date ASC ;
Copy
2.80 ms (0.51%)
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` = 18661 OR spectacles . `idcontact_production` = 18661 ) AND spectacle_contact . `idrole` = 77
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 18661 OR spectacles . `idcontact_production` = 18661 ) AND spectacle_contact . `idrole` = 77 ;
Copy
2.55 ms (0.47%)
18
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_couv' ))) AND texts = 1 ;
Copy
2.54 ms (0.46%)
1
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 (18661 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-04-20' AND '2024-04-23' )) 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 (18661 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-04-20' AND '2024-04-23' )) ORDER BY s1_ . date ASC ;
Copy
2.19 ms (0.40%)
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 = '18661'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (100 ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '18661'
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 ;
Copy
1.66 ms (0.30%)
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 (20572 , 25851 , 26667 , 27891 , 28561 , 27091 , 2840 , 4870 , 5328 , 5710 , 7735 , 14727 , 15292 , 17393 , 23999 , 31278 , 27 , 800 , 1216 , 1403 , 3307 , 4083 , 4106 , 4307 , 4528 , 5081 , 5206 , 5334 , 5379 , 8323 , 8388 , 8423 , 8623 , 10410 , 10918 , 10990 , 12551 , 14586 , 15279 , 16932 , 17511 , 17656 , 17988 , 20215 , 21315 , 21720 , 23997 , 26603 , 26850 , 31041 , 31106 , 1243 , 3301 , 12778 , 22344 , 28597 , 9329 , 13532 , 17635 , 17644 , 17645 , 20377 , 23875 , 24067 , 29300 , 29301 , 29856 , 17979 , 20372 , 20371 , 23686 , 25347 , 27923 , 26003 , 11720 , 20571 , 24269 , 29859 , 17580 , 21204 , 21207 , 22262 , 24271 , 24337 , 24754 , 25223 , 27995 , 28521 , 29302 , 31096 , 33702 , 18183 , 19792 , 21071 , 1029 , 8507 , 25923 , 32215 , 26389 ) AND d . code_franceinter IS NOT NULL
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 (
20572 , 25851 , 26667 , 27891 , 28561 , 27091 ,
2840 , 4870 , 5328 , 5710 , 7735 , 14727 ,
15292 , 17393 , 23999 , 31278 , 27 , 800 ,
1216 , 1403 , 3307 , 4083 , 4106 , 4307 ,
4528 , 5081 , 5206 , 5334 , 5379 , 8323 ,
8388 , 8423 , 8623 , 10410 , 10918 , 10990 ,
12551 , 14586 , 15279 , 16932 , 17511 ,
17656 , 17988 , 20215 , 21315 , 21720 ,
23997 , 26603 , 26850 , 31041 , 31106 ,
1243 , 3301 , 12778 , 22344 , 28597 , 9329 ,
13532 , 17635 , 17644 , 17645 , 20377 ,
23875 , 24067 , 29300 , 29301 , 29856 ,
17979 , 20372 , 20371 , 23686 , 25347 ,
27923 , 26003 , 11720 , 20571 , 24269 ,
29859 , 17580 , 21204 , 21207 , 22262 ,
24271 , 24337 , 24754 , 25223 , 27995 ,
28521 , 29302 , 31096 , 33702 , 18183 ,
19792 , 21071 , 1029 , 8507 , 25923 , 32215 ,
26389
)
AND d . code_franceinter IS NOT NULL
Copy
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 (20572 , 25851 , 26667 , 27891 , 28561 , 27091 , 2840 , 4870 , 5328 , 5710 , 7735 , 14727 , 15292 , 17393 , 23999 , 31278 , 27 , 800 , 1216 , 1403 , 3307 , 4083 , 4106 , 4307 , 4528 , 5081 , 5206 , 5334 , 5379 , 8323 , 8388 , 8423 , 8623 , 10410 , 10918 , 10990 , 12551 , 14586 , 15279 , 16932 , 17511 , 17656 , 17988 , 20215 , 21315 , 21720 , 23997 , 26603 , 26850 , 31041 , 31106 , 1243 , 3301 , 12778 , 22344 , 28597 , 9329 , 13532 , 17635 , 17644 , 17645 , 20377 , 23875 , 24067 , 29300 , 29301 , 29856 , 17979 , 20372 , 20371 , 23686 , 25347 , 27923 , 26003 , 11720 , 20571 , 24269 , 29859 , 17580 , 21204 , 21207 , 22262 , 24271 , 24337 , 24754 , 25223 , 27995 , 28521 , 29302 , 31096 , 33702 , 18183 , 19792 , 21071 , 1029 , 8507 , 25923 , 32215 , 26389 ) AND d . code_franceinter IS NOT NULL ;
Copy
1.62 ms (0.30%)
2
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 = '29697'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '29697'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
1.59 ms (0.29%)
1
SELECT aidecontacts . * , aides . *
FROM `aides` ,
`text_aide` ,
`aidecontacts`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `aide` ! = '' AND aides . `idaidecontact` = aidecontacts . `idaidecontact` AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 100
SELECT aidecontacts . * , aides . *
FROM `aides` ,
`text_aide` ,
`aidecontacts`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `aide` ! = '' AND aides . `idaidecontact` = aidecontacts . `idaidecontact` AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 100 ;
Copy
1.47 ms (0.27%)
1
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 text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = text_aide . `idaide`
SELECT COUNT (DISTINCT (text_aide . idtextaide )) as total , text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = text_aide . `idaide`
;
Copy
1.19 ms (0.22%)
2
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 = '31726'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31726'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
1.17 ms (0.21%)
1
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/contacts/Les-Molieres-18661/nominations/type/text "
"d0c0b347154d3bb0aab3505db3f9e63a "
0
"contacts "
18661
0
"fr "
"0f8ad9a3cf5befe957ffd75a9deac953-78ff "
"/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829 "
]
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES ('article' , 'thnet' , '/contacts/Les-Molieres-18661/nominations/type/text' , 'd0c0b347154d3bb0aab3505db3f9e63a' , 0 , 'contacts' , 18661 , 0 , 'fr' , '0f8ad9a3cf5befe957ffd75a9deac953-78ff' , '/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829' );
Copy
1.17 ms (0.21%)
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` = 18661 AND aides . type_aide IN (4 )
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` = 18661 AND aides . type_aide IN (4 ) ;
Copy
1.15 ms (0.21%)
1
SELECT DISTINCT YEAR (text_aide . `date_start` ) AS idannee , YEAR (text_aide . `date_start` ) as annee
FROM text_aide
JOIN aides ON text_aide . `idaide` = aides . `idaide`
WHERE 1 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idcontact` IN (18661 ) HAVING annee < > 0
ORDER BY annee DESC
SELECT DISTINCT YEAR (text_aide . `date_start` ) AS idannee , YEAR (text_aide . `date_start` ) as annee
FROM text_aide
JOIN aides ON text_aide . `idaide` = aides . `idaide`
WHERE 1 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idcontact` IN (18661 ) HAVING annee < > 0
ORDER BY annee DESC ;
Copy
1.14 ms (0.21%)
2
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 = '20110'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '20110'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
1.13 ms (0.21%)
2
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 = '20111'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '20111'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
1.13 ms (0.21%)
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 = '18661'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_presentation_structure' ))) ORDER BY c . `range` , c . idcontent
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '18661'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_presentation_structure' ))) ORDER BY c . `range` , c . idcontent ;
Copy
1.10 ms (0.20%)
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` = 18661
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` = 18661 ;
Copy
1.07 ms (0.20%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 18661 OR schedules . idcontact_festival = 18661 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 18661 OR schedules . idcontact_festival = 18661 );
Copy
1.05 ms (0.19%)
1
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` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = spectacle_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` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = spectacle_aide . `idaide`
;
Copy
1.02 ms (0.19%)
1
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 = 18661 ) AND T1 . publish = 1
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 = 18661 ) AND T1 . publish = 1 ;
Copy
1.01 ms (0.18%)
2
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 = '25326'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '25326'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
1.00 ms (0.18%)
2
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 = '33691'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '33691'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
0.97 ms (0.18%)
1
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 = 18661 ) ORDER BY s1_ . date DESC
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 = 18661 ) ORDER BY s1_ . date DESC ;
Copy
0.95 ms (0.17%)
2
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 = '22430'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '22430'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
0.93 ms (0.17%)
2
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 = '20447'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '20447'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
0.93 ms (0.17%)
2
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 = '41218'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '41218'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
0.92 ms (0.17%)
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` = 18661 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` = 18661 AND aides . type_aide IN (2 , 3 ) ;
Copy
0.90 ms (0.16%)
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 = '18661'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '18661'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent ;
Copy
0.89 ms (0.16%)
1
SELECT c0_ . idcontact AS idcontact_0 , c0_ . type AS type_1 , c0_ . organisation AS organisation_2 , c0_ . nom_suite AS nom_suite_3 , c0_ . lastname AS lastname_4 , c0_ . firstname AS firstname_5 , c0_ . idtypestructure AS idtypestructure_6 , c0_ . license AS license_7 , c0_ . comment AS comment_8 , c0_ . private_comment AS private_comment_9 , c0_ . address1 AS address1_10 , c0_ . address2 AS address2_11 , c0_ . zip AS zip_12 , c0_ . city AS city_13 , c0_ . phone1 AS phone1_14 , c0_ . phone2 AS phone2_15 , c0_ . fax AS fax_16 , c0_ . email1 AS email1_17 , c0_ . email1_online AS email1_online_18 , c0_ . email2_online AS email2_online_19 , c0_ . email2 AS email2_20 , c0_ . url AS url_21 , c0_ . url_ticket AS url_ticket_22 , c0_ . facebook AS facebook_23 , c0_ . twitter AS twitter_24 , c0_ . instagram AS instagram_25 , c0_ . mobile AS mobile_26 , c0_ . geocodable AS geocodable_27 , c0_ . x AS x_28 , c0_ . y AS y_29 , c0_ . idmultimedia AS idmultimedia_30 , c0_ . type_view AS type_view_31 , c0_ . stats_access AS stats_access_32 , c0_ . ga_tracking_id AS ga_tracking_id_33 , c0_ . is_festival AS is_festival_34 , c0_ . link_on_video AS link_on_video_35 , c0_ . is_partenaire AS is_partenaire_36 , c0_ . valid_version AS valid_version_37 , c0_ . other_versions AS other_versions_38 , c0_ . url_redirect AS url_redirect_39 , c0_ . url_clean AS url_clean_40 , c0_ . dateupdate AS dateupdate_41 , c0_ . dateinsert AS dateinsert_42 , c0_ . publish AS publish_43 , c0_ . valid AS valid_44 , c1_ . id AS id_45 , c1_ . fr AS fr_46 , c1_ . en AS en_47 , c1_ . es AS es_48 , c1_ . pt AS pt_49 , c1_ . de AS de_50 , c1_ . ru AS ru_51 , c1_ . orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_ . country = c1_ . id WHERE c0_ . idcontact = ?
SELECT
c0_ . idcontact AS idcontact_0 ,
c0_ . type AS type_1 ,
c0_ . organisation AS organisation_2 ,
c0_ . nom_suite AS nom_suite_3 ,
c0_ . lastname AS lastname_4 ,
c0_ . firstname AS firstname_5 ,
c0_ . idtypestructure AS idtypestructure_6 ,
c0_ . license AS license_7 ,
c0_ . comment AS comment_8 ,
c0_ . private_comment AS private_comment_9 ,
c0_ . address1 AS address1_10 ,
c0_ . address2 AS address2_11 ,
c0_ . zip AS zip_12 ,
c0_ . city AS city_13 ,
c0_ . phone1 AS phone1_14 ,
c0_ . phone2 AS phone2_15 ,
c0_ . fax AS fax_16 ,
c0_ . email1 AS email1_17 ,
c0_ . email1_online AS email1_online_18 ,
c0_ . email2_online AS email2_online_19 ,
c0_ . email2 AS email2_20 ,
c0_ . url AS url_21 ,
c0_ . url_ticket AS url_ticket_22 ,
c0_ . facebook AS facebook_23 ,
c0_ . twitter AS twitter_24 ,
c0_ . instagram AS instagram_25 ,
c0_ . mobile AS mobile_26 ,
c0_ . geocodable AS geocodable_27 ,
c0_ . x AS x_28 ,
c0_ . y AS y_29 ,
c0_ . idmultimedia AS idmultimedia_30 ,
c0_ . type_view AS type_view_31 ,
c0_ . stats_access AS stats_access_32 ,
c0_ . ga_tracking_id AS ga_tracking_id_33 ,
c0_ . is_festival AS is_festival_34 ,
c0_ . link_on_video AS link_on_video_35 ,
c0_ . is_partenaire AS is_partenaire_36 ,
c0_ . valid_version AS valid_version_37 ,
c0_ . other_versions AS other_versions_38 ,
c0_ . url_redirect AS url_redirect_39 ,
c0_ . url_clean AS url_clean_40 ,
c0_ . dateupdate AS dateupdate_41 ,
c0_ . dateinsert AS dateinsert_42 ,
c0_ . publish AS publish_43 ,
c0_ . valid AS valid_44 ,
c1_ . id AS id_45 ,
c1_ . fr AS fr_46 ,
c1_ . en AS en_47 ,
c1_ . es AS es_48 ,
c1_ . pt AS pt_49 ,
c1_ . de AS de_50 ,
c1_ . ru AS ru_51 ,
c1_ . orderby AS orderby_52
FROM
contacts c0_
LEFT JOIN countries c1_ ON c0_ . country = c1_ . id
WHERE
c0_ . idcontact = ?
Copy
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 = 18661 ;
Copy
0.84 ms (0.15%)
1
SELECT idcontact FROM contacts WHERE url_clean = 'Les-Molieres-18661'
SELECT idcontact FROM contacts WHERE url_clean = 'Les-Molieres-18661' ;
Copy
0.81 ms (0.15%)
1
SELECT * FROM bannieres
WHERE publish = 1
AND valid = 1
AND is_bottom = 1
AND date_start < = NOW()
AND date_end > = NOW()
ORDER BY bannieres . order ASC
LIMIT 0 , 10
SELECT * FROM bannieres
WHERE publish = 1
AND valid = 1
AND is_bottom = 1
AND date_start < = NOW()
AND date_end > = NOW()
ORDER BY bannieres . order ASC
LIMIT 0 , 10 ;
Copy
0.79 ms (0.14%)
1
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 = 3745 ORDER BY j2 . classement ASC
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 = 3745 ORDER BY j2 . classement ASC ;
Copy
0.79 ms (0.14%)
1
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 = 161 ORDER BY j2 . classement ASC
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 = 161 ORDER BY j2 . classement ASC ;
Copy
0.78 ms (0.14%)
1
SELECT COUNT (p . idplaylist )
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
LEFT JOIN aides a ON a . idcontact = 18661
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 (p . idplaylist )
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
LEFT JOIN aides a ON a . idcontact = 18661
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 ;
Copy
0.76 ms (0.14%)
1
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-04-20' AND (s0_ . publish = 1 AND s1_ . idcontact = 18661 ) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-20' AND (s0_ . publish = 1 AND s1_ . idcontact = 18661 ) ORDER BY s1_ . date ASC ;
Copy
0.73 ms (0.13%)
1
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` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = text_aide . `idaide`
SELECT COUNT (DISTINCT (text_aide . idtextaide )) as total , text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = text_aide . `idaide`
;
Copy
0.70 ms (0.13%)
1
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 = 20111 ORDER BY j2 . classement ASC
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 = 20111 ORDER BY j2 . classement ASC ;
Copy
0.69 ms (0.13%)
1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . idclassification IN (100 ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . idclassification IN (100 ))) AND contacts = 1 ;
Copy
0.69 ms (0.13%)
1
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 = 18661 )) 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 (77 ) AND s8_ . idcontact = 18661 )) ORDER BY sclr_1 DESC ;
Copy
0.68 ms (0.12%)
1
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 = 25262 ORDER BY j2 . classement ASC
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 = 25262 ORDER BY j2 . classement ASC ;
Copy
0.68 ms (0.12%)
1
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 = 9953 ORDER BY j2 . classement ASC
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 = 9953 ORDER BY j2 . classement ASC ;
Copy
0.67 ms (0.12%)
1
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 = 14996 ORDER BY j2 . classement ASC
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 = 14996 ORDER BY j2 . classement ASC ;
Copy
0.64 ms (0.12%)
1
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-04-20' AND (s0_ . publish = 1 AND s1_ . idcontact = 18661 ) 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-04-20' AND (s0_ . publish = 1 AND s1_ . idcontact = 18661 ) ORDER BY s1_ . date ASC ;
Copy
0.62 ms (0.11%)
1
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 = 2928 ORDER BY j2 . classement ASC
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 = 2928 ORDER BY j2 . classement ASC ;
Copy
0.59 ms (0.11%)
1
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 = 2929 ORDER BY j2 . classement ASC
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 = 2929 ORDER BY j2 . classement ASC ;
Copy
0.58 ms (0.11%)
1
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 = 1219 ORDER BY j2 . classement ASC
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 = 1219 ORDER BY j2 . classement ASC ;
Copy
0.58 ms (0.11%)
1
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 = 1200 ORDER BY j2 . classement ASC
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 = 1200 ORDER BY j2 . classement ASC ;
Copy
0.57 ms (0.10%)
1
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 = 29697 ORDER BY j2 . classement ASC
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 = 29697 ORDER BY j2 . classement ASC ;
Copy
0.56 ms (0.10%)
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 = '18661'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 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 (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 = '18661'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 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 ;
Copy
0.55 ms (0.10%)
1
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 18661 AND podcasts . `code_ft` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `is_integrale` = 1 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 18661 AND podcasts . `code_ft` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `is_integrale` = 1 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
;
Copy
0.55 ms (0.10%)
1
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 = 18661 )) 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 (77 ) AND s8_ . idcontact = 18661 )) ORDER BY sclr_1 DESC ;
Copy
0.54 ms (0.10%)
1
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 = 18661 AND j2 . idoffice = 1
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 = 18661 AND j2 . idoffice = 1 ;
Copy
0.53 ms (0.10%)
1
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 = 22344 ORDER BY j2 . classement ASC
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 = 22344 ORDER BY j2 . classement ASC ;
Copy
0.53 ms (0.10%)
1
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 = 16311 ORDER BY j2 . classement ASC
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 = 16311 ORDER BY j2 . classement ASC ;
Copy
0.52 ms (0.09%)
1
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 = 3501 ORDER BY j2 . classement ASC
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 = 3501 ORDER BY j2 . classement ASC ;
Copy
0.51 ms (0.09%)
1
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 = ?
Parameters :
[
"0f8ad9a3cf5befe957ffd75a9deac953-78ff "
0
"d0c0b347154d3bb0aab3505db3f9e63a "
]
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 = '0f8ad9a3cf5befe957ffd75a9deac953-78ff' AND t0 . idcontent = 0 AND t0 . md5url = 'd0c0b347154d3bb0aab3505db3f9e63a' ;
Copy
0.49 ms (0.09%)
1
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 = 6086 ORDER BY j2 . classement ASC
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 = 6086 ORDER BY j2 . classement ASC ;
Copy
0.48 ms (0.09%)
1
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 = 9639 ORDER BY j2 . classement ASC
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 = 9639 ORDER BY j2 . classement ASC ;
Copy
0.48 ms (0.09%)
2
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' )
AND object_multimedia . idobject = 18661
)
)
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' )
AND object_multimedia . idobject = 18661
)
);
Copy
0.48 ms (0.09%)
1
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 = 18661 ) ORDER BY s1_ . date DESC
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 = 18661 ) ORDER BY s1_ . date DESC ;
Copy
0.46 ms (0.08%)
1
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 = 20447 ORDER BY j2 . classement ASC
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 = 20447 ORDER BY j2 . classement ASC ;
Copy
0.46 ms (0.08%)
1
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 61233
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idcontent FROM theatreok_dev . classifications j1 , theatreok_dev . content_classification j2 , theatreok_dev . contents j3
WHERE j3 . idcontent = j2 . idcontent
AND j1 . idclassification = j2 . idclassification
AND j3 . idcontent = 61233 ;
Copy
0.46 ms (0.08%)
1
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 = 4585 ORDER BY j2 . classement ASC
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 = 4585 ORDER BY j2 . classement ASC ;
Copy
0.44 ms (0.08%)
1
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 = 3102 ORDER BY j2 . classement ASC
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 = 3102 ORDER BY j2 . classement ASC ;
Copy
0.44 ms (0.08%)
1
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 = 18792 ORDER BY j2 . classement ASC
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 = 18792 ORDER BY j2 . classement ASC ;
Copy
0.43 ms (0.08%)
1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 2 ;
Copy
0.43 ms (0.08%)
1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 3
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 3 ;
Copy
0.43 ms (0.08%)
1
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 = 16997 ORDER BY j2 . classement ASC
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 = 16997 ORDER BY j2 . classement ASC ;
Copy
0.43 ms (0.08%)
1
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 = 32904 ORDER BY j2 . classement ASC
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 = 32904 ORDER BY j2 . classement ASC ;
Copy
0.42 ms (0.08%)
1
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 = 17058 ORDER BY j2 . classement ASC
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 = 17058 ORDER BY j2 . classement ASC ;
Copy
0.42 ms (0.08%)
1
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 = 4385 ORDER BY j2 . classement ASC
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 = 4385 ORDER BY j2 . classement ASC ;
Copy
0.41 ms (0.07%)
1
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 = 2671 ORDER BY j2 . classement ASC
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 = 2671 ORDER BY j2 . classement ASC ;
Copy
0.40 ms (0.07%)
1
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 = 31101 ORDER BY j2 . classement ASC
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 = 31101 ORDER BY j2 . classement ASC ;
Copy
0.40 ms (0.07%)
1
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 = 11622 ORDER BY j2 . classement ASC
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 = 11622 ORDER BY j2 . classement ASC ;
Copy
0.39 ms (0.07%)
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` = 18661 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` = 18661 AND aides . type_aide IN (1 ) ;
Copy
0.38 ms (0.07%)
1
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 = 11773 ORDER BY j2 . classement ASC
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 = 11773 ORDER BY j2 . classement ASC ;
Copy
0.38 ms (0.07%)
1
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 = 20112 ORDER BY j2 . classement ASC
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 = 20112 ORDER BY j2 . classement ASC ;
Copy
0.38 ms (0.07%)
1
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 = 15940 ORDER BY j2 . classement ASC
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 = 15940 ORDER BY j2 . classement ASC ;
Copy
0.38 ms (0.07%)
1
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 = 18813 ORDER BY j2 . classement ASC
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 = 18813 ORDER BY j2 . classement ASC ;
Copy
0.38 ms (0.07%)
1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 2 ;
Copy
0.37 ms (0.07%)
1
SELECT classification FROM classifications WHERE idclassification = 100
SELECT classification FROM classifications WHERE idclassification = 100 ;
Copy
0.36 ms (0.07%)
1
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 = 34683 ORDER BY j2 . classement ASC
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 = 34683 ORDER BY j2 . classement ASC ;
Copy
0.36 ms (0.07%)
1
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 = 20110 ORDER BY j2 . classement ASC
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 = 20110 ORDER BY j2 . classement ASC ;
Copy
0.35 ms (0.06%)
1
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 = 4737 ORDER BY j2 . classement ASC
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 = 4737 ORDER BY j2 . classement ASC ;
Copy
0.35 ms (0.06%)
1
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 = 14372 ORDER BY j2 . classement ASC
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 = 14372 ORDER BY j2 . classement ASC ;
Copy
0.34 ms (0.06%)
1
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` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = contact_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` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = contact_aide . `idaide`
;
Copy
0.34 ms (0.06%)
1
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 = 4124 ORDER BY j2 . classement ASC
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 = 4124 ORDER BY j2 . classement ASC ;
Copy
0.34 ms (0.06%)
1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 3
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 3 ;
Copy
0.33 ms (0.06%)
1
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 = 25486 ORDER BY j2 . classement ASC
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 = 25486 ORDER BY j2 . classement ASC ;
Copy
0.33 ms (0.06%)
1
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 = 24966 ORDER BY j2 . classement ASC
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 = 24966 ORDER BY j2 . classement ASC ;
Copy
0.33 ms (0.06%)
1
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 = 20115 ORDER BY j2 . classement ASC
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 = 20115 ORDER BY j2 . classement ASC ;
Copy
0.33 ms (0.06%)
1
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 = 2253 ORDER BY j2 . classement ASC
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 = 2253 ORDER BY j2 . classement ASC ;
Copy
0.33 ms (0.06%)
1
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 = 22833 ORDER BY j2 . classement ASC
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 = 22833 ORDER BY j2 . classement ASC ;
Copy
0.33 ms (0.06%)
1
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 = 26702 ORDER BY j2 . classement ASC
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 = 26702 ORDER BY j2 . classement ASC ;
Copy
0.33 ms (0.06%)
1
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 = 21591 ORDER BY j2 . classement ASC
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 = 21591 ORDER BY j2 . classement ASC ;
Copy
0.32 ms (0.06%)
1
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 = 8502 ORDER BY j2 . classement ASC
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 = 8502 ORDER BY j2 . classement ASC ;
Copy
0.32 ms (0.06%)
1
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 = 7086 ORDER BY j2 . classement ASC
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 = 7086 ORDER BY j2 . classement ASC ;
Copy
0.32 ms (0.06%)
1
SELECT DISTINCT (aides . idaide ), aides . *
FROM `contacts` ,
`aides`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaidecontact` = 106 AND aides . `idcontact` = contacts . `idcontact`
GROUP BY aides . idaide
ORDER BY aides . dateinsert
DESC
LIMIT 0 , 10
SELECT DISTINCT (aides . idaide ), aides . *
FROM `contacts` ,
`aides`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaidecontact` = 106 AND aides . `idcontact` = contacts . `idcontact`
GROUP BY aides . idaide
ORDER BY aides . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.31 ms (0.06%)
1
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 = 22430 ORDER BY j2 . classement ASC
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 = 22430 ORDER BY j2 . classement ASC ;
Copy
0.31 ms (0.06%)
1
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 (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 = 18661 ;
Copy
0.29 ms (0.05%)
1
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 contacts = 1 AND lagarce ! = 1 AND is_public IN (1 ) ;
Copy
0.29 ms (0.05%)
1
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 = 6351 ORDER BY j2 . classement ASC
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 = 6351 ORDER BY j2 . classement ASC ;
Copy
0.28 ms (0.05%)
1
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 = 166 ORDER BY j2 . classement ASC
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 = 166 ORDER BY j2 . classement ASC ;
Copy
0.27 ms (0.05%)
1
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 = 41215 ORDER BY j2 . classement ASC
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 = 41215 ORDER BY j2 . classement ASC ;
Copy
0.27 ms (0.05%)
1
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 = 41218 ORDER BY j2 . classement ASC
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 = 41218 ORDER BY j2 . classement ASC ;
Copy
0.27 ms (0.05%)
1
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 = 29528 ORDER BY j2 . classement ASC
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 = 29528 ORDER BY j2 . classement ASC ;
Copy
0.27 ms (0.05%)
1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 3
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 3 ;
Copy
0.27 ms (0.05%)
1
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 = 16542 ORDER BY j2 . classement ASC
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 = 16542 ORDER BY j2 . classement ASC ;
Copy
0.26 ms (0.05%)
1
SELECT COUNT (DISTINCT (person_aide . idpersonaide )) as total , person_aide . * , aides . *
FROM `aides` ,
`person_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = person_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` = 18661 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = person_aide . `idaide`
;
Copy
0.26 ms (0.05%)
1
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 = 9144 ORDER BY j2 . classement ASC
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 = 9144 ORDER BY j2 . classement ASC ;
Copy
0.26 ms (0.05%)
1
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 = 6348 ORDER BY j2 . classement ASC
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 = 6348 ORDER BY j2 . classement ASC ;
Copy
0.26 ms (0.05%)
1
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 = 12861 ORDER BY j2 . classement ASC
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 = 12861 ORDER BY j2 . classement ASC ;
Copy
0.25 ms (0.05%)
1
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 = 20636 ORDER BY j2 . classement ASC
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 = 20636 ORDER BY j2 . classement ASC ;
Copy
0.25 ms (0.05%)
1
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 = 41214 ORDER BY j2 . classement ASC
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 = 41214 ORDER BY j2 . classement ASC ;
Copy
0.25 ms (0.05%)
1
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 = 25485 ORDER BY j2 . classement ASC
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 = 25485 ORDER BY j2 . classement ASC ;
Copy
0.25 ms (0.05%)
1
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 = 31726 ORDER BY j2 . classement ASC
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 = 31726 ORDER BY j2 . classement ASC ;
Copy
0.25 ms (0.05%)
1
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 = 25326 ORDER BY j2 . classement ASC
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 = 25326 ORDER BY j2 . classement ASC ;
Copy
0.24 ms (0.04%)
1
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 = 7275 ORDER BY j2 . classement ASC
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 = 7275 ORDER BY j2 . classement ASC ;
Copy
0.24 ms (0.04%)
1
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 = 3424 ORDER BY j2 . classement ASC
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 = 3424 ORDER BY j2 . classement ASC ;
Copy
0.23 ms (0.04%)
1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 1 ;
Copy
0.22 ms (0.04%)
1
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 = 15008 ORDER BY j2 . classement ASC
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 = 15008 ORDER BY j2 . classement ASC ;
Copy
0.22 ms (0.04%)
1
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 = 33691 ORDER BY j2 . classement ASC
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 = 33691 ORDER BY j2 . classement ASC ;
Copy
0.22 ms (0.04%)
1
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 = 8201 ORDER BY j2 . classement ASC
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 = 8201 ORDER BY j2 . classement ASC ;
Copy
0.21 ms (0.04%)
1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 2 ;
Copy
0.21 ms (0.04%)
1
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 = 6432 ORDER BY j2 . classement ASC
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 = 6432 ORDER BY j2 . classement ASC ;
Copy
0.21 ms (0.04%)
1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 3
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 3 ;
Copy
0.21 ms (0.04%)
1
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 = 20114 ORDER BY j2 . classement ASC
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 = 20114 ORDER BY j2 . classement ASC ;
Copy
0.21 ms (0.04%)
1
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 = 20113 ORDER BY j2 . classement ASC
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 = 20113 ORDER BY j2 . classement ASC ;
Copy
0.20 ms (0.04%)
1
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 = 37401 ORDER BY j2 . classement ASC
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 = 37401 ORDER BY j2 . classement ASC ;
Copy
0.20 ms (0.04%)
1
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 18661
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 18661 ;
Copy
0.19 ms (0.03%)
1
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 = 8097 ORDER BY j2 . classement ASC
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 = 8097 ORDER BY j2 . classement ASC ;
Copy
0.19 ms (0.03%)
1
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 = 5119 ORDER BY j2 . classement ASC
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 = 5119 ORDER BY j2 . classement ASC ;
Copy
0.18 ms (0.03%)
1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 1 ;
Copy
0.17 ms (0.03%)
1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 2 ;
Copy
0.16 ms (0.03%)
1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 1 ;
Copy
0.15 ms (0.03%)
1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 1 ;
Copy
0.15 ms (0.03%)
1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 4
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 4 ;
Copy
0.14 ms (0.03%)
1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 4
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 4 ;
Copy
0.14 ms (0.03%)
1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 4
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 4 ;
Copy
0.12 ms (0.02%)
1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 4
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 18661
AND aides . `type_aide` = 4 ;
Copy
0.06 ms (0.01%)
1
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
0.05 ms (0.01%)
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 idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND spectacles = 1 AND lagarce ! = 1 AND is_public IN (1 ) ;
Copy
0.04 ms (0.01%)
1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_article' ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_article' ))) AND contacts = 1 ;
Copy
0.03 ms (0.01%)
1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_presentation_structure' ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_presentation_structure' ))) AND contacts = 1 ;
Copy