81.57 ms (34.12%)
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` = 21785 OR spectacles . `idcontact_production` = 21785 ) 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` = 21785 OR spectacles . `idcontact_production` = 21785 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 );
Copy
71.97 ms (30.11%)
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 (21785 ) 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 (21785 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC ;
Copy
11.27 ms (4.72%)
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` = 21785 OR spectacles . `idcontact_production` = 21785 ) 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` = 21785 OR spectacles . `idcontact_production` = 21785 ) 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
9.11 ms (3.81%)
41
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = '2279' ;
Copy
6.72 ms (2.81%)
41
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 = '155' ;
Copy
5.26 ms (2.20%)
41
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 :
[
"Prix-jeune-public-de-la-Bibliotheque-A-Gatti "
]
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 = 'Prix-jeune-public-de-la-Bibliotheque-A-Gatti' ;
Copy
4.03 ms (1.69%)
41
SELECT DISTINCT (aides . idaide ), aides . *
FROM `contacts` ,
`text_aide` ,
`aides`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 21785 AND aides . `type_aide` IN (2 ) AND aides . `idaidecontact` = 104 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` = 21785 AND aides . `type_aide` IN (2 ) AND aides . `idaidecontact` = 104 AND aides . `idcontact` = contacts . `idcontact` AND aides . `idaide` = text_aide . `idaide`
GROUP BY aides . idaide
ORDER BY aides . dateinsert
DESC
LIMIT 0 , 100 ;
Copy
3.87 ms (1.62%)
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 (37081 , 38714 , 38912 , 35575 , 32450 , 36233 , 27586 , 27573 , 18737 , 27382 , 25229 , 27177 , 15008 , 20338 , 17084 , 17857 , 13732 , 13734 , 10486 , 10128 , 23710 , 16331 , 23709 , 6911 , 6290 , 6361 , 7277 , 23708 , 23707 , 3230 , 23706 , 23705 , 2960 , 3878 , 2279 , 4540 , 2291 , 8090 , 3757 , 8329 , 532 ) 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 (
37081 , 38714 , 38912 , 35575 , 32450 , 36233 ,
27586 , 27573 , 18737 , 27382 , 25229 ,
27177 , 15008 , 20338 , 17084 , 17857 ,
13732 , 13734 , 10486 , 10128 , 23710 ,
16331 , 23709 , 6911 , 6290 , 6361 , 7277 ,
23708 , 23707 , 3230 , 23706 , 23705 , 2960 ,
3878 , 2279 , 4540 , 2291 , 8090 , 3757 ,
8329 , 532
)
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 (37081 , 38714 , 38912 , 35575 , 32450 , 36233 , 27586 , 27573 , 18737 , 27382 , 25229 , 27177 , 15008 , 20338 , 17084 , 17857 , 13732 , 13734 , 10486 , 10128 , 23710 , 16331 , 23709 , 6911 , 6290 , 6361 , 7277 , 23708 , 23707 , 3230 , 23706 , 23705 , 2960 , 3878 , 2279 , 4540 , 2291 , 8090 , 3757 , 8329 , 532 ) GROUP BY T1 . idtext ORDER BY CAST (CONCAT (T1 . `publication_year` , '-' , T1 . `publication_month` , '-00' ) AS DATE ) ASC ;
Copy
2.12 ms (0.89%)
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` = 21785 AND aides . `type_aide` IN (2 ) 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` = 21785 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 400 ;
Copy
2.02 ms (0.85%)
41
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
2.01 ms (0.84%)
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` = 21785 OR spectacles . `idcontact_production` = 21785 ) 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` = 21785 OR spectacles . `idcontact_production` = 21785 ) AND spectacle_contact . `idrole` = 77 ;
Copy
1.71 ms (0.71%)
1
SELECT aidecontacts . * , aides . *
FROM `aides` ,
`text_aide` ,
`aidecontacts`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `idcontact` = 21785 AND aides . `type_aide` IN (2 ) 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` = 21785 AND aides . `type_aide` IN (2 ) 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.53 ms (0.64%)
1
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/contacts/Prix-jeune-public-de-la-Bibliotheque-A-Gatti/laureats "
"dcdc036b1183e0a95ed7b1a4a39da31e "
0
"contacts "
21785
0
"fr "
"c2dc7366c4228f40cd091dbd191d39f5-c8a0 "
"/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/Prix-jeune-public-de-la-Bibliotheque-A-Gatti/laureats' , 'dcdc036b1183e0a95ed7b1a4a39da31e' , 0 , 'contacts' , 21785 , 0 , 'fr' , 'c2dc7366c4228f40cd091dbd191d39f5-c8a0' , '/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829' );
Copy
1.22 ms (0.51%)
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 = '6290'
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 = '6290'
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.19 ms (0.50%)
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 = '27177'
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 = '27177'
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.49%)
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` = 21785 AND aides . `type_aide` IN (2 ) 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` = 21785 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = text_aide . `idaide`
;
Copy
1.12 ms (0.47%)
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 = '21785'
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 = '21785'
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.02 ms (0.43%)
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 = '21785'
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 = '21785'
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
0.90 ms (0.38%)
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 = 21785
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 = 21785
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.81 ms (0.34%)
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 = '21785'
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 = '21785'
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.69 ms (0.29%)
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.65 ms (0.27%)
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 = 3230 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 = 3230 ORDER BY j2 . classement ASC ;
Copy
0.63 ms (0.27%)
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 = 2279 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 = 2279 ORDER BY j2 . classement ASC ;
Copy
0.63 ms (0.27%)
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 = 3878 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 = 3878 ORDER BY j2 . classement ASC ;
Copy
0.63 ms (0.26%)
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` = 21785 AND aides . `type_aide` IN (2 ) 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` = 21785 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = spectacle_aide . `idaide`
;
Copy
0.63 ms (0.26%)
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 = 2291 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 = 2291 ORDER BY j2 . classement ASC ;
Copy
0.62 ms (0.26%)
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 = 23707 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 = 23707 ORDER BY j2 . classement ASC ;
Copy
0.59 ms (0.25%)
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` = 21785
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` = 21785 ;
Copy
0.57 ms (0.24%)
1
SELECT idcontact FROM contacts WHERE url_clean = 'Prix-jeune-public-de-la-Bibliotheque-A-Gatti'
SELECT idcontact FROM contacts WHERE url_clean = 'Prix-jeune-public-de-la-Bibliotheque-A-Gatti' ;
Copy
0.54 ms (0.23%)
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 = 21785 ) 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 = 21785 ) AND T1 . publish = 1 ;
Copy
0.54 ms (0.22%)
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 = 21785 ;
Copy
0.53 ms (0.22%)
1
SELECT COUNT (DISTINCT (spectacles . `idspectacle` )) as total FROM schedules , spectacles JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 21785 OR schedules . idcontact_festival = 21785 )
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 schedules , spectacles JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 21785 OR schedules . idcontact_festival = 21785 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 ) ;
Copy
0.53 ms (0.22%)
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` = 21785 AND aides . `type_aide` IN (2 ) 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` = 21785 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = text_aide . `idaide`
;
Copy
0.50 ms (0.21%)
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 = 27177 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 = 27177 ORDER BY j2 . classement ASC ;
Copy
0.47 ms (0.20%)
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 ) AND aides . `idcontact` IN (21785 ) 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 ) AND aides . `idcontact` IN (21785 ) HAVING annee < > 0
ORDER BY annee DESC ;
Copy
0.47 ms (0.20%)
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 = '21785'
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 = '21785'
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.47 ms (0.20%)
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 = 6289 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 = 6289 ORDER BY j2 . classement ASC ;
Copy
0.45 ms (0.19%)
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 = 21785
)
)
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 = 21785
)
);
Copy
0.44 ms (0.18%)
1
SELECT COUNT (DISTINCT (ct . `idcontent` ))
FROM schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND cc . `idclassification` = 101 AND (
sc . `idcontact` = 21785 OR sc . `idcontact_festival` = 21785
)
SELECT COUNT (DISTINCT (ct . `idcontent` ))
FROM schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND cc . `idclassification` = 101 AND (
sc . `idcontact` = 21785 OR sc . `idcontact_festival` = 21785
);
Copy
0.41 ms (0.17%)
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` = 21785 AND aides . `type_aide` IN (2 ) 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` = 21785 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = contact_aide . `idaide`
;
Copy
0.37 ms (0.15%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 21785 OR schedules . idcontact_festival = 21785 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 21785 OR schedules . idcontact_festival = 21785 );
Copy
0.36 ms (0.15%)
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` = 21785 AND aides . `type_aide` IN (2 ) 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` = 21785 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = person_aide . `idaide`
;
Copy
0.35 ms (0.15%)
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 = 10127 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 = 10127 ORDER BY j2 . classement ASC ;
Copy
0.34 ms (0.14%)
1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 3
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 3 ;
Copy
0.34 ms (0.14%)
1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 2 ;
Copy
0.33 ms (0.14%)
1
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 21785 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` = 21785 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.33 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 = 8329 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 = 8329 ORDER BY j2 . classement ASC ;
Copy
0.33 ms (0.14%)
2
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 6290
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 6290
ORDER BY t . title ;
Copy
0.33 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 = 18736 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 = 18736 ORDER BY j2 . classement ASC ;
Copy
0.33 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 = 6361 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 = 6361 ORDER BY j2 . classement ASC ;
Copy
0.30 ms (0.13%)
1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 2 ;
Copy
0.29 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 = 6911 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 = 6911 ORDER BY j2 . classement ASC ;
Copy
0.29 ms (0.12%)
1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 3
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 3 ;
Copy
0.28 ms (0.12%)
1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 1 ;
Copy
0.28 ms (0.12%)
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 = 21785 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 = 21785 AND j2 . idoffice = 1 ;
Copy
0.28 ms (0.12%)
1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 4
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 4 ;
Copy
0.28 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_translator j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 6290 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_translator j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 6290 ORDER BY j2 . classement ASC ;
Copy
0.28 ms (0.12%)
2
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 18737
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 18737
ORDER BY t . title ;
Copy
0.27 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 = 36233 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 = 36233 ORDER BY j2 . classement ASC ;
Copy
0.27 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_translator j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 18737 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_translator j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 18737 ORDER BY j2 . classement ASC ;
Copy
0.26 ms (0.11%)
1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 4
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 4 ;
Copy
0.26 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 = 37081 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 = 37081 ORDER BY j2 . classement ASC ;
Copy
0.26 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 = 4540 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 = 4540 ORDER BY j2 . classement ASC ;
Copy
0.26 ms (0.11%)
1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 1 ;
Copy
0.26 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 = 23710 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 = 23710 ORDER BY j2 . classement ASC ;
Copy
0.26 ms (0.11%)
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` = 21785 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` = 21785 AND aides . type_aide IN (1 ) ;
Copy
0.26 ms (0.11%)
1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 3
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 3 ;
Copy
0.26 ms (0.11%)
2
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 10128
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 10128
ORDER BY t . title ;
Copy
0.25 ms (0.11%)
1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 1 ;
Copy
0.25 ms (0.11%)
1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 4
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 4 ;
Copy
0.25 ms (0.11%)
1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 2 ;
Copy
0.24 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 = 23706 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 = 23706 ORDER BY j2 . classement ASC ;
Copy
0.23 ms (0.10%)
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 :
[
"c2dc7366c4228f40cd091dbd191d39f5-c8a0 "
0
"dcdc036b1183e0a95ed7b1a4a39da31e "
]
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 = 'c2dc7366c4228f40cd091dbd191d39f5-c8a0' AND t0 . idcontent = 0 AND t0 . md5url = 'dcdc036b1183e0a95ed7b1a4a39da31e' ;
Copy
0.23 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 = 13732 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 = 13732 ORDER BY j2 . classement ASC ;
Copy
0.23 ms (0.10%)
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` = 21785 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` = 21785 AND aides . type_aide IN (2 , 3 ) ;
Copy
0.23 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 = 23705 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 = 23705 ORDER BY j2 . classement ASC ;
Copy
0.23 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 = 7277 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 = 7277 ORDER BY j2 . classement ASC ;
Copy
0.23 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 = 532 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 = 532 ORDER BY j2 . classement ASC ;
Copy
0.23 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 = 8090 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 = 8090 ORDER BY j2 . classement ASC ;
Copy
0.23 ms (0.10%)
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 = 116604
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 = 116604 ;
Copy
0.23 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 = 23708 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 = 23708 ORDER BY j2 . classement ASC ;
Copy
0.22 ms (0.09%)
1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 3
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 3 ;
Copy
0.22 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 = 10486 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 = 10486 ORDER BY j2 . classement ASC ;
Copy
0.22 ms (0.09%)
1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 2 ;
Copy
0.22 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 = 16331 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 = 16331 ORDER BY j2 . classement ASC ;
Copy
0.21 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_translator j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 10128 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_translator j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 10128 ORDER BY j2 . classement ASC ;
Copy
0.21 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 = 32450 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 = 32450 ORDER BY j2 . classement ASC ;
Copy
0.21 ms (0.09%)
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 = 21785 ;
Copy
0.21 ms (0.09%)
1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 1 ;
Copy
0.21 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 = 13734 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 = 13734 ORDER BY j2 . classement ASC ;
Copy
0.21 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 = 17857 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 = 17857 ORDER BY j2 . classement ASC ;
Copy
0.21 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 = 17084 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 = 17084 ORDER BY j2 . classement ASC ;
Copy
0.21 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 = 2960 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 = 2960 ORDER BY j2 . classement ASC ;
Copy
0.21 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 = 35575 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 = 35575 ORDER BY j2 . classement ASC ;
Copy
0.21 ms (0.09%)
1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 4
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 21785
AND aides . `type_aide` = 4 ;
Copy
0.21 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 = 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.20 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 = 38912 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 = 38912 ORDER BY j2 . classement ASC ;
Copy
0.20 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 = 20338 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 = 20338 ORDER BY j2 . classement ASC ;
Copy
0.20 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 = 25229 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 = 25229 ORDER BY j2 . classement ASC ;
Copy
0.20 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 = 23709 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 = 23709 ORDER BY j2 . classement ASC ;
Copy
0.20 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 = 27586 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 = 27586 ORDER BY j2 . classement ASC ;
Copy
0.20 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 = 27382 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 = 27382 ORDER BY j2 . classement ASC ;
Copy
0.20 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 = 27573 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 = 27573 ORDER BY j2 . classement ASC ;
Copy
0.20 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 = 3757 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 = 3757 ORDER BY j2 . classement ASC ;
Copy
0.20 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 = 38714 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 = 38714 ORDER BY j2 . classement ASC ;
Copy
0.19 ms (0.08%)
1
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 21785
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 21785 ;
Copy
0.19 ms (0.08%)
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` = 21785 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` = 21785 AND aides . type_aide IN (4 ) ;
Copy
0.18 ms (0.07%)
4
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
0.15 ms (0.06%)
1
SELECT t0_ . idtypestructure AS idtypestructure_0 , t0_ . typestructure_pluriel AS typestructure_pluriel_1 , t0_ . typestructure AS typestructure_2 , t0_ . public_view AS public_view_3 , t0_ . order_view AS order_view_4 FROM typesstructures t0_ WHERE t0_ . idtypestructure = ?
SELECT t0_ . idtypestructure AS idtypestructure_0 , t0_ . typestructure_pluriel AS typestructure_pluriel_1 , t0_ . typestructure AS typestructure_2 , t0_ . public_view AS public_view_3 , t0_ . order_view AS order_view_4 FROM typesstructures t0_ WHERE t0_ . idtypestructure = 'LR' ;
Copy
0.07 ms (0.03%)
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.06 ms (0.02%)
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.05 ms (0.02%)
1
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
0.04 ms (0.02%)
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.04 ms (0.02%)
1
SELECT classification FROM classifications WHERE idclassification = 100
SELECT classification FROM classifications WHERE idclassification = 100 ;
Copy
0.04 ms (0.02%)
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.02%)
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