1 |
0.26 ms |
SELECT idcontact FROM contacts WHERE url_clean='Kazalma-Editions'
SELECT idcontact FROM contacts WHERE url_clean='Kazalma-Editions' ;
|
2 |
0.84 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 = ?
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 = '9792';
|
3 |
0.06 ms |
SELECT fr FROM countries WHERE id='CH'
SELECT fr FROM countries WHERE id='CH';
|
4 |
0.45 ms |
SELECT fr FROM countries WHERE id='Suisse'
SELECT fr FROM countries WHERE id='Suisse';
|
5 |
0.07 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;
|
6 |
1.18 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='9792'
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='9792'
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;
|
7 |
0.07 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;
|
8 |
0.88 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='9792'
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='9792'
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;
|
9 |
0.41 ms |
SELECT COUNT(DISTINCT(m.idmultimedia))
FROM object_multimedia om, multimedias m
WHERE om.idmultimedia=m.idmultimedia
AND om.idobject=9792
AND om.object='contacts'
AND m.publish=1 AND m.audio_video=2
SELECT COUNT(DISTINCT(m.idmultimedia))
FROM object_multimedia om, multimedias m
WHERE om.idmultimedia=m.idmultimedia
AND om.idobject=9792
AND om.object='contacts'
AND m.publish=1 AND m.audio_video=2;
|
10 |
0.44 ms |
SELECT COUNT(DISTINCT(T1.idperson)) as total FROM persons T1
JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
JOIN texts t ON t.`idtext`=T2.`idtext`
WHERE 1 AND t.`idcontact_publisher` IN ('9792') AND T1.`publish`=1
SELECT COUNT(DISTINCT(T1.idperson)) as total FROM persons T1
JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
JOIN texts t ON t.`idtext`=T2.`idtext`
WHERE 1 AND t.`idcontact_publisher` IN ('9792') AND T1.`publish`=1 ;
|
11 |
0.25 ms |
SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=9792
SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=9792;
|
12 |
0.95 ms |
SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=9792
SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=9792;
|
13 |
0.30 ms |
SELECT tt.idtext FROM text_traduction tt, texts t
WHERE t.idtext=tt.idtext
AND (t.idgenretext=1 OR t.idgenretext IS NULL)
AND tt.idtexttraduction IN (14772,14773,14774)
SELECT tt.idtext FROM text_traduction tt, texts t
WHERE t.idtext=tt.idtext
AND (t.idgenretext=1 OR t.idgenretext IS NULL)
AND tt.idtexttraduction IN (14772,14773,14774);
|
14 |
0.31 ms |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (3841,4197,8630,8924,10903,10906,10907,10909,10910,10912,10913,13781) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (3841,4197,8630,8924,10903,10906,10907,10909,10910,10912,10913,13781) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;
|
15 |
0.04 ms |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (3841,4197,8630,8924,10903,10906,10907,10909,10910,10912,10913,13781) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (3841,4197,8630,8924,10903,10906,10907,10909,10910,10912,10913,13781) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;
|
16 |
0.37 ms |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (14772,14773,14774) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (14772,14773,14774) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;
|
17 |
0.12 ms |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (14772,14773,14774) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (14772,14773,14774) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;
|
18 |
0.72 ms |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1,contacts T2 WHERE 1 AND T2.idcontact=T1.idcontact_publisher AND T1.idcontact_publisher=9792 ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1,contacts T2 WHERE 1 AND T2.idcontact=T1.idcontact_publisher AND T1.idcontact_publisher=9792 ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;
|
19 |
0.78 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=9792 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND (( T3.date>='2024-04-28' ))
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=9792 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND (( T3.date>='2024-04-28' )) ;
|
20 |
0.55 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=9792 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND (( T3.date<'2024-04-28' ))
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=9792 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND (( T3.date<'2024-04-28' )) ;
|
21 |
2.38 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 BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 9792 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 BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 9792 ORDER BY s1_.date ASC;
|
22 |
4.20 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 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 c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 9792 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 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 c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 9792 ORDER BY s1_.date ASC;
|
23 |
4.11 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 (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 9792 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 9792 ORDER BY s1_.date ASC;
|
24 |
2.24 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 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 c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 9792 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 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 c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 9792 ORDER BY s1_.date ASC;
|
25 |
1.09 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 object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 9792 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 object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 9792 ORDER BY s1_.date ASC;
|
26 |
1.93 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 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 c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_multimedia o9_ ON (s0_.idspectacle = o9_.idobject) LEFT JOIN multimedias m10_ ON (m10_.idmultimedia = o9_.idmultimedia) LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c11_ ON (c11_.idcontent = o2_.idcontent) LEFT JOIN content_classification c13_ ON c11_.idcontent = c13_.idcontent LEFT JOIN classifications c12_ ON c12_.idclassification = c13_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND o9_.object = 'spectacles' AND m10_.publish = 1 AND (c11_.valid = 1 AND c11_.publish = 1) AND c12_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c11_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 9792 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 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 c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_multimedia o9_ ON (s0_.idspectacle = o9_.idobject) LEFT JOIN multimedias m10_ ON (m10_.idmultimedia = o9_.idmultimedia) LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c11_ ON (c11_.idcontent = o2_.idcontent) LEFT JOIN content_classification c13_ ON c11_.idcontent = c13_.idcontent LEFT JOIN classifications c12_ ON c12_.idclassification = c13_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND o9_.object = 'spectacles' AND m10_.publish = 1 AND (c11_.valid = 1 AND c11_.publish = 1) AND c12_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c11_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 9792 ORDER BY s1_.date ASC;
|
27 |
1.07 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 object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 9792 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 object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 9792 ORDER BY s1_.date ASC;
|
28 |
0.38 ms |
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=2
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=2 ;
|
29 |
0.23 ms |
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=2
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=2 ;
|
30 |
0.23 ms |
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=2
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=2 ;
|
31 |
0.32 ms |
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=2
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=2 ;
|
32 |
0.20 ms |
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=3
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=3 ;
|
33 |
0.36 ms |
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=3
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=3 ;
|
34 |
0.23 ms |
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=3
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=3 ;
|
35 |
0.24 ms |
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=3
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=3 ;
|
36 |
0.22 ms |
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=1
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=1 ;
|
37 |
0.22 ms |
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=1
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=1 ;
|
38 |
0.40 ms |
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=1
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=1 ;
|
39 |
0.22 ms |
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=1
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=1 ;
|
40 |
0.29 ms |
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=4
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=4 ;
|
41 |
0.21 ms |
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=4
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=4 ;
|
42 |
0.22 ms |
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=4
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=4 ;
|
43 |
0.19 ms |
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=4
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=9792
AND aides.`type_aide`=4 ;
|
44 |
0.05 ms |
SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=9792
SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=9792;
|
45 |
0.04 ms |
SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=9792
SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=9792;
|
46 |
0.08 ms |
SELECT tt.idtext FROM text_traduction tt, texts t
WHERE t.idtext=tt.idtext
AND (t.idgenretext=1 OR t.idgenretext IS NULL)
AND tt.idtexttraduction IN (14772,14773,14774)
SELECT tt.idtext FROM text_traduction tt, texts t
WHERE t.idtext=tt.idtext
AND (t.idgenretext=1 OR t.idgenretext IS NULL)
AND tt.idtexttraduction IN (14772,14773,14774);
|
47 |
0.76 ms |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.idcontact_publisher=9792 ORDER BY T1.publication_year DESC, T1.publication_month DESC
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.idcontact_publisher=9792 ORDER BY T1.publication_year DESC, T1.publication_month DESC ;
|
48 |
1.36 ms |
SELECT DISTINCT(T1.`idtext`), T1.`title`,T1.`url_clean`,T1.`publication_year`,T1.`publication_month`,T1.`isbn`,T1.`textfictif`,T1.`dateinsert`,T1.`textorder`,T1.`type`,T1.`publish`,T1.`statut`,T1.`valid`,T2.`idcontact`,T2.`url_clean` as `url_clean_publisher`,T2.`organisation`,
CONCAT(T1.`publication_year`, T1.`publication_month`) AS publication_date,
CAST(CONCAT(T1.`publication_year`, T1.`publication_month`) AS DATE) AS publication_date_full FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.idcontact_publisher=9792 GROUP BY T1.idtext ORDER BY T1.publication_year DESC, T1.publication_month DESC LIMIT 0,20
SELECT DISTINCT(T1.`idtext`), T1.`title`,T1.`url_clean`,T1.`publication_year`,T1.`publication_month`,T1.`isbn`,T1.`textfictif`,T1.`dateinsert`,T1.`textorder`,T1.`type`,T1.`publish`,T1.`statut`,T1.`valid`,T2.`idcontact`,T2.`url_clean` as `url_clean_publisher`,T2.`organisation`,
CONCAT(T1.`publication_year`, T1.`publication_month`) AS publication_date,
CAST(CONCAT(T1.`publication_year`, T1.`publication_month`) AS DATE) AS publication_date_full FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.idcontact_publisher=9792 GROUP BY T1.idtext ORDER BY T1.publication_year DESC, T1.publication_month DESC LIMIT 0,20;
|
49 |
0.19 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 = '14772';
|
50 |
0.28 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14772
ORDER BY t.title
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14772
ORDER BY t.title;
|
51 |
0.32 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=14769 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=14769 ORDER BY j2.classement ASC;
|
52 |
0.31 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=14772 ORDER BY j2.classement ASC
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=14772 ORDER BY j2.classement ASC;
|
53 |
0.14 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14772
ORDER BY t.title
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14772
ORDER BY t.title;
|
54 |
0.27 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 = '14773';
|
55 |
0.44 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14773
ORDER BY t.title
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14773
ORDER BY t.title;
|
56 |
0.30 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=14770 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=14770 ORDER BY j2.classement ASC;
|
57 |
0.27 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=14773 ORDER BY j2.classement ASC
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=14773 ORDER BY j2.classement ASC;
|
58 |
0.05 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14773
ORDER BY t.title
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14773
ORDER BY t.title;
|
59 |
0.27 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 = '14774';
|
60 |
0.30 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14774
ORDER BY t.title
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14774
ORDER BY t.title;
|
61 |
0.30 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=14771 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=14771 ORDER BY j2.classement ASC;
|
62 |
0.34 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=14774 ORDER BY j2.classement ASC
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=14774 ORDER BY j2.classement ASC;
|
63 |
0.05 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14774
ORDER BY t.title
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=14774
ORDER BY t.title;
|
64 |
0.15 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = '13781';
|
65 |
0.34 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=13781 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=13781 ORDER BY j2.classement ASC;
|
66 |
0.69 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 = '8924';
|
67 |
0.37 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=8924 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=8924 ORDER BY j2.classement ASC;
|
68 |
0.48 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 = '10903';
|
69 |
0.59 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=10903 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=10903 ORDER BY j2.classement ASC;
|
70 |
0.31 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 = '10906';
|
71 |
0.34 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=10906 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=10906 ORDER BY j2.classement ASC;
|
72 |
0.16 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 = '10907';
|
73 |
0.30 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=10907 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=10907 ORDER BY j2.classement ASC;
|
74 |
0.19 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 = '10912';
|
75 |
0.50 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=10912 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=10912 ORDER BY j2.classement ASC;
|
76 |
0.17 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 = '10913';
|
77 |
0.51 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=10913 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=10913 ORDER BY j2.classement ASC;
|
78 |
0.20 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 = '3841';
|
79 |
0.32 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=3841 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=3841 ORDER BY j2.classement ASC;
|
80 |
0.14 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 = '4197';
|
81 |
0.41 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=4197 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=4197 ORDER BY j2.classement ASC;
|
82 |
0.14 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 = '8630';
|
83 |
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=8630 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=8630 ORDER BY j2.classement ASC;
|
84 |
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 = '10909';
|
85 |
0.20 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=10909 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=10909 ORDER BY j2.classement ASC;
|
86 |
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 = '10910';
|
87 |
0.19 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=10910 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=10910 ORDER BY j2.classement ASC;
|
88 |
0.05 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) ;
|
89 |
0.36 ms |
SELECT COUNT(DISTINCT(of.idfile)) as total
FROM object_file of,
files f,
file_classification fc,
classifications cl,typesfiles tf
WHERE of.idfile=f.idfile
AND f.idfile=fc.idfile
AND of.idobject='9792'
AND of.object='contacts'
AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (112,168))) 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='9792'
AND of.object='contacts'
AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (112,168))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype;
|
90 |
2.58 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;
|