1
0.41 ms
SELECT idcontact FROM contacts WHERE url_clean = 'Scene-2'
SELECT idcontact FROM contacts WHERE url_clean = 'Scene-2' ;
Copy
2
1.03 ms
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 = 16359 ;
Copy
3
0.15 ms
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
4
0.46 ms
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 = 'SP' ;
Copy
5
0.68 ms
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 = 16359 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 = 16359 AND j2 . idoffice = 1 ;
Copy
6
0.09 ms
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
7
2.28 ms
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 = '16359'
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 = '16359'
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
8
0.06 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_pp' ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_pp' ))) AND contacts = 1 ;
Copy
9
1.91 ms
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 = '16359'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND ((cl . classification IN ('class_pp' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
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 = '16359'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND ((cl . classification IN ('class_pp' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
10
0.55 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 16359 OR schedules . idcontact_festival = 16359 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 16359 OR schedules . idcontact_festival = 16359 );
Copy
11
64.21 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 16359 OR spectacles . `idcontact_production` = 16359 ) 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` = 16359 OR spectacles . `idcontact_production` = 16359 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 );
Copy
12
1.38 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 16359 OR spectacles . `idcontact_production` = 16359 ) 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` = 16359 OR spectacles . `idcontact_production` = 16359 ) AND spectacle_contact . `idrole` = 77 ;
Copy
13
0.22 ms
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` = 16359
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` = 16359 ;
Copy
14
0.18 ms
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` = 16359 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` = 16359 AND aides . type_aide IN (2 , 3 ) ;
Copy
15
0.18 ms
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` = 16359 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` = 16359 AND aides . type_aide IN (1 ) ;
Copy
16
0.16 ms
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` = 16359 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` = 16359 AND aides . type_aide IN (4 ) ;
Copy
17
5.06 ms
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (13597 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 16359
)
)
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (13597 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 16359
)
);
Copy
18
2.43 ms
SELECT DISTINCT (files . idfile ), files . * , file_classification . * , typesfiles . * , object_file . * , contacts . `url_clean` , contacts . `organisation` , contacts . `nom_suite` , contacts . `city`
FROM `files` ,
`file_classification` ,
`typesfiles` ,
`object_file` ,
`contacts`
WHERE 1 AND files . `publish` = 1 AND object_file . `object` = 'contacts' AND file_classification . `idclassification` IN (112 ) AND contacts . `idcontact` = 16359 AND ( (files . `date_start` = '2023-09-01' AND files . `date_end` = '2024-08-31' ) ) AND files . `idfile` = object_file . `idfile` AND typesfiles . `idtype` = files . `idtype` AND file_classification . `idfile` = files . `idfile` AND object_file . `idobject` = contacts . `idcontact`
GROUP BY files . idfile
ORDER BY files . dateinsert
DESC
LIMIT 0 , 10
SELECT DISTINCT (files . idfile ), files . * , file_classification . * , typesfiles . * , object_file . * , contacts . `url_clean` , contacts . `organisation` , contacts . `nom_suite` , contacts . `city`
FROM `files` ,
`file_classification` ,
`typesfiles` ,
`object_file` ,
`contacts`
WHERE 1 AND files . `publish` = 1 AND object_file . `object` = 'contacts' AND file_classification . `idclassification` IN (112 ) AND contacts . `idcontact` = 16359 AND ( (files . `date_start` = '2023-09-01' AND files . `date_end` = '2024-08-31' ) ) AND files . `idfile` = object_file . `idfile` AND typesfiles . `idtype` = files . `idtype` AND file_classification . `idfile` = files . `idfile` AND object_file . `idobject` = contacts . `idcontact`
GROUP BY files . idfile
ORDER BY files . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
19
2.16 ms
SELECT DISTINCT (files . idfile ), files . * , file_classification . * , typesfiles . * , object_file . * , contacts . `url_clean` , contacts . `organisation` , contacts . `nom_suite` , contacts . `city`
FROM `files` ,
`file_classification` ,
`typesfiles` ,
`object_file` ,
`contacts`
WHERE 1 AND files . `publish` = 1 AND object_file . `object` = 'contacts' AND file_classification . `idclassification` IN (112 ) AND contacts . `idcontact` = 16359 AND files . `idfile` = object_file . `idfile` AND typesfiles . `idtype` = files . `idtype` AND file_classification . `idfile` = files . `idfile` AND object_file . `idobject` = contacts . `idcontact`
GROUP BY files . idfile
ORDER BY files . `date_end`
DESC
LIMIT 0 , 1
SELECT DISTINCT (files . idfile ), files . * , file_classification . * , typesfiles . * , object_file . * , contacts . `url_clean` , contacts . `organisation` , contacts . `nom_suite` , contacts . `city`
FROM `files` ,
`file_classification` ,
`typesfiles` ,
`object_file` ,
`contacts`
WHERE 1 AND files . `publish` = 1 AND object_file . `object` = 'contacts' AND file_classification . `idclassification` IN (112 ) AND contacts . `idcontact` = 16359 AND files . `idfile` = object_file . `idfile` AND typesfiles . `idtype` = files . `idtype` AND file_classification . `idfile` = files . `idfile` AND object_file . `idobject` = contacts . `idcontact`
GROUP BY files . idfile
ORDER BY files . `date_end`
DESC
LIMIT 0 , 1 ;
Copy
20
2.22 ms
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
INNER JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 16359 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date > = '2024-04-25' )) GROUP BY T1 . idnew ORDER BY T3 . date ASC LIMIT 0 , 5
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
INNER JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 16359 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date > = '2024-04-25' )) GROUP BY T1 . idnew ORDER BY T3 . date ASC LIMIT 0 , 5 ;
Copy
21
2.21 ms
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
INNER JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 16359 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date < '2024-04-25' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 5
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
INNER JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 16359 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date < '2024-04-25' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 5 ;
Copy
22
0.08 ms
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (? ) LIMIT 1
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (4 ) LIMIT 1 ;
Copy
23
0.25 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 17394 ;
Copy
24
0.29 ms
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 = 17394 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 = 17394 ORDER BY j2 . classement ASC ;
Copy
25
0.95 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 13597 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 13597 ORDER BY p . `lastname` ;
Copy
26
0.39 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 13597 AND r . type_creator = 1 ORDER BY sp . `classement`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 13597 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
27
1.55 ms
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = ? AND s0_ . date < ? GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1
Parameters :
[
13597
"2024-04-25 "
]
SELECT
MIN (s0_ . date ) AS sclr_0 ,
MAX (s0_ . date ) AS sclr_1 ,
s0_ . idschedule AS idschedule_2 ,
s0_ . date AS date_3 ,
s0_ . hour AS hour_4 ,
s0_ . is_creation AS is_creation_5 ,
s0_ . is_cancelled AS is_cancelled_6 ,
s0_ . idcontact_festival AS idcontact_festival_7 ,
s0_ . url_spectacle AS url_spectacle_8 ,
s0_ . url_booking AS url_booking_9 ,
s0_ . note AS note_10 ,
s0_ . dateupdate AS dateupdate_11 ,
s0_ . dateinsert AS dateinsert_12 ,
s0_ . publish AS publish_13 ,
s0_ . valid AS valid_14 ,
c1_ . idcontact AS idcontact_15 ,
c1_ . type AS type_16 ,
c1_ . organisation AS organisation_17 ,
c1_ . nom_suite AS nom_suite_18 ,
c1_ . lastname AS lastname_19 ,
c1_ . firstname AS firstname_20 ,
c1_ . idtypestructure AS idtypestructure_21 ,
c1_ . license AS license_22 ,
c1_ . comment AS comment_23 ,
c1_ . private_comment AS private_comment_24 ,
c1_ . address1 AS address1_25 ,
c1_ . address2 AS address2_26 ,
c1_ . zip AS zip_27 ,
c1_ . city AS city_28 ,
c1_ . phone1 AS phone1_29 ,
c1_ . phone2 AS phone2_30 ,
c1_ . fax AS fax_31 ,
c1_ . email1 AS email1_32 ,
c1_ . email1_online AS email1_online_33 ,
c1_ . email2_online AS email2_online_34 ,
c1_ . email2 AS email2_35 ,
c1_ . url AS url_36 ,
c1_ . url_ticket AS url_ticket_37 ,
c1_ . facebook AS facebook_38 ,
c1_ . twitter AS twitter_39 ,
c1_ . instagram AS instagram_40 ,
c1_ . mobile AS mobile_41 ,
c1_ . geocodable AS geocodable_42 ,
c1_ . x AS x_43 ,
c1_ . y AS y_44 ,
c1_ . idmultimedia AS idmultimedia_45 ,
c1_ . type_view AS type_view_46 ,
c1_ . stats_access AS stats_access_47 ,
c1_ . ga_tracking_id AS ga_tracking_id_48 ,
c1_ . is_festival AS is_festival_49 ,
c1_ . link_on_video AS link_on_video_50 ,
c1_ . is_partenaire AS is_partenaire_51 ,
c1_ . valid_version AS valid_version_52 ,
c1_ . other_versions AS other_versions_53 ,
c1_ . url_redirect AS url_redirect_54 ,
c1_ . url_clean AS url_clean_55 ,
c1_ . dateupdate AS dateupdate_56 ,
c1_ . dateinsert AS dateinsert_57 ,
c1_ . publish AS publish_58 ,
c1_ . valid AS valid_59 ,
s0_ . idspectacle AS idspectacle_60 ,
s0_ . idcontact AS idcontact_61 ,
s0_ . idextranetuser AS idextranetuser_62 ,
c1_ . country AS country_63 ,
c1_ . idextranetuser AS idextranetuser_64
FROM
schedules s0_
LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact
WHERE
s0_ . idspectacle = ?
AND s0_ . date < ?
GROUP BY
s0_ . idcontact
ORDER BY
s0_ . date DESC
LIMIT
1
Copy
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = 13597 AND s0_ . date < '2024-04-25' GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1 ;
Copy
28
0.37 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 13597
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 13597
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
29
0.22 ms
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` = 13597 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` = 13597 AND d . code_franceinter IS NOT NULL ;
Copy
30
0.04 ms
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
31
0.36 ms
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 = '13597'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (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 = '13597'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
32
0.30 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 13597 AND cc . idclassification = 6 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 13597 AND cc . idclassification = 6 LIMIT 1 ;
Copy
33
0.26 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 13597 AND cc . idclassification = 125 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 13597 AND cc . idclassification = 125 LIMIT 1 ;
Copy
34
0.24 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 13597 AND cc . idclassification = 101 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 13597 AND cc . idclassification = 101 LIMIT 1 ;
Copy
35
0.05 ms
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (? ) LIMIT 1
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (4 ) LIMIT 1 ;
Copy
36
0.04 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 35903 ;
Copy
37
0.04 ms
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 = 35903
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 = 35903
ORDER BY t . title ;
Copy
38
0.04 ms
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 = 33016 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 = 33016 ORDER BY j2 . classement ASC ;
Copy
39
0.05 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 ORDER BY p . `lastname` ;
Copy
40
1.90 ms
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = ? AND s0_ . date < ? GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1
Parameters :
[
33112
"2024-04-25 "
]
SELECT
MIN (s0_ . date ) AS sclr_0 ,
MAX (s0_ . date ) AS sclr_1 ,
s0_ . idschedule AS idschedule_2 ,
s0_ . date AS date_3 ,
s0_ . hour AS hour_4 ,
s0_ . is_creation AS is_creation_5 ,
s0_ . is_cancelled AS is_cancelled_6 ,
s0_ . idcontact_festival AS idcontact_festival_7 ,
s0_ . url_spectacle AS url_spectacle_8 ,
s0_ . url_booking AS url_booking_9 ,
s0_ . note AS note_10 ,
s0_ . dateupdate AS dateupdate_11 ,
s0_ . dateinsert AS dateinsert_12 ,
s0_ . publish AS publish_13 ,
s0_ . valid AS valid_14 ,
c1_ . idcontact AS idcontact_15 ,
c1_ . type AS type_16 ,
c1_ . organisation AS organisation_17 ,
c1_ . nom_suite AS nom_suite_18 ,
c1_ . lastname AS lastname_19 ,
c1_ . firstname AS firstname_20 ,
c1_ . idtypestructure AS idtypestructure_21 ,
c1_ . license AS license_22 ,
c1_ . comment AS comment_23 ,
c1_ . private_comment AS private_comment_24 ,
c1_ . address1 AS address1_25 ,
c1_ . address2 AS address2_26 ,
c1_ . zip AS zip_27 ,
c1_ . city AS city_28 ,
c1_ . phone1 AS phone1_29 ,
c1_ . phone2 AS phone2_30 ,
c1_ . fax AS fax_31 ,
c1_ . email1 AS email1_32 ,
c1_ . email1_online AS email1_online_33 ,
c1_ . email2_online AS email2_online_34 ,
c1_ . email2 AS email2_35 ,
c1_ . url AS url_36 ,
c1_ . url_ticket AS url_ticket_37 ,
c1_ . facebook AS facebook_38 ,
c1_ . twitter AS twitter_39 ,
c1_ . instagram AS instagram_40 ,
c1_ . mobile AS mobile_41 ,
c1_ . geocodable AS geocodable_42 ,
c1_ . x AS x_43 ,
c1_ . y AS y_44 ,
c1_ . idmultimedia AS idmultimedia_45 ,
c1_ . type_view AS type_view_46 ,
c1_ . stats_access AS stats_access_47 ,
c1_ . ga_tracking_id AS ga_tracking_id_48 ,
c1_ . is_festival AS is_festival_49 ,
c1_ . link_on_video AS link_on_video_50 ,
c1_ . is_partenaire AS is_partenaire_51 ,
c1_ . valid_version AS valid_version_52 ,
c1_ . other_versions AS other_versions_53 ,
c1_ . url_redirect AS url_redirect_54 ,
c1_ . url_clean AS url_clean_55 ,
c1_ . dateupdate AS dateupdate_56 ,
c1_ . dateinsert AS dateinsert_57 ,
c1_ . publish AS publish_58 ,
c1_ . valid AS valid_59 ,
s0_ . idspectacle AS idspectacle_60 ,
s0_ . idcontact AS idcontact_61 ,
s0_ . idextranetuser AS idextranetuser_62 ,
c1_ . country AS country_63 ,
c1_ . idextranetuser AS idextranetuser_64
FROM
schedules s0_
LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact
WHERE
s0_ . idspectacle = ?
AND s0_ . date < ?
GROUP BY
s0_ . idcontact
ORDER BY
s0_ . date DESC
LIMIT
1
Copy
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = 33112 AND s0_ . date < '2024-04-25' GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1 ;
Copy
41
0.05 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 33112
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 33112
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
42
0.05 ms
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` = 33112 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` = 33112 AND d . code_franceinter IS NOT NULL ;
Copy
43
0.04 ms
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
44
0.04 ms
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 = '33112'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (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 = '33112'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
45
0.03 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 6 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 6 LIMIT 1 ;
Copy
46
0.03 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 125 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 125 LIMIT 1 ;
Copy
47
0.03 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 101 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 101 LIMIT 1 ;
Copy
48
0.04 ms
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (? ) LIMIT 1
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (4 ) LIMIT 1 ;
Copy
49
0.15 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 40563 ;
Copy
50
0.26 ms
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 = 40563 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 = 40563 ORDER BY j2 . classement ASC ;
Copy
51
0.86 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 32554 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 32554 ORDER BY p . `lastname` ;
Copy
52
0.36 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 32554 AND r . type_creator = 1 ORDER BY sp . `classement`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 32554 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
53
1.50 ms
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = ? AND s0_ . date < ? GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1
Parameters :
[
32554
"2024-04-25 "
]
SELECT
MIN (s0_ . date ) AS sclr_0 ,
MAX (s0_ . date ) AS sclr_1 ,
s0_ . idschedule AS idschedule_2 ,
s0_ . date AS date_3 ,
s0_ . hour AS hour_4 ,
s0_ . is_creation AS is_creation_5 ,
s0_ . is_cancelled AS is_cancelled_6 ,
s0_ . idcontact_festival AS idcontact_festival_7 ,
s0_ . url_spectacle AS url_spectacle_8 ,
s0_ . url_booking AS url_booking_9 ,
s0_ . note AS note_10 ,
s0_ . dateupdate AS dateupdate_11 ,
s0_ . dateinsert AS dateinsert_12 ,
s0_ . publish AS publish_13 ,
s0_ . valid AS valid_14 ,
c1_ . idcontact AS idcontact_15 ,
c1_ . type AS type_16 ,
c1_ . organisation AS organisation_17 ,
c1_ . nom_suite AS nom_suite_18 ,
c1_ . lastname AS lastname_19 ,
c1_ . firstname AS firstname_20 ,
c1_ . idtypestructure AS idtypestructure_21 ,
c1_ . license AS license_22 ,
c1_ . comment AS comment_23 ,
c1_ . private_comment AS private_comment_24 ,
c1_ . address1 AS address1_25 ,
c1_ . address2 AS address2_26 ,
c1_ . zip AS zip_27 ,
c1_ . city AS city_28 ,
c1_ . phone1 AS phone1_29 ,
c1_ . phone2 AS phone2_30 ,
c1_ . fax AS fax_31 ,
c1_ . email1 AS email1_32 ,
c1_ . email1_online AS email1_online_33 ,
c1_ . email2_online AS email2_online_34 ,
c1_ . email2 AS email2_35 ,
c1_ . url AS url_36 ,
c1_ . url_ticket AS url_ticket_37 ,
c1_ . facebook AS facebook_38 ,
c1_ . twitter AS twitter_39 ,
c1_ . instagram AS instagram_40 ,
c1_ . mobile AS mobile_41 ,
c1_ . geocodable AS geocodable_42 ,
c1_ . x AS x_43 ,
c1_ . y AS y_44 ,
c1_ . idmultimedia AS idmultimedia_45 ,
c1_ . type_view AS type_view_46 ,
c1_ . stats_access AS stats_access_47 ,
c1_ . ga_tracking_id AS ga_tracking_id_48 ,
c1_ . is_festival AS is_festival_49 ,
c1_ . link_on_video AS link_on_video_50 ,
c1_ . is_partenaire AS is_partenaire_51 ,
c1_ . valid_version AS valid_version_52 ,
c1_ . other_versions AS other_versions_53 ,
c1_ . url_redirect AS url_redirect_54 ,
c1_ . url_clean AS url_clean_55 ,
c1_ . dateupdate AS dateupdate_56 ,
c1_ . dateinsert AS dateinsert_57 ,
c1_ . publish AS publish_58 ,
c1_ . valid AS valid_59 ,
s0_ . idspectacle AS idspectacle_60 ,
s0_ . idcontact AS idcontact_61 ,
s0_ . idextranetuser AS idextranetuser_62 ,
c1_ . country AS country_63 ,
c1_ . idextranetuser AS idextranetuser_64
FROM
schedules s0_
LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact
WHERE
s0_ . idspectacle = ?
AND s0_ . date < ?
GROUP BY
s0_ . idcontact
ORDER BY
s0_ . date DESC
LIMIT
1
Copy
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = 32554 AND s0_ . date < '2024-04-25' GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1 ;
Copy
54
0.30 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 32554
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 32554
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
55
0.28 ms
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` = 32554 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` = 32554 AND d . code_franceinter IS NOT NULL ;
Copy
56
0.04 ms
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
57
0.44 ms
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 = '32554'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (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 = '32554'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
58
0.30 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32554 AND cc . idclassification = 6 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32554 AND cc . idclassification = 6 LIMIT 1 ;
Copy
59
0.28 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32554 AND cc . idclassification = 125 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32554 AND cc . idclassification = 125 LIMIT 1 ;
Copy
60
0.28 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32554 AND cc . idclassification = 101 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32554 AND cc . idclassification = 101 LIMIT 1 ;
Copy
61
0.05 ms
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (? ) LIMIT 1
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (4 ) LIMIT 1 ;
Copy
62
0.12 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39810 ;
Copy
63
0.25 ms
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 = 39810 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 = 39810 ORDER BY j2 . classement ASC ;
Copy
64
0.70 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31999 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31999 ORDER BY p . `lastname` ;
Copy
65
1.13 ms
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = ? AND s0_ . date < ? GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1
Parameters :
[
31999
"2024-04-25 "
]
SELECT
MIN (s0_ . date ) AS sclr_0 ,
MAX (s0_ . date ) AS sclr_1 ,
s0_ . idschedule AS idschedule_2 ,
s0_ . date AS date_3 ,
s0_ . hour AS hour_4 ,
s0_ . is_creation AS is_creation_5 ,
s0_ . is_cancelled AS is_cancelled_6 ,
s0_ . idcontact_festival AS idcontact_festival_7 ,
s0_ . url_spectacle AS url_spectacle_8 ,
s0_ . url_booking AS url_booking_9 ,
s0_ . note AS note_10 ,
s0_ . dateupdate AS dateupdate_11 ,
s0_ . dateinsert AS dateinsert_12 ,
s0_ . publish AS publish_13 ,
s0_ . valid AS valid_14 ,
c1_ . idcontact AS idcontact_15 ,
c1_ . type AS type_16 ,
c1_ . organisation AS organisation_17 ,
c1_ . nom_suite AS nom_suite_18 ,
c1_ . lastname AS lastname_19 ,
c1_ . firstname AS firstname_20 ,
c1_ . idtypestructure AS idtypestructure_21 ,
c1_ . license AS license_22 ,
c1_ . comment AS comment_23 ,
c1_ . private_comment AS private_comment_24 ,
c1_ . address1 AS address1_25 ,
c1_ . address2 AS address2_26 ,
c1_ . zip AS zip_27 ,
c1_ . city AS city_28 ,
c1_ . phone1 AS phone1_29 ,
c1_ . phone2 AS phone2_30 ,
c1_ . fax AS fax_31 ,
c1_ . email1 AS email1_32 ,
c1_ . email1_online AS email1_online_33 ,
c1_ . email2_online AS email2_online_34 ,
c1_ . email2 AS email2_35 ,
c1_ . url AS url_36 ,
c1_ . url_ticket AS url_ticket_37 ,
c1_ . facebook AS facebook_38 ,
c1_ . twitter AS twitter_39 ,
c1_ . instagram AS instagram_40 ,
c1_ . mobile AS mobile_41 ,
c1_ . geocodable AS geocodable_42 ,
c1_ . x AS x_43 ,
c1_ . y AS y_44 ,
c1_ . idmultimedia AS idmultimedia_45 ,
c1_ . type_view AS type_view_46 ,
c1_ . stats_access AS stats_access_47 ,
c1_ . ga_tracking_id AS ga_tracking_id_48 ,
c1_ . is_festival AS is_festival_49 ,
c1_ . link_on_video AS link_on_video_50 ,
c1_ . is_partenaire AS is_partenaire_51 ,
c1_ . valid_version AS valid_version_52 ,
c1_ . other_versions AS other_versions_53 ,
c1_ . url_redirect AS url_redirect_54 ,
c1_ . url_clean AS url_clean_55 ,
c1_ . dateupdate AS dateupdate_56 ,
c1_ . dateinsert AS dateinsert_57 ,
c1_ . publish AS publish_58 ,
c1_ . valid AS valid_59 ,
s0_ . idspectacle AS idspectacle_60 ,
s0_ . idcontact AS idcontact_61 ,
s0_ . idextranetuser AS idextranetuser_62 ,
c1_ . country AS country_63 ,
c1_ . idextranetuser AS idextranetuser_64
FROM
schedules s0_
LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact
WHERE
s0_ . idspectacle = ?
AND s0_ . date < ?
GROUP BY
s0_ . idcontact
ORDER BY
s0_ . date DESC
LIMIT
1
Copy
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = 31999 AND s0_ . date < '2024-04-25' GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1 ;
Copy
66
0.21 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31999
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31999
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
67
0.16 ms
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` = 31999 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` = 31999 AND d . code_franceinter IS NOT NULL ;
Copy
68
0.03 ms
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
69
0.24 ms
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 = '31999'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (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 = '31999'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
70
0.20 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31999 AND cc . idclassification = 6 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31999 AND cc . idclassification = 6 LIMIT 1 ;
Copy
71
0.20 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31999 AND cc . idclassification = 125 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31999 AND cc . idclassification = 125 LIMIT 1 ;
Copy
72
0.19 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31999 AND cc . idclassification = 101 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31999 AND cc . idclassification = 101 LIMIT 1 ;
Copy
73
0.04 ms
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (? ) LIMIT 1
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (4 ) LIMIT 1 ;
Copy
74
0.10 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39994 ;
Copy
75
0.20 ms
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 = 39994 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 = 39994 ORDER BY j2 . classement ASC ;
Copy
76
0.80 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 32139 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 32139 ORDER BY p . `lastname` ;
Copy
77
1.42 ms
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = ? AND s0_ . date < ? GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1
Parameters :
[
32139
"2024-04-25 "
]
SELECT
MIN (s0_ . date ) AS sclr_0 ,
MAX (s0_ . date ) AS sclr_1 ,
s0_ . idschedule AS idschedule_2 ,
s0_ . date AS date_3 ,
s0_ . hour AS hour_4 ,
s0_ . is_creation AS is_creation_5 ,
s0_ . is_cancelled AS is_cancelled_6 ,
s0_ . idcontact_festival AS idcontact_festival_7 ,
s0_ . url_spectacle AS url_spectacle_8 ,
s0_ . url_booking AS url_booking_9 ,
s0_ . note AS note_10 ,
s0_ . dateupdate AS dateupdate_11 ,
s0_ . dateinsert AS dateinsert_12 ,
s0_ . publish AS publish_13 ,
s0_ . valid AS valid_14 ,
c1_ . idcontact AS idcontact_15 ,
c1_ . type AS type_16 ,
c1_ . organisation AS organisation_17 ,
c1_ . nom_suite AS nom_suite_18 ,
c1_ . lastname AS lastname_19 ,
c1_ . firstname AS firstname_20 ,
c1_ . idtypestructure AS idtypestructure_21 ,
c1_ . license AS license_22 ,
c1_ . comment AS comment_23 ,
c1_ . private_comment AS private_comment_24 ,
c1_ . address1 AS address1_25 ,
c1_ . address2 AS address2_26 ,
c1_ . zip AS zip_27 ,
c1_ . city AS city_28 ,
c1_ . phone1 AS phone1_29 ,
c1_ . phone2 AS phone2_30 ,
c1_ . fax AS fax_31 ,
c1_ . email1 AS email1_32 ,
c1_ . email1_online AS email1_online_33 ,
c1_ . email2_online AS email2_online_34 ,
c1_ . email2 AS email2_35 ,
c1_ . url AS url_36 ,
c1_ . url_ticket AS url_ticket_37 ,
c1_ . facebook AS facebook_38 ,
c1_ . twitter AS twitter_39 ,
c1_ . instagram AS instagram_40 ,
c1_ . mobile AS mobile_41 ,
c1_ . geocodable AS geocodable_42 ,
c1_ . x AS x_43 ,
c1_ . y AS y_44 ,
c1_ . idmultimedia AS idmultimedia_45 ,
c1_ . type_view AS type_view_46 ,
c1_ . stats_access AS stats_access_47 ,
c1_ . ga_tracking_id AS ga_tracking_id_48 ,
c1_ . is_festival AS is_festival_49 ,
c1_ . link_on_video AS link_on_video_50 ,
c1_ . is_partenaire AS is_partenaire_51 ,
c1_ . valid_version AS valid_version_52 ,
c1_ . other_versions AS other_versions_53 ,
c1_ . url_redirect AS url_redirect_54 ,
c1_ . url_clean AS url_clean_55 ,
c1_ . dateupdate AS dateupdate_56 ,
c1_ . dateinsert AS dateinsert_57 ,
c1_ . publish AS publish_58 ,
c1_ . valid AS valid_59 ,
s0_ . idspectacle AS idspectacle_60 ,
s0_ . idcontact AS idcontact_61 ,
s0_ . idextranetuser AS idextranetuser_62 ,
c1_ . country AS country_63 ,
c1_ . idextranetuser AS idextranetuser_64
FROM
schedules s0_
LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact
WHERE
s0_ . idspectacle = ?
AND s0_ . date < ?
GROUP BY
s0_ . idcontact
ORDER BY
s0_ . date DESC
LIMIT
1
Copy
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = 32139 AND s0_ . date < '2024-04-25' GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1 ;
Copy
78
0.29 ms
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 32139
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 32139
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
79
0.18 ms
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` = 32139 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` = 32139 AND d . code_franceinter IS NOT NULL ;
Copy
80
0.03 ms
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
81
0.33 ms
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 = '32139'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (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 = '32139'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
82
0.24 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32139 AND cc . idclassification = 6 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32139 AND cc . idclassification = 6 LIMIT 1 ;
Copy
83
0.23 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32139 AND cc . idclassification = 125 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32139 AND cc . idclassification = 125 LIMIT 1 ;
Copy
84
0.22 ms
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32139 AND cc . idclassification = 101 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 32139 AND cc . idclassification = 101 LIMIT 1 ;
Copy
85
0.76 ms
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND multimedias . `audio_video` = 2 AND multimedias . `publish` = 1 AND object_multimedia . `object` IN ('contacts' ) AND object_multimedia . `idobject` = 16359 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
LIMIT 0 , 4
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND multimedias . `audio_video` = 2 AND multimedias . `publish` = 1 AND object_multimedia . `object` IN ('contacts' ) AND object_multimedia . `idobject` = 16359 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
LIMIT 0 , 4 ;
Copy
86
0.58 ms
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` IN (16359 ) AND podcasts . `code_franceinter` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 7
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` IN (16359 ) AND podcasts . `code_franceinter` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 7 ;
Copy
87
0.55 ms
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` IN (16359 ) AND podcasts . `code_ft` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 1
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` IN (16359 ) AND podcasts . `code_ft` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 1 ;
Copy
88
0.04 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 16359 OR spectacles . `idcontact_production` = 16359 ) 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` = 16359 OR spectacles . `idcontact_production` = 16359 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 );
Copy
89
0.03 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 16359 OR spectacles . `idcontact_production` = 16359 ) 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` = 16359 OR spectacles . `idcontact_production` = 16359 ) AND spectacle_contact . `idrole` = 77 ;
Copy
90
0.99 ms
SELECT DISTINCT (s . idschedule ), hour , date , s . note , s . url_spectacle , s . url_booking , s . idcontact_festival , s . hour , s . idspectacle ,
c . idcontact , c . organisation , c . phone1 , c . phone2 , c . city , c . url_clean ,
ft . idcontact as festival_idcontact , ft . organisation as festival_organisation , ft . city as festival_city , ft . url_clean as festival_url_clean
FROM schedules s
JOIN contacts c ON s . idcontact = c . idcontact
LEFT JOIN contacts ft ON s . idcontact_festival = ft . idcontact
WHERE 1 AND s . idspectacle IN (13597 , 29078 , 29598 , 29834 , 31278 , 31999 , 32139 , 32554 , 32637 , 33112 ) AND s . date > = '2024-04-25' ORDER BY s . date ASC LIMIT 0 , 3
SELECT DISTINCT (s . idschedule ), hour , date , s . note , s . url_spectacle , s . url_booking , s . idcontact_festival , s . hour , s . idspectacle ,
c . idcontact , c . organisation , c . phone1 , c . phone2 , c . city , c . url_clean ,
ft . idcontact as festival_idcontact , ft . organisation as festival_organisation , ft . city as festival_city , ft . url_clean as festival_url_clean
FROM schedules s
JOIN contacts c ON s . idcontact = c . idcontact
LEFT JOIN contacts ft ON s . idcontact_festival = ft . idcontact
WHERE 1 AND s . idspectacle IN (13597 , 29078 , 29598 , 29834 , 31278 , 31999 , 32139 , 32554 , 32637 , 33112 ) AND s . date > = '2024-04-25' ORDER BY s . date ASC LIMIT 0 , 3 ;
Copy
91
0.19 ms
SELECT s0_ . idspectacle AS idspectacle_0 , s0_ . title AS title_1 , s0_ . language AS language_2 , s0_ . creation_date AS creation_date_3 , s0_ . url_page AS url_page_4 , s0_ . infos AS infos_5 , s0_ . tag AS tag_6 , s0_ . id_rubrique AS id_rubrique_7 , s0_ . duration AS duration_8 , s0_ . interlude AS interlude_9 , s0_ . textfictif AS textfictif_10 , s0_ . url_redirect AS url_redirect_11 , s0_ . url_clean AS url_clean_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . statut AS statut_16 , s0_ . valid AS valid_17 , s0_ . idtypespectacle AS idtypespectacle_18 , s0_ . idcontact_creation AS idcontact_creation_19 , s0_ . idcontact_production AS idcontact_production_20 , s0_ . idspectaclegenre AS idspectaclegenre_21 , s0_ . idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_ . idspectacle = ?
SELECT s0_ . idspectacle AS idspectacle_0 , s0_ . title AS title_1 , s0_ . language AS language_2 , s0_ . creation_date AS creation_date_3 , s0_ . url_page AS url_page_4 , s0_ . infos AS infos_5 , s0_ . tag AS tag_6 , s0_ . id_rubrique AS id_rubrique_7 , s0_ . duration AS duration_8 , s0_ . interlude AS interlude_9 , s0_ . textfictif AS textfictif_10 , s0_ . url_redirect AS url_redirect_11 , s0_ . url_clean AS url_clean_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . statut AS statut_16 , s0_ . valid AS valid_17 , s0_ . idtypespectacle AS idtypespectacle_18 , s0_ . idcontact_creation AS idcontact_creation_19 , s0_ . idcontact_production AS idcontact_production_20 , s0_ . idspectaclegenre AS idspectaclegenre_21 , s0_ . idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_ . idspectacle = '33112' ;
Copy
92
0.05 ms
SELECT lt . fr
FROM typesspectacles e , langterms lt
WHERE typespectacle = lt . id
AND idtypespectacle = 4
SELECT lt . fr
FROM typesspectacles e , langterms lt
WHERE typespectacle = lt . id
AND idtypespectacle = 4 ;
Copy
93
0.03 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
94
0.16 ms
SELECT t . idtext , t . title , t . type , t . url_clean , t . textfictif FROM texts t , text_spectacle ts
WHERE 1
AND ts . idspectacle = 33112
AND t . idtext = ts . idtext
SELECT t . idtext , t . title , t . type , t . url_clean , t . textfictif FROM texts t , text_spectacle ts
WHERE 1
AND ts . idspectacle = 33112
AND t . idtext = ts . idtext ;
Copy
95
0.09 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = '35903' ;
Copy
96
0.03 ms
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 = 35903
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 = 35903
ORDER BY t . title ;
Copy
97
0.03 ms
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 = 33016 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 = 33016 ORDER BY j2 . classement ASC ;
Copy
98
0.31 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 AND r . type_creator = 1 ORDER BY sp . `classement`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
99
0.05 ms
SELECT s0_ . idspectacle AS idspectacle_0 , s0_ . title AS title_1 , s0_ . language AS language_2 , s0_ . creation_date AS creation_date_3 , s0_ . url_page AS url_page_4 , s0_ . infos AS infos_5 , s0_ . tag AS tag_6 , s0_ . id_rubrique AS id_rubrique_7 , s0_ . duration AS duration_8 , s0_ . interlude AS interlude_9 , s0_ . textfictif AS textfictif_10 , s0_ . url_redirect AS url_redirect_11 , s0_ . url_clean AS url_clean_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . statut AS statut_16 , s0_ . valid AS valid_17 , s0_ . idtypespectacle AS idtypespectacle_18 , s0_ . idcontact_creation AS idcontact_creation_19 , s0_ . idcontact_production AS idcontact_production_20 , s0_ . idspectaclegenre AS idspectaclegenre_21 , s0_ . idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_ . idspectacle = ?
SELECT s0_ . idspectacle AS idspectacle_0 , s0_ . title AS title_1 , s0_ . language AS language_2 , s0_ . creation_date AS creation_date_3 , s0_ . url_page AS url_page_4 , s0_ . infos AS infos_5 , s0_ . tag AS tag_6 , s0_ . id_rubrique AS id_rubrique_7 , s0_ . duration AS duration_8 , s0_ . interlude AS interlude_9 , s0_ . textfictif AS textfictif_10 , s0_ . url_redirect AS url_redirect_11 , s0_ . url_clean AS url_clean_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . statut AS statut_16 , s0_ . valid AS valid_17 , s0_ . idtypespectacle AS idtypespectacle_18 , s0_ . idcontact_creation AS idcontact_creation_19 , s0_ . idcontact_production AS idcontact_production_20 , s0_ . idspectaclegenre AS idspectaclegenre_21 , s0_ . idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_ . idspectacle = '33112' ;
Copy
100
0.03 ms
SELECT lt . fr
FROM typesspectacles e , langterms lt
WHERE typespectacle = lt . id
AND idtypespectacle = 4
SELECT lt . fr
FROM typesspectacles e , langterms lt
WHERE typespectacle = lt . id
AND idtypespectacle = 4 ;
Copy
101
0.03 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
102
0.03 ms
SELECT t . idtext , t . title , t . type , t . url_clean , t . textfictif FROM texts t , text_spectacle ts
WHERE 1
AND ts . idspectacle = 33112
AND t . idtext = ts . idtext
SELECT t . idtext , t . title , t . type , t . url_clean , t . textfictif FROM texts t , text_spectacle ts
WHERE 1
AND ts . idspectacle = 33112
AND t . idtext = ts . idtext ;
Copy
103
0.03 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = '35903' ;
Copy
104
0.03 ms
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 = 35903
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 = 35903
ORDER BY t . title ;
Copy
105
0.03 ms
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 = 33016 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 = 33016 ORDER BY j2 . classement ASC ;
Copy
106
0.03 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 AND r . type_creator = 1 ORDER BY sp . `classement`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
107
0.04 ms
SELECT s0_ . idspectacle AS idspectacle_0 , s0_ . title AS title_1 , s0_ . language AS language_2 , s0_ . creation_date AS creation_date_3 , s0_ . url_page AS url_page_4 , s0_ . infos AS infos_5 , s0_ . tag AS tag_6 , s0_ . id_rubrique AS id_rubrique_7 , s0_ . duration AS duration_8 , s0_ . interlude AS interlude_9 , s0_ . textfictif AS textfictif_10 , s0_ . url_redirect AS url_redirect_11 , s0_ . url_clean AS url_clean_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . statut AS statut_16 , s0_ . valid AS valid_17 , s0_ . idtypespectacle AS idtypespectacle_18 , s0_ . idcontact_creation AS idcontact_creation_19 , s0_ . idcontact_production AS idcontact_production_20 , s0_ . idspectaclegenre AS idspectaclegenre_21 , s0_ . idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_ . idspectacle = ?
SELECT s0_ . idspectacle AS idspectacle_0 , s0_ . title AS title_1 , s0_ . language AS language_2 , s0_ . creation_date AS creation_date_3 , s0_ . url_page AS url_page_4 , s0_ . infos AS infos_5 , s0_ . tag AS tag_6 , s0_ . id_rubrique AS id_rubrique_7 , s0_ . duration AS duration_8 , s0_ . interlude AS interlude_9 , s0_ . textfictif AS textfictif_10 , s0_ . url_redirect AS url_redirect_11 , s0_ . url_clean AS url_clean_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . statut AS statut_16 , s0_ . valid AS valid_17 , s0_ . idtypespectacle AS idtypespectacle_18 , s0_ . idcontact_creation AS idcontact_creation_19 , s0_ . idcontact_production AS idcontact_production_20 , s0_ . idspectaclegenre AS idspectaclegenre_21 , s0_ . idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_ . idspectacle = '33112' ;
Copy
108
0.03 ms
SELECT lt . fr
FROM typesspectacles e , langterms lt
WHERE typespectacle = lt . id
AND idtypespectacle = 4
SELECT lt . fr
FROM typesspectacles e , langterms lt
WHERE typespectacle = lt . id
AND idtypespectacle = 4 ;
Copy
109
0.03 ms
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
110
0.03 ms
SELECT t . idtext , t . title , t . type , t . url_clean , t . textfictif FROM texts t , text_spectacle ts
WHERE 1
AND ts . idspectacle = 33112
AND t . idtext = ts . idtext
SELECT t . idtext , t . title , t . type , t . url_clean , t . textfictif FROM texts t , text_spectacle ts
WHERE 1
AND ts . idspectacle = 33112
AND t . idtext = ts . idtext ;
Copy
111
0.03 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = '35903' ;
Copy
112
0.03 ms
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 = 35903
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 = 35903
ORDER BY t . title ;
Copy
113
0.03 ms
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 = 33016 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 = 33016 ORDER BY j2 . classement ASC ;
Copy
114
0.03 ms
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 AND r . type_creator = 1 ORDER BY sp . `classement`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
115
0.03 ms
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
116
0.78 ms
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 = '16359'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification 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 = '16359'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_presentation_structure' ))) ORDER BY c . `range` , c . idcontent ;
Copy
117
0.03 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 16359 OR schedules . idcontact_festival = 16359 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 16359 OR schedules . idcontact_festival = 16359 );
Copy
118
0.03 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 16359 OR spectacles . `idcontact_production` = 16359 ) 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` = 16359 OR spectacles . `idcontact_production` = 16359 ) AND spectacle_contact . `idrole` = 77 ;
Copy
119
0.72 ms
SELECT DISTINCT (s . idschedule ), hour , date , s . note , s . url_spectacle , s . url_booking , s . idcontact_festival , s . hour , s . idspectacle ,
c . idcontact , c . organisation , c . phone1 , c . phone2 , c . city , c . url_clean ,
ft . idcontact as festival_idcontact , ft . organisation as festival_organisation , ft . city as festival_city , ft . url_clean as festival_url_clean
FROM schedules s
JOIN contacts c ON s . idcontact = c . idcontact
LEFT JOIN contacts ft ON s . idcontact_festival = ft . idcontact
WHERE 1 AND s . idspectacle IN (29078 , 29598 , 29834 , 31278 , 31999 , 32139 , 32554 , 32637 , 33112 ) AND s . date > = '2024-04-25' AND c . idcontact = 16359 ORDER BY s . date ASC LIMIT 0 , 3
SELECT DISTINCT (s . idschedule ), hour , date , s . note , s . url_spectacle , s . url_booking , s . idcontact_festival , s . hour , s . idspectacle ,
c . idcontact , c . organisation , c . phone1 , c . phone2 , c . city , c . url_clean ,
ft . idcontact as festival_idcontact , ft . organisation as festival_organisation , ft . city as festival_city , ft . url_clean as festival_url_clean
FROM schedules s
JOIN contacts c ON s . idcontact = c . idcontact
LEFT JOIN contacts ft ON s . idcontact_festival = ft . idcontact
WHERE 1 AND s . idspectacle IN (29078 , 29598 , 29834 , 31278 , 31999 , 32139 , 32554 , 32637 , 33112 ) AND s . date > = '2024-04-25' AND c . idcontact = 16359 ORDER BY s . date ASC LIMIT 0 , 3 ;
Copy
120
0.27 ms
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` = 16359 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` = 16359 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = text_aide . `idaide`
;
Copy
121
0.21 ms
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` = 16359 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` = 16359 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = spectacle_aide . `idaide`
;
Copy
122
0.21 ms
SELECT COUNT (DISTINCT (person_aide . idpersonaide )) as total , person_aide . * , aides . *
FROM `aides` ,
`person_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 16359 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` = 16359 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = person_aide . `idaide`
;
Copy
123
0.21 ms
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` = 16359 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` = 16359 AND aides . `type_aide` IN (2 ) AND aides . `idaide` = contact_aide . `idaide`
;
Copy
124
0.23 ms
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` = 16359 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` = 16359 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = text_aide . `idaide`
;
Copy
125
0.21 ms
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` = 16359 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` = 16359 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = spectacle_aide . `idaide`
;
Copy
126
0.19 ms
SELECT COUNT (DISTINCT (person_aide . idpersonaide )) as total , person_aide . * , aides . *
FROM `aides` ,
`person_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 16359 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` = 16359 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = person_aide . `idaide`
;
Copy
127
0.19 ms
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` = 16359 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` = 16359 AND aides . `type_aide` IN (2 , 3 ) AND aides . `idaide` = contact_aide . `idaide`
;
Copy
128
0.21 ms
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` = 16359 AND aides . `type_aide` IN (4 ) 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` = 16359 AND aides . `type_aide` IN (4 ) AND aides . `idaide` = text_aide . `idaide`
;
Copy
129
0.19 ms
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` = 16359 AND aides . `type_aide` IN (4 ) 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` = 16359 AND aides . `type_aide` IN (4 ) AND aides . `idaide` = spectacle_aide . `idaide`
;
Copy
130
0.15 ms
SELECT COUNT (DISTINCT (person_aide . idpersonaide )) as total , person_aide . * , aides . *
FROM `aides` ,
`person_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 16359 AND aides . `type_aide` IN (4 ) 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` = 16359 AND aides . `type_aide` IN (4 ) AND aides . `idaide` = person_aide . `idaide`
;
Copy
131
0.16 ms
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` = 16359 AND aides . `type_aide` IN (4 ) 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` = 16359 AND aides . `type_aide` IN (4 ) AND aides . `idaide` = contact_aide . `idaide`
;
Copy
132
0.16 ms
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` = 16359 AND aides . `type_aide` IN (1 ) 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` = 16359 AND aides . `type_aide` IN (1 ) AND aides . `idaide` = text_aide . `idaide`
;
Copy
133
0.16 ms
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` = 16359 AND aides . `type_aide` IN (1 ) 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` = 16359 AND aides . `type_aide` IN (1 ) AND aides . `idaide` = spectacle_aide . `idaide`
;
Copy
134
0.15 ms
SELECT COUNT (DISTINCT (person_aide . idpersonaide )) as total , person_aide . * , aides . *
FROM `aides` ,
`person_aide`
WHERE 1 AND aides . `publish` = 1 AND aides . `idcontact` = 16359 AND aides . `type_aide` IN (1 ) 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` = 16359 AND aides . `type_aide` IN (1 ) AND aides . `idaide` = person_aide . `idaide`
;
Copy
135
0.16 ms
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` = 16359 AND aides . `type_aide` IN (1 ) 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` = 16359 AND aides . `type_aide` IN (1 ) AND aides . `idaide` = contact_aide . `idaide`
;
Copy
136
0.15 ms
SELECT person_ecole . * , contacts . `organisation` , contacts . `url_clean`
FROM person_ecole
JOIN contacts ON contacts . `idcontact` = person_ecole . `idcontact`
WHERE person_ecole . `idcontact` = 16359
SELECT person_ecole . * , contacts . `organisation` , contacts . `url_clean`
FROM person_ecole
JOIN contacts ON contacts . `idcontact` = person_ecole . `idcontact`
WHERE person_ecole . `idcontact` = 16359 ;
Copy
137
0.03 ms
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (13597 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 16359
)
)
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (13597 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 16359
)
);
Copy
138
0.03 ms
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
139
0.05 ms
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 = '16359'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification 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 = '16359'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_presentation_structure' ))) ORDER BY c . `range` , c . idcontent ;
Copy
140
0.02 ms
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
141
0.75 ms
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 = '16359'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification 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 = '16359'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent ;
Copy
142
0.17 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 2 ;
Copy
143
0.14 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 2 ;
Copy
144
0.13 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 2 ;
Copy
145
0.10 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 2 ;
Copy
146
0.10 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 3
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 3 ;
Copy
147
0.10 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 3
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 3 ;
Copy
148
0.09 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 3
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 3 ;
Copy
149
0.10 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 3
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 3 ;
Copy
150
0.21 ms
SELECT COUNT (p . idplaylist )
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
LEFT JOIN aides a ON a . idcontact = 16359
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 = 16359
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
151
0.11 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 1 ;
Copy
152
0.10 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 1 ;
Copy
153
0.10 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 1 ;
Copy
154
0.10 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 1 ;
Copy
155
0.10 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 4
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 4 ;
Copy
156
0.10 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 4
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 4 ;
Copy
157
0.10 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 4
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 4 ;
Copy
158
0.10 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 4
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 16359
AND aides . `type_aide` = 4 ;
Copy
159
0.31 ms
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 = 16359 ) 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 = 16359 ) AND T1 . publish = 1 ;
Copy
160
0.26 ms
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 16359 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` = 16359 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
161
0.34 ms
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 (13597 , 29078 , 29598 , 29834 , 31278 , 31999 , 32139 , 32554 , 32637 , 33112 ) 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 (13597 , 29078 , 29598 , 29834 , 31278 , 31999 , 32139 , 32554 , 32637 , 33112 ) AND d . code_franceinter IS NOT NULL ;
Copy
162
0.20 ms
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 = 16359 ;
Copy
163
12.25 ms
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` = 16359 OR spectacles . `idcontact_production` = 16359 ) 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` = 16359 OR spectacles . `idcontact_production` = 16359 ) 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
164
0.06 ms
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
165
0.03 ms
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
166
0.42 ms
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 = '16359'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (112 , 168 , 33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (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 = '16359'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (112 , 168 , 33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
167
0.13 ms
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 16359
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 16359 ;
Copy
168
0.47 ms
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 :
[
"303e0e2d345ce8b8d19c4a4d0c8b10db-5807 "
0
"10d6d59c9fe9860d64d093cf8a4a8d87 "
]
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 = '303e0e2d345ce8b8d19c4a4d0c8b10db-5807' AND t0 . idcontent = 0 AND t0 . md5url = '10d6d59c9fe9860d64d093cf8a4a8d87' ;
Copy
169
1.88 ms
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/contacts/Scene-2/ "
"10d6d59c9fe9860d64d093cf8a4a8d87 "
0
"contacts "
16359
0
"fr "
"303e0e2d345ce8b8d19c4a4d0c8b10db-5807 "
"/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/Scene-2/' , '10d6d59c9fe9860d64d093cf8a4a8d87' , 0 , 'contacts' , 16359 , 0 , 'fr' , '303e0e2d345ce8b8d19c4a4d0c8b10db-5807' , '/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829' );
Copy
170
0.62 ms
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