1
0.37 ms
SELECT idcontact FROM contacts WHERE url_clean = 'Theatre-de-l-Iris'
SELECT idcontact FROM contacts WHERE url_clean = 'Theatre-de-l-Iris' ;
Copy
2
0.77 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 = 7006 ;
Copy
3
0.06 ms
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
4
0.21 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 = 'CIEL' ;
Copy
5
0.36 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 = 7006 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 = 7006 AND j2 . idoffice = 1 ;
Copy
6
0.10 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
3.43 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 = '7006'
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 = '7006'
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.08 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
2.63 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 = '7006'
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 = '7006'
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
3.33 ms
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 7006 OR schedules . idcontact_festival = 7006 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 7006 OR schedules . idcontact_festival = 7006 );
Copy
11
99.61 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` = 7006 OR spectacles . `idcontact_production` = 7006 ) 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` = 7006 OR spectacles . `idcontact_production` = 7006 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 );
Copy
12
1.71 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` = 7006 OR spectacles . `idcontact_production` = 7006 ) 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` = 7006 OR spectacles . `idcontact_production` = 7006 ) AND spectacle_contact . `idrole` = 77 ;
Copy
13
0.26 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` = 7006
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` = 7006 ;
Copy
14
0.20 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` = 7006 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` = 7006 AND aides . type_aide IN (2 , 3 ) ;
Copy
15
0.17 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` = 7006 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` = 7006 AND aides . type_aide IN (1 ) ;
Copy
16
0.33 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` = 7006 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` = 7006 AND aides . type_aide IN (4 ) ;
Copy
17
13.04 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 (9148 , 9150 , 9151 , 9154 , 9155 , 9159 , 9160 , 11313 , 11415 , 15710 , 15711 , 15712 , 15713 , 15714 , 15715 , 15718 , 15726 , 11623 , 5979 , 15963 , 18455 , 18457 , 18458 , 18459 , 18460 , 18461 , 17765 , 21622 , 21624 , 21625 , 14289 , 19144 , 15858 , 21630 , 24248 , 18456 , 15938 , 24649 , 25120 , 25142 , 25227 , 25518 , 25538 , 26226 , 25558 , 27520 , 24106 , 27808 , 28348 , 9105 , 28360 , 28361 , 27836 , 28363 , 28366 , 30297 , 30713 , 29940 , 31213 , 28367 , 28743 , 8757 , 29961 , 28364 , 28362 , 31934 , 32043 , 32315 , 21629 , 32979 , 26976 , 33152 , 33155 , 33156 , 33158 , 33157 , 32802 , 33154 , 31824 , 30296 , 30289 , 29991 , 27151 , 34692 , 34695 , 34696 , 34697 , 34698 , 12497 , 34773 , 35230 , 36822 , 36828 , 36933 , 8292 , 9150 , 9156 , 9158 , 15713 , 15714 , 15715 , 15938 , 18459 , 18460 , 21629 , 24649 , 25120 , 27520 , 28348 , 28360 , 29961 , 31824 , 31934 , 32043 , 32802 , 33156 , 34692 )
) 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 = 7006
)
)
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 (
9148 , 9150 , 9151 , 9154 , 9155 , 9159 , 9160 ,
11313 , 11415 , 15710 , 15711 , 15712 ,
15713 , 15714 , 15715 , 15718 , 15726 ,
11623 , 5979 , 15963 , 18455 , 18457 , 18458 ,
18459 , 18460 , 18461 , 17765 , 21622 ,
21624 , 21625 , 14289 , 19144 , 15858 ,
21630 , 24248 , 18456 , 15938 , 24649 ,
25120 , 25142 , 25227 , 25518 , 25538 ,
26226 , 25558 , 27520 , 24106 , 27808 ,
28348 , 9105 , 28360 , 28361 , 27836 , 28363 ,
28366 , 30297 , 30713 , 29940 , 31213 ,
28367 , 28743 , 8757 , 29961 , 28364 , 28362 ,
31934 , 32043 , 32315 , 21629 , 32979 ,
26976 , 33152 , 33155 , 33156 , 33158 ,
33157 , 32802 , 33154 , 31824 , 30296 ,
30289 , 29991 , 27151 , 34692 , 34695 ,
34696 , 34697 , 34698 , 12497 , 34773 ,
35230 , 36822 , 36828 , 36933 , 8292 , 9150 ,
9156 , 9158 , 15713 , 15714 , 15715 , 15938 ,
18459 , 18460 , 21629 , 24649 , 25120 ,
27520 , 28348 , 28360 , 29961 , 31824 ,
31934 , 32043 , 32802 , 33156 , 34692
)
)
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 = 7006
)
)
Copy
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 (9148 , 9150 , 9151 , 9154 , 9155 , 9159 , 9160 , 11313 , 11415 , 15710 , 15711 , 15712 , 15713 , 15714 , 15715 , 15718 , 15726 , 11623 , 5979 , 15963 , 18455 , 18457 , 18458 , 18459 , 18460 , 18461 , 17765 , 21622 , 21624 , 21625 , 14289 , 19144 , 15858 , 21630 , 24248 , 18456 , 15938 , 24649 , 25120 , 25142 , 25227 , 25518 , 25538 , 26226 , 25558 , 27520 , 24106 , 27808 , 28348 , 9105 , 28360 , 28361 , 27836 , 28363 , 28366 , 30297 , 30713 , 29940 , 31213 , 28367 , 28743 , 8757 , 29961 , 28364 , 28362 , 31934 , 32043 , 32315 , 21629 , 32979 , 26976 , 33152 , 33155 , 33156 , 33158 , 33157 , 32802 , 33154 , 31824 , 30296 , 30289 , 29991 , 27151 , 34692 , 34695 , 34696 , 34697 , 34698 , 12497 , 34773 , 35230 , 36822 , 36828 , 36933 , 8292 , 9150 , 9156 , 9158 , 15713 , 15714 , 15715 , 15938 , 18459 , 18460 , 21629 , 24649 , 25120 , 27520 , 28348 , 28360 , 29961 , 31824 , 31934 , 32043 , 32802 , 33156 , 34692 )
) 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 = 7006
)
);
Copy
18
17.37 ms
SELECT COUNT (DISTINCT (ct . `idcontent` ))
FROM schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND cc . `idclassification` = 101 AND (
sc . `idspectacle` IN ('8292' , '9150' , '9156' , '9158' , '15713' , '15714' , '15715' , '15938' , '18459' , '18460' , '21629' , '24649' , '25120' , '27520' , '28348' , '28360' , '29961' , '31824' , '31934' , '32043' , '32802' , '33156' , '34692' , '9148' , '9151' , '9154' , '9155' , '9159' , '9160' , '11313' , '11415' , '15710' , '15711' , '15712' , '15718' , '15726' , '11623' , '5979' , '15963' , '18455' , '18457' , '18458' , '18461' , '17765' , '21622' , '21624' , '21625' , '14289' , '19144' , '15858' , '21630' , '24248' , '18456' , '25142' , '25227' , '25518' , '25538' , '26226' , '25558' , '24106' , '27808' , '9105' , '28361' , '27836' , '28363' , '28366' , '30297' , '30713' , '29940' , '31213' , '28367' , '28743' , '8757' , '28364' , '28362' , '32315' , '32979' , '26976' , '33152' , '33155' , '33158' , '33157' , '33154' , '30296' , '30289' , '29991' , '27151' , '34695' , '34696' , '34697' , '34698' , '12497' , '34773' , '35230' , '36822' , '36828' , '36933' )
OR (
sc . `idcontact` = 7006 OR sc . `idcontact_festival` = 7006
)
)
SELECT
COUNT (
DISTINCT (ct . `idcontent` )
)
FROM
schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE
s . `publish` = 1
AND s . `valid` = 1
AND ct . `publish` = 1
AND ct . `valid` = 1
AND cc . `idclassification` = 101
AND (
sc . `idspectacle` IN (
'8292' , '9150' , '9156' , '9158' , '15713' ,
'15714' , '15715' , '15938' , '18459' ,
'18460' , '21629' , '24649' , '25120' ,
'27520' , '28348' , '28360' , '29961' ,
'31824' , '31934' , '32043' , '32802' ,
'33156' , '34692' , '9148' , '9151' ,
'9154' , '9155' , '9159' , '9160' , '11313' ,
'11415' , '15710' , '15711' , '15712' ,
'15718' , '15726' , '11623' , '5979' ,
'15963' , '18455' , '18457' , '18458' ,
'18461' , '17765' , '21622' , '21624' ,
'21625' , '14289' , '19144' , '15858' ,
'21630' , '24248' , '18456' , '25142' ,
'25227' , '25518' , '25538' , '26226' ,
'25558' , '24106' , '27808' , '9105' ,
'28361' , '27836' , '28363' , '28366' ,
'30297' , '30713' , '29940' , '31213' ,
'28367' , '28743' , '8757' , '28364' ,
'28362' , '32315' , '32979' , '26976' ,
'33152' , '33155' , '33158' , '33157' ,
'33154' , '30296' , '30289' , '29991' ,
'27151' , '34695' , '34696' , '34697' ,
'34698' , '12497' , '34773' , '35230' ,
'36822' , '36828' , '36933'
)
OR (
sc . `idcontact` = 7006
OR sc . `idcontact_festival` = 7006
)
)
Copy
SELECT COUNT (DISTINCT (ct . `idcontent` ))
FROM schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND cc . `idclassification` = 101 AND (
sc . `idspectacle` IN ('8292' , '9150' , '9156' , '9158' , '15713' , '15714' , '15715' , '15938' , '18459' , '18460' , '21629' , '24649' , '25120' , '27520' , '28348' , '28360' , '29961' , '31824' , '31934' , '32043' , '32802' , '33156' , '34692' , '9148' , '9151' , '9154' , '9155' , '9159' , '9160' , '11313' , '11415' , '15710' , '15711' , '15712' , '15718' , '15726' , '11623' , '5979' , '15963' , '18455' , '18457' , '18458' , '18461' , '17765' , '21622' , '21624' , '21625' , '14289' , '19144' , '15858' , '21630' , '24248' , '18456' , '25142' , '25227' , '25518' , '25538' , '26226' , '25558' , '24106' , '27808' , '9105' , '28361' , '27836' , '28363' , '28366' , '30297' , '30713' , '29940' , '31213' , '28367' , '28743' , '8757' , '28364' , '28362' , '32315' , '32979' , '26976' , '33152' , '33155' , '33158' , '33157' , '33154' , '30296' , '30289' , '29991' , '27151' , '34695' , '34696' , '34697' , '34698' , '12497' , '34773' , '35230' , '36822' , '36828' , '36933' )
OR (
sc . `idcontact` = 7006 OR sc . `idcontact_festival` = 7006
)
);
Copy
19
1.68 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
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 7006 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date > = '2024-04-26' )) GROUP BY T1 . idnew ORDER BY T3 . date ASC LIMIT 0 , 200
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 7006 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date > = '2024-04-26' )) GROUP BY T1 . idnew ORDER BY T3 . date ASC LIMIT 0 , 200 ;
Copy
20
1.96 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
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 7006 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date < '2024-04-26' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 200
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 7006 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 0 AND (( T3 . date < '2024-04-26' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 200 ;
Copy
21
0.40 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '13175' ;
Copy
22
0.40 ms
SELECT url_file FROM news WHERE idnew = 13175
SELECT url_file FROM news WHERE idnew = 13175 ;
Copy
23
0.31 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13175 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13175 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
24
0.20 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13175 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13175 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
25
0.21 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13175
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13175 ;
Copy
26
0.19 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13175
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13175 ;
Copy
27
0.19 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13175
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13175 ;
Copy
28
0.19 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13175
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13175 ;
Copy
29
0.21 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '13176' ;
Copy
30
0.35 ms
SELECT url_file FROM news WHERE idnew = 13176
SELECT url_file FROM news WHERE idnew = 13176 ;
Copy
31
0.27 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13176 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13176 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
32
0.24 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13176 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13176 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
33
0.20 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13176
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13176 ;
Copy
34
0.21 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13176
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13176 ;
Copy
35
0.18 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13176
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13176 ;
Copy
36
0.17 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13176
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13176 ;
Copy
37
0.21 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '13066' ;
Copy
38
0.19 ms
SELECT url_file FROM news WHERE idnew = 13066
SELECT url_file FROM news WHERE idnew = 13066 ;
Copy
39
0.25 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13066 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13066 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
40
0.36 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13066 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13066 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
41
0.23 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13066
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13066 ;
Copy
42
0.22 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13066
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13066 ;
Copy
43
0.21 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13066
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13066 ;
Copy
44
0.03 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 34698
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 34698 ;
Copy
45
0.17 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13066
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13066 ;
Copy
46
0.21 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '13043' ;
Copy
47
0.17 ms
SELECT url_file FROM news WHERE idnew = 13043
SELECT url_file FROM news WHERE idnew = 13043 ;
Copy
48
0.22 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13043 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13043 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
49
0.63 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13043 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 13043 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
50
0.24 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13043
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 13043 ;
Copy
51
0.20 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13043
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 13043 ;
Copy
52
0.21 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13043
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 13043 ;
Copy
53
0.20 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13043
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 13043 ;
Copy
54
0.21 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '12754' ;
Copy
55
0.14 ms
SELECT url_file FROM news WHERE idnew = 12754
SELECT url_file FROM news WHERE idnew = 12754 ;
Copy
56
0.22 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12754 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12754 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
57
0.28 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12754 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12754 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
58
0.25 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12754
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12754 ;
Copy
59
0.19 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12754
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12754 ;
Copy
60
0.24 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12754
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12754 ;
Copy
61
0.25 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12754
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12754 ;
Copy
62
0.22 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '12765' ;
Copy
63
0.10 ms
SELECT url_file FROM news WHERE idnew = 12765
SELECT url_file FROM news WHERE idnew = 12765 ;
Copy
64
0.25 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12765 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12765 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
65
0.28 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12765 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12765 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
66
0.28 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12765
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12765 ;
Copy
67
0.22 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12765
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12765 ;
Copy
68
0.17 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12765
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12765 ;
Copy
69
0.20 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 21393
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 21393 ;
Copy
70
0.16 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 26976
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 26976 ;
Copy
71
0.24 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12765
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12765 ;
Copy
72
0.28 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '12475' ;
Copy
73
0.16 ms
SELECT url_file FROM news WHERE idnew = 12475
SELECT url_file FROM news WHERE idnew = 12475 ;
Copy
74
0.26 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12475 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12475 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
75
0.26 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12475 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12475 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
76
0.19 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12475
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12475 ;
Copy
77
0.24 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12475
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12475 ;
Copy
78
0.15 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12475
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12475 ;
Copy
79
0.23 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12475
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12475 ;
Copy
80
0.18 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '12426' ;
Copy
81
0.13 ms
SELECT url_file FROM news WHERE idnew = 12426
SELECT url_file FROM news WHERE idnew = 12426 ;
Copy
82
0.21 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12426 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12426 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
83
0.27 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12426 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12426 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
84
0.19 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12426
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12426 ;
Copy
85
0.21 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12426
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12426 ;
Copy
86
0.24 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12426
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12426 ;
Copy
87
0.26 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12426
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12426 ;
Copy
88
0.19 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '12120' ;
Copy
89
0.14 ms
SELECT url_file FROM news WHERE idnew = 12120
SELECT url_file FROM news WHERE idnew = 12120 ;
Copy
90
0.18 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12120 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12120 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
91
0.19 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12120 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12120 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
92
0.18 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12120
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12120 ;
Copy
93
0.26 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12120
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12120 ;
Copy
94
0.19 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12120
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12120 ;
Copy
95
0.16 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12120
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12120 ;
Copy
96
0.21 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '11997' ;
Copy
97
0.13 ms
SELECT url_file FROM news WHERE idnew = 11997
SELECT url_file FROM news WHERE idnew = 11997 ;
Copy
98
0.37 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 11997 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 11997 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
99
0.27 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 11997 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 11997 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
100
0.23 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 11997
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 11997 ;
Copy
101
0.21 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 11997
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 11997 ;
Copy
102
0.19 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 11997
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 11997 ;
Copy
103
0.15 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 11997
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 11997 ;
Copy
104
0.31 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '11298' ;
Copy
105
0.14 ms
SELECT url_file FROM news WHERE idnew = 11298
SELECT url_file FROM news WHERE idnew = 11298 ;
Copy
106
0.20 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 11298 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 11298 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
107
0.23 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 11298 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 11298 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
108
0.19 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 11298
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 11298 ;
Copy
109
0.16 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 11298
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 11298 ;
Copy
110
0.29 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 11298
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 11298 ;
Copy
111
0.18 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 11298
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 11298 ;
Copy
112
0.30 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '10776' ;
Copy
113
0.26 ms
SELECT url_file FROM news WHERE idnew = 10776
SELECT url_file FROM news WHERE idnew = 10776 ;
Copy
114
0.27 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10776 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10776 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
115
0.21 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10776 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10776 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
116
0.23 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10776
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10776 ;
Copy
117
0.25 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10776
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10776 ;
Copy
118
0.18 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10776
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10776 ;
Copy
119
0.21 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10776
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10776 ;
Copy
120
0.35 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '10775' ;
Copy
121
0.15 ms
SELECT url_file FROM news WHERE idnew = 10775
SELECT url_file FROM news WHERE idnew = 10775 ;
Copy
122
0.23 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10775 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10775 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
123
0.22 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10775 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10775 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
124
0.20 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10775
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10775 ;
Copy
125
0.27 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10775
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10775 ;
Copy
126
0.16 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10775
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10775 ;
Copy
127
0.16 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10775
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10775 ;
Copy
128
0.21 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '10773' ;
Copy
129
0.10 ms
SELECT url_file FROM news WHERE idnew = 10773
SELECT url_file FROM news WHERE idnew = 10773 ;
Copy
130
0.28 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10773 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10773 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
131
0.20 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10773 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10773 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
132
0.16 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10773
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10773 ;
Copy
133
0.15 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10773
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10773 ;
Copy
134
0.14 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10773
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10773 ;
Copy
135
0.14 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10773
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10773 ;
Copy
136
0.17 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '10768' ;
Copy
137
0.15 ms
SELECT url_file FROM news WHERE idnew = 10768
SELECT url_file FROM news WHERE idnew = 10768 ;
Copy
138
0.18 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10768 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10768 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
139
0.16 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10768 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10768 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
140
0.18 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10768
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10768 ;
Copy
141
0.29 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10768
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10768 ;
Copy
142
0.15 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10768
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10768 ;
Copy
143
0.25 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10768
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10768 ;
Copy
144
0.11 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 = 7498 ;
Copy
145
0.22 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 = 7498 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 = 7498 ORDER BY j2 . classement ASC ;
Copy
146
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 = 9709 ;
Copy
147
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 = 9709 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 = 9709 ORDER BY j2 . classement ASC ;
Copy
148
0.27 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '10622' ;
Copy
149
0.11 ms
SELECT url_file FROM news WHERE idnew = 10622
SELECT url_file FROM news WHERE idnew = 10622 ;
Copy
150
0.17 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10622 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10622 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
151
0.17 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10622 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10622 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
152
0.17 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10622
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10622 ;
Copy
153
0.15 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10622
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10622 ;
Copy
154
0.13 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10622
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10622 ;
Copy
155
0.25 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10622
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10622 ;
Copy
156
0.17 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '10621' ;
Copy
157
0.16 ms
SELECT url_file FROM news WHERE idnew = 10621
SELECT url_file FROM news WHERE idnew = 10621 ;
Copy
158
0.28 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10621 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10621 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
159
0.18 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10621 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10621 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
160
0.17 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10621
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10621 ;
Copy
161
0.16 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10621
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10621 ;
Copy
162
0.21 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10621
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10621 ;
Copy
163
0.20 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10621
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10621 ;
Copy
164
0.21 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '10618' ;
Copy
165
0.08 ms
SELECT url_file FROM news WHERE idnew = 10618
SELECT url_file FROM news WHERE idnew = 10618 ;
Copy
166
0.31 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10618 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10618 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
167
0.21 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10618 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10618 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
168
0.28 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10618
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10618 ;
Copy
169
0.18 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10618
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10618 ;
Copy
170
0.16 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10618
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10618 ;
Copy
171
0.19 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10618
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10618 ;
Copy
172
0.17 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '10580' ;
Copy
173
0.21 ms
SELECT url_file FROM news WHERE idnew = 10580
SELECT url_file FROM news WHERE idnew = 10580 ;
Copy
174
0.18 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10580 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10580 AND sc . date < '2024-04-26' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
175
0.22 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10580 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 10580 AND sc . date < '2024-04-26' AND sc . idcontact = 7006 GROUP BY sc . idcontact ;
Copy
176
0.19 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10580
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 10580 ;
Copy
177
0.17 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10580
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 10580 ;
Copy
178
0.15 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10580
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 10580 ;
Copy
179
0.16 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10580
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 10580 ;
Copy
180
1.00 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
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 7006 ) AND T1 . idnew NOT IN (13175 , 13176 , 13066 , 13043 , 12754 , 12765 , 12475 , 12426 , 12120 , 11997 , 11298 , 10776 , 10775 , 10773 , 10768 , 10622 , 10621 , 10618 , 10580 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 1 AND (( T3 . date > = '2024-04-26' )) GROUP BY T1 . idnew ORDER BY T3 . date ASC LIMIT 0 , 200
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 7006 ) AND T1 . idnew NOT IN (13175 , 13176 , 13066 , 13043 , 12754 , 12765 , 12475 , 12426 , 12120 , 11997 , 11298 , 10776 , 10775 , 10773 , 10768 , 10622 , 10621 , 10618 , 10580 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 1 AND (( T3 . date > = '2024-04-26' )) GROUP BY T1 . idnew ORDER BY T3 . date ASC LIMIT 0 , 200 ;
Copy
181
0.96 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
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 7006 ) AND T1 . idnew NOT IN (13175 , 13176 , 13066 , 13043 , 12754 , 12765 , 12475 , 12426 , 12120 , 11997 , 11298 , 10776 , 10775 , 10773 , 10768 , 10622 , 10621 , 10618 , 10580 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 1 AND (( T3 . date < '2024-04-26' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 200
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 7006 ) AND T1 . idnew NOT IN (13175 , 13176 , 13066 , 13043 , 12754 , 12765 , 12475 , 12426 , 12120 , 11997 , 11298 , 10776 , 10775 , 10773 , 10768 , 10622 , 10621 , 10618 , 10580 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND T1 . type_news = 1 AND (( T3 . date < '2024-04-26' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 200 ;
Copy
182
0.05 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 (9148 , 9150 , 9151 , 9154 , 9155 , 9159 , 9160 , 11313 , 11415 , 15710 , 15711 , 15712 , 15713 , 15714 , 15715 , 15718 , 15726 , 11623 , 5979 , 15963 , 18455 , 18457 , 18458 , 18459 , 18460 , 18461 , 17765 , 21622 , 21624 , 21625 , 14289 , 19144 , 15858 , 21630 , 24248 , 18456 , 15938 , 24649 , 25120 , 25142 , 25227 , 25518 , 25538 , 26226 , 25558 , 27520 , 24106 , 27808 , 28348 , 9105 , 28360 , 28361 , 27836 , 28363 , 28366 , 30297 , 30713 , 29940 , 31213 , 28367 , 28743 , 8757 , 29961 , 28364 , 28362 , 31934 , 32043 , 32315 , 21629 , 32979 , 26976 , 33152 , 33155 , 33156 , 33158 , 33157 , 32802 , 33154 , 31824 , 30296 , 30289 , 29991 , 27151 , 34692 , 34695 , 34696 , 34697 , 34698 , 12497 , 34773 , 35230 , 36822 , 36828 , 36933 , 8292 , 9150 , 9156 , 9158 , 15713 , 15714 , 15715 , 15938 , 18459 , 18460 , 21629 , 24649 , 25120 , 27520 , 28348 , 28360 , 29961 , 31824 , 31934 , 32043 , 32802 , 33156 , 34692 )
) 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 = 7006
)
)
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 (
9148 , 9150 , 9151 , 9154 , 9155 , 9159 , 9160 ,
11313 , 11415 , 15710 , 15711 , 15712 ,
15713 , 15714 , 15715 , 15718 , 15726 ,
11623 , 5979 , 15963 , 18455 , 18457 , 18458 ,
18459 , 18460 , 18461 , 17765 , 21622 ,
21624 , 21625 , 14289 , 19144 , 15858 ,
21630 , 24248 , 18456 , 15938 , 24649 ,
25120 , 25142 , 25227 , 25518 , 25538 ,
26226 , 25558 , 27520 , 24106 , 27808 ,
28348 , 9105 , 28360 , 28361 , 27836 , 28363 ,
28366 , 30297 , 30713 , 29940 , 31213 ,
28367 , 28743 , 8757 , 29961 , 28364 , 28362 ,
31934 , 32043 , 32315 , 21629 , 32979 ,
26976 , 33152 , 33155 , 33156 , 33158 ,
33157 , 32802 , 33154 , 31824 , 30296 ,
30289 , 29991 , 27151 , 34692 , 34695 ,
34696 , 34697 , 34698 , 12497 , 34773 ,
35230 , 36822 , 36828 , 36933 , 8292 , 9150 ,
9156 , 9158 , 15713 , 15714 , 15715 , 15938 ,
18459 , 18460 , 21629 , 24649 , 25120 ,
27520 , 28348 , 28360 , 29961 , 31824 ,
31934 , 32043 , 32802 , 33156 , 34692
)
)
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 = 7006
)
)
Copy
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 (9148 , 9150 , 9151 , 9154 , 9155 , 9159 , 9160 , 11313 , 11415 , 15710 , 15711 , 15712 , 15713 , 15714 , 15715 , 15718 , 15726 , 11623 , 5979 , 15963 , 18455 , 18457 , 18458 , 18459 , 18460 , 18461 , 17765 , 21622 , 21624 , 21625 , 14289 , 19144 , 15858 , 21630 , 24248 , 18456 , 15938 , 24649 , 25120 , 25142 , 25227 , 25518 , 25538 , 26226 , 25558 , 27520 , 24106 , 27808 , 28348 , 9105 , 28360 , 28361 , 27836 , 28363 , 28366 , 30297 , 30713 , 29940 , 31213 , 28367 , 28743 , 8757 , 29961 , 28364 , 28362 , 31934 , 32043 , 32315 , 21629 , 32979 , 26976 , 33152 , 33155 , 33156 , 33158 , 33157 , 32802 , 33154 , 31824 , 30296 , 30289 , 29991 , 27151 , 34692 , 34695 , 34696 , 34697 , 34698 , 12497 , 34773 , 35230 , 36822 , 36828 , 36933 , 8292 , 9150 , 9156 , 9158 , 15713 , 15714 , 15715 , 15938 , 18459 , 18460 , 21629 , 24649 , 25120 , 27520 , 28348 , 28360 , 29961 , 31824 , 31934 , 32043 , 32802 , 33156 , 34692 )
) 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 = 7006
)
);
Copy
183
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
184
0.86 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 = '7006'
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 = '7006'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_presentation_structure' ))) ORDER BY c . `range` , c . idcontent ;
Copy
185
0.03 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
186
0.83 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 = '7006'
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 = '7006'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent ;
Copy
187
0.20 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 2 ;
Copy
188
0.18 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 2 ;
Copy
189
0.16 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 2 ;
Copy
190
0.17 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 2 ;
Copy
191
0.13 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 3
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 3 ;
Copy
192
0.12 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 3
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 3 ;
Copy
193
0.12 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 3
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 3 ;
Copy
194
0.15 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 3
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 3 ;
Copy
195
0.28 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 = 7006
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 = 7006
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
196
0.18 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 1 ;
Copy
197
0.14 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 1 ;
Copy
198
0.21 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 1 ;
Copy
199
0.11 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 1 ;
Copy
200
0.16 ms
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 4
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 4 ;
Copy
201
0.13 ms
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 4
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 4 ;
Copy
202
0.11 ms
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 4
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 4 ;
Copy
203
0.11 ms
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 4
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 7006
AND aides . `type_aide` = 4 ;
Copy
204
0.56 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (7006 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-04-26' AND '2026-04-16' )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (7006 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-04-26' AND '2026-04-16' )) ORDER BY s1_ . date ASC ;
Copy
205
0.47 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (7006 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-04-26' ORDER BY s1_ . date DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (7006 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-04-26' ORDER BY s1_ . date DESC ;
Copy
206
1.27 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-26' AND (s0_ . publish = 1 AND (s1_ . idcontact = 7006 OR s1_ . idcontact_festival = 7006 )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-26' AND (s0_ . publish = 1 AND (s1_ . idcontact = 7006 OR s1_ . idcontact_festival = 7006 )) ORDER BY s1_ . date ASC ;
Copy
207
4.41 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c2_ ON s1_ . idcontact = c2_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND (s0_ . publish = 1 AND (s1_ . idcontact = 7006 OR s1_ . idcontact_festival = 7006 )) ORDER BY s1_ . date DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c2_ ON s1_ . idcontact = c2_ . idcontact WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND (s0_ . publish = 1 AND (s1_ . idcontact = 7006 OR s1_ . idcontact_festival = 7006 )) ORDER BY s1_ . date DESC ;
Copy
208
0.52 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 7006 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 7006 )) ORDER BY sclr_1 DESC ;
Copy
209
103.76 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 7006 OR s0_ . idcontact_production = 7006 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 7006 OR s0_ . idcontact_production = 7006 )) ORDER BY sclr_1 DESC ;
Copy
210
14.66 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-26' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 7006 OR s0_ . idcontact_production = 7006 )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-26' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 7006 OR s0_ . idcontact_production = 7006 )) ORDER BY s1_ . date ASC ;
Copy
211
1.99 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE p8_ . code_franceinter IS NOT NULL AND p8_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-26' AND (s0_ . publish = 1 AND (s1_ . idcontact = 7006 OR s1_ . idcontact_festival = 7006 )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE p8_ . code_franceinter IS NOT NULL AND p8_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-26' AND (s0_ . publish = 1 AND (s1_ . idcontact = 7006 OR s1_ . idcontact_festival = 7006 )) ORDER BY s1_ . date ASC ;
Copy
212
2.13 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c2_ ON s1_ . idcontact = c2_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE p8_ . code_franceinter IS NOT NULL AND p8_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND (s0_ . publish = 1 AND (s1_ . idcontact = 7006 OR s1_ . idcontact_festival = 7006 )) ORDER BY s1_ . date DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c2_ ON s1_ . idcontact = c2_ . idcontact INNER JOIN podcast_spectacle p9_ ON s0_ . idspectacle = p9_ . idspectacle INNER JOIN podcasts p8_ ON p8_ . idpodcast = p9_ . idpodcast WHERE p8_ . code_franceinter IS NOT NULL AND p8_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND (s0_ . publish = 1 AND (s1_ . idcontact = 7006 OR s1_ . idcontact_festival = 7006 )) ORDER BY s1_ . date DESC ;
Copy
213
0.72 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 7006 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 7006 )) ORDER BY sclr_1 DESC ;
Copy
214
16.04 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 7006 OR s0_ . idcontact_production = 7006 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 7006 OR s0_ . idcontact_production = 7006 )) ORDER BY sclr_1 DESC ;
Copy
215
12.62 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-26' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 7006 OR s0_ . idcontact_production = 7006 )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_ . idspectacle = p10_ . idspectacle INNER JOIN podcasts p9_ ON p9_ . idpodcast = p10_ . idpodcast WHERE p9_ . code_franceinter IS NOT NULL AND p9_ . publish = 1 AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date > = '2024-04-26' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 7006 OR s0_ . idcontact_production = 7006 )) ORDER BY s1_ . date ASC ;
Copy
216
0.88 ms
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (7006 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (7006 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC ;
Copy
217
0.60 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 = 7006 ) 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 = 7006 ) AND T1 . publish = 1 ;
Copy
218
0.81 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 (8292 , 9150 , 9156 , 9158 , 15713 , 15714 , 15715 , 15938 , 18459 , 18460 , 21629 , 24649 , 25120 , 27520 , 28348 , 28360 , 29961 , 31824 , 31934 , 32043 , 32802 , 33156 , 34692 , 9148 , 9151 , 9154 , 9155 , 9159 , 9160 , 11313 , 11415 , 15710 , 15711 , 15712 , 15718 , 15726 , 11623 , 5979 , 15963 , 18455 , 18457 , 18458 , 18461 , 17765 , 21622 , 21624 , 21625 , 14289 , 19144 , 15858 , 21630 , 24248 , 18456 , 25142 , 25227 , 25518 , 25538 , 26226 , 25558 , 24106 , 27808 , 9105 , 28361 , 27836 , 28363 , 28366 , 30297 , 30713 , 29940 , 31213 , 28367 , 28743 , 8757 , 28364 , 28362 , 32315 , 32979 , 26976 , 33152 , 33155 , 33158 , 33157 , 33154 , 30296 , 30289 , 29991 , 27151 , 34695 , 34696 , 34697 , 34698 , 12497 , 34773 , 35230 , 36822 , 36828 , 36933 ) 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 (
8292 , 9150 , 9156 , 9158 , 15713 , 15714 ,
15715 , 15938 , 18459 , 18460 , 21629 ,
24649 , 25120 , 27520 , 28348 , 28360 ,
29961 , 31824 , 31934 , 32043 , 32802 ,
33156 , 34692 , 9148 , 9151 , 9154 , 9155 ,
9159 , 9160 , 11313 , 11415 , 15710 , 15711 ,
15712 , 15718 , 15726 , 11623 , 5979 , 15963 ,
18455 , 18457 , 18458 , 18461 , 17765 ,
21622 , 21624 , 21625 , 14289 , 19144 ,
15858 , 21630 , 24248 , 18456 , 25142 ,
25227 , 25518 , 25538 , 26226 , 25558 ,
24106 , 27808 , 9105 , 28361 , 27836 , 28363 ,
28366 , 30297 , 30713 , 29940 , 31213 ,
28367 , 28743 , 8757 , 28364 , 28362 , 32315 ,
32979 , 26976 , 33152 , 33155 , 33158 ,
33157 , 33154 , 30296 , 30289 , 29991 ,
27151 , 34695 , 34696 , 34697 , 34698 ,
12497 , 34773 , 35230 , 36822 , 36828 ,
36933
)
AND d . code_franceinter IS NOT NULL
Copy
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` IN (8292 , 9150 , 9156 , 9158 , 15713 , 15714 , 15715 , 15938 , 18459 , 18460 , 21629 , 24649 , 25120 , 27520 , 28348 , 28360 , 29961 , 31824 , 31934 , 32043 , 32802 , 33156 , 34692 , 9148 , 9151 , 9154 , 9155 , 9159 , 9160 , 11313 , 11415 , 15710 , 15711 , 15712 , 15718 , 15726 , 11623 , 5979 , 15963 , 18455 , 18457 , 18458 , 18461 , 17765 , 21622 , 21624 , 21625 , 14289 , 19144 , 15858 , 21630 , 24248 , 18456 , 25142 , 25227 , 25518 , 25538 , 26226 , 25558 , 24106 , 27808 , 9105 , 28361 , 27836 , 28363 , 28366 , 30297 , 30713 , 29940 , 31213 , 28367 , 28743 , 8757 , 28364 , 28362 , 32315 , 32979 , 26976 , 33152 , 33155 , 33158 , 33157 , 33154 , 30296 , 30289 , 29991 , 27151 , 34695 , 34696 , 34697 , 34698 , 12497 , 34773 , 35230 , 36822 , 36828 , 36933 ) AND d . code_franceinter IS NOT NULL ;
Copy
219
0.23 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 = 7006 ;
Copy
220
11.95 ms
SELECT COUNT (DISTINCT (spectacles . `idspectacle` )) as total FROM schedules , spectacles JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 7006 OR schedules . idcontact_festival = 7006 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 )
SELECT COUNT (DISTINCT (spectacles . `idspectacle` )) as total FROM schedules , spectacles JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 7006 OR schedules . idcontact_festival = 7006 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 ) ;
Copy
221
11.67 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` = 7006 OR spectacles . `idcontact_production` = 7006 ) 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` = 7006 OR spectacles . `idcontact_production` = 7006 ) 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
222
0.10 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
223
0.07 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
224
0.50 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 = '7006'
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 = '7006'
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
225
0.30 ms
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 7006
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 7006 ;
Copy
226
0.56 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 :
[
"7944f2c5cb09139a6d061b63e7c7d8dd-0c49 "
0
"121686fcd6fc831ea2ab925be909c390 "
]
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 = '7944f2c5cb09139a6d061b63e7c7d8dd-0c49' AND t0 . idcontent = 0 AND t0 . md5url = '121686fcd6fc831ea2ab925be909c390' ;
Copy
227
2.25 ms
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/contacts/Theatre-de-l-Iris/evenements "
"121686fcd6fc831ea2ab925be909c390 "
0
"contacts "
7006
0
"fr "
"7944f2c5cb09139a6d061b63e7c7d8dd-0c49 "
"/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/Theatre-de-l-Iris/evenements' , '121686fcd6fc831ea2ab925be909c390' , 0 , 'contacts' , 7006 , 0 , 'fr' , '7944f2c5cb09139a6d061b63e7c7d8dd-0c49' , '/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829' );
Copy
228
2.11 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