1 |
0.33 ms |
SELECT idtext FROM texts WHERE url_clean='Misterioso-119'
SELECT idtext FROM texts WHERE url_clean='Misterioso-119' ;
|
2 |
2.44 ms |
SELECT t0_.idtext AS idtext_0, t0_.type AS type_1, t0_.idtypetext AS idtypetext_2, t0_.special_text AS special_text_3, t0_.title AS title_4, t0_.subtitle AS subtitle_5, t0_.date AS date_6, t0_.language AS language_7, t0_.markdown AS markdown_8, t0_.abstract AS abstract_9, t0_.abstract_author AS abstract_author_10, t0_.abstract_date AS abstract_date_11, t0_.abstract_url AS abstract_url_12, t0_.publisher_url_text AS publisher_url_text_13, t0_.publication_year AS publication_year_14, t0_.publication_month AS publication_month_15, t0_.isbn AS isbn_16, t0_.ean AS ean_17, t0_.publishinfos AS publishinfos_18, t0_.urltextaccess AS urltextaccess_19, t0_.emailtextaccess AS emailtextaccess_20, t0_.idfiletextaccess AS idfiletextaccess_21, t0_.filetextaccesssave AS filetextaccesssave_22, t0_.textaccessmore AS textaccessmore_23, t0_.request_translation_text AS request_translation_text_24, t0_.request_performing_text AS request_performing_text_25, t0_.help_translation AS help_translation_26, t0_.help_publishing AS help_publishing_27, t0_.help_other AS help_other_28, t0_.moreinfo AS moreinfo_29, t0_.nmale AS nmale_30, t0_.nfemale AS nfemale_31, t0_.npeople AS npeople_32, t0_.textorder AS textorder_33, t0_.nbpages AS nbpages_34, t0_.price AS price_35, t0_.selection_aneth AS selection_aneth_36, t0_.idtext_aneth AS idtext_aneth_37, t0_.aide_creation AS aide_creation_38, t0_.comments AS comments_39, t0_.url_clean AS url_clean_40, t0_.textfictif AS textfictif_41, t0_.valid_opendata AS valid_opendata_42, t0_.dateupdate AS dateupdate_43, t0_.dateinsert AS dateinsert_44, t0_.publish AS publish_45, t0_.statut AS statut_46, t0_.valid AS valid_47, e1_.idextranetuser AS idextranetuser_48, e1_.lastname AS lastname_49, e1_.firstname AS firstname_50, e1_.avatar AS avatar_51, e1_.signature AS signature_52, e1_.email AS email_53, e1_.token AS token_54, e1_.public_api_token AS public_api_token_55, e1_.public_api_desc AS public_api_desc_56, e1_.address AS address_57, e1_.zip AS zip_58, e1_.city AS city_59, e1_.secteur AS secteur_60, e1_.structure AS structure_61, e1_.fonction AS fonction_62, e1_.phone AS phone_63, e1_.enseignant_fonction AS enseignant_fonction_64, e1_.enseignant_matiere AS enseignant_matiere_65, e1_.enseignant_etablissement AS enseignant_etablissement_66, e1_.enseignant_qualite AS enseignant_qualite_67, e1_.enseignant_precision_qualite AS enseignant_precision_qualite_68, e1_.enseignant_active AS enseignant_active_69, e1_.stats_acces AS stats_acces_70, e1_.alerte_bac AS alerte_bac_71, e1_.email_validation AS email_validation_72, e1_.connexion_theduc AS connexion_theduc_73, e1_.inscription_from AS inscription_from_74, e1_.private_comment AS private_comment_75, e1_.login AS login_76, e1_.other_email AS other_email_77, e1_.code_chge_email AS code_chge_email_78, e1_.old_login AS old_login_79, e1_.password AS password_80, e1_.thnetuser AS thnetuser_81, e1_.last_visit_annonces AS last_visit_annonces_82, e1_.address_ip AS address_ip_83, e1_.verified AS verified_84, e1_.activekey AS activekey_85, e1_.token_cookie AS token_cookie_86, e1_.date_resend AS date_resend_87, e1_.tokenpass AS tokenpass_88, e1_.sub_subscriber_id AS sub_subscriber_id_89, e1_.userrights AS userrights_90, e1_.special_user AS special_user_91, e1_.pseudo_streaming AS pseudo_streaming_92, e1_.contact_owner AS contact_owner_93, e1_.justification AS justification_94, e1_.sent AS sent_95, e1_.dateupdate AS dateupdate_96, e1_.dateinsert AS dateinsert_97, e1_.active AS active_98, c2_.idcontact AS idcontact_99, c2_.type AS type_100, c2_.organisation AS organisation_101, c2_.nom_suite AS nom_suite_102, c2_.lastname AS lastname_103, c2_.firstname AS firstname_104, c2_.idtypestructure AS idtypestructure_105, c2_.license AS license_106, c2_.comment AS comment_107, c2_.private_comment AS private_comment_108, c2_.address1 AS address1_109, c2_.address2 AS address2_110, c2_.zip AS zip_111, c2_.city AS city_112, c2_.phone1 AS phone1_113, c2_.phone2 AS phone2_114, c2_.fax AS fax_115, c2_.email1 AS email1_116, c2_.email1_online AS email1_online_117, c2_.email2_online AS email2_online_118, c2_.email2 AS email2_119, c2_.url AS url_120, c2_.url_ticket AS url_ticket_121, c2_.facebook AS facebook_122, c2_.twitter AS twitter_123, c2_.instagram AS instagram_124, c2_.mobile AS mobile_125, c2_.geocodable AS geocodable_126, c2_.x AS x_127, c2_.y AS y_128, c2_.idmultimedia AS idmultimedia_129, c2_.type_view AS type_view_130, c2_.stats_access AS stats_access_131, c2_.ga_tracking_id AS ga_tracking_id_132, c2_.is_festival AS is_festival_133, c2_.link_on_video AS link_on_video_134, c2_.is_partenaire AS is_partenaire_135, c2_.valid_version AS valid_version_136, c2_.other_versions AS other_versions_137, c2_.url_redirect AS url_redirect_138, c2_.url_clean AS url_clean_139, c2_.dateupdate AS dateupdate_140, c2_.dateinsert AS dateinsert_141, c2_.publish AS publish_142, c2_.valid AS valid_143, g3_.idgenretext AS idgenretext_144, g3_.genretext AS genretext_145, g3_.ordergenre AS ordergenre_146, g3_.visibility AS visibility_147, c4_.id AS id_148, c4_.fr AS fr_149, c4_.en AS en_150, c4_.es AS es_151, c4_.pt AS pt_152, c4_.de AS de_153, c4_.ru AS ru_154, c4_.orderby AS orderby_155 FROM texts t0_ LEFT JOIN extranetusers e1_ ON t0_.idextranetuser = e1_.idextranetuser LEFT JOIN contacts c2_ ON t0_.idcontact_publisher = c2_.idcontact LEFT JOIN genretexts g3_ ON t0_.idgenretext = g3_.idgenretext LEFT JOIN contacts c5_ ON t0_.idcontact_performing = c5_.idcontact LEFT JOIN countries c4_ ON t0_.country = c4_.id WHERE t0_.idtext = ?
SELECT
t0_.idtext AS idtext_0,
t0_.type AS type_1,
t0_.idtypetext AS idtypetext_2,
t0_.special_text AS special_text_3,
t0_.title AS title_4,
t0_.subtitle AS subtitle_5,
t0_.date AS date_6,
t0_.language AS language_7,
t0_.markdown AS markdown_8,
t0_.abstract AS abstract_9,
t0_.abstract_author AS abstract_author_10,
t0_.abstract_date AS abstract_date_11,
t0_.abstract_url AS abstract_url_12,
t0_.publisher_url_text AS publisher_url_text_13,
t0_.publication_year AS publication_year_14,
t0_.publication_month AS publication_month_15,
t0_.isbn AS isbn_16,
t0_.ean AS ean_17,
t0_.publishinfos AS publishinfos_18,
t0_.urltextaccess AS urltextaccess_19,
t0_.emailtextaccess AS emailtextaccess_20,
t0_.idfiletextaccess AS idfiletextaccess_21,
t0_.filetextaccesssave AS filetextaccesssave_22,
t0_.textaccessmore AS textaccessmore_23,
t0_.request_translation_text AS request_translation_text_24,
t0_.request_performing_text AS request_performing_text_25,
t0_.help_translation AS help_translation_26,
t0_.help_publishing AS help_publishing_27,
t0_.help_other AS help_other_28,
t0_.moreinfo AS moreinfo_29,
t0_.nmale AS nmale_30,
t0_.nfemale AS nfemale_31,
t0_.npeople AS npeople_32,
t0_.textorder AS textorder_33,
t0_.nbpages AS nbpages_34,
t0_.price AS price_35,
t0_.selection_aneth AS selection_aneth_36,
t0_.idtext_aneth AS idtext_aneth_37,
t0_.aide_creation AS aide_creation_38,
t0_.comments AS comments_39,
t0_.url_clean AS url_clean_40,
t0_.textfictif AS textfictif_41,
t0_.valid_opendata AS valid_opendata_42,
t0_.dateupdate AS dateupdate_43,
t0_.dateinsert AS dateinsert_44,
t0_.publish AS publish_45,
t0_.statut AS statut_46,
t0_.valid AS valid_47,
e1_.idextranetuser AS idextranetuser_48,
e1_.lastname AS lastname_49,
e1_.firstname AS firstname_50,
e1_.avatar AS avatar_51,
e1_.signature AS signature_52,
e1_.email AS email_53,
e1_.token AS token_54,
e1_.public_api_token AS public_api_token_55,
e1_.public_api_desc AS public_api_desc_56,
e1_.address AS address_57,
e1_.zip AS zip_58,
e1_.city AS city_59,
e1_.secteur AS secteur_60,
e1_.structure AS structure_61,
e1_.fonction AS fonction_62,
e1_.phone AS phone_63,
e1_.enseignant_fonction AS enseignant_fonction_64,
e1_.enseignant_matiere AS enseignant_matiere_65,
e1_.enseignant_etablissement AS enseignant_etablissement_66,
e1_.enseignant_qualite AS enseignant_qualite_67,
e1_.enseignant_precision_qualite AS enseignant_precision_qualite_68,
e1_.enseignant_active AS enseignant_active_69,
e1_.stats_acces AS stats_acces_70,
e1_.alerte_bac AS alerte_bac_71,
e1_.email_validation AS email_validation_72,
e1_.connexion_theduc AS connexion_theduc_73,
e1_.inscription_from AS inscription_from_74,
e1_.private_comment AS private_comment_75,
e1_.login AS login_76,
e1_.other_email AS other_email_77,
e1_.code_chge_email AS code_chge_email_78,
e1_.old_login AS old_login_79,
e1_.password AS password_80,
e1_.thnetuser AS thnetuser_81,
e1_.last_visit_annonces AS last_visit_annonces_82,
e1_.address_ip AS address_ip_83,
e1_.verified AS verified_84,
e1_.activekey AS activekey_85,
e1_.token_cookie AS token_cookie_86,
e1_.date_resend AS date_resend_87,
e1_.tokenpass AS tokenpass_88,
e1_.sub_subscriber_id AS sub_subscriber_id_89,
e1_.userrights AS userrights_90,
e1_.special_user AS special_user_91,
e1_.pseudo_streaming AS pseudo_streaming_92,
e1_.contact_owner AS contact_owner_93,
e1_.justification AS justification_94,
e1_.sent AS sent_95,
e1_.dateupdate AS dateupdate_96,
e1_.dateinsert AS dateinsert_97,
e1_.active AS active_98,
c2_.idcontact AS idcontact_99,
c2_.type AS type_100,
c2_.organisation AS organisation_101,
c2_.nom_suite AS nom_suite_102,
c2_.lastname AS lastname_103,
c2_.firstname AS firstname_104,
c2_.idtypestructure AS idtypestructure_105,
c2_.license AS license_106,
c2_.comment AS comment_107,
c2_.private_comment AS private_comment_108,
c2_.address1 AS address1_109,
c2_.address2 AS address2_110,
c2_.zip AS zip_111,
c2_.city AS city_112,
c2_.phone1 AS phone1_113,
c2_.phone2 AS phone2_114,
c2_.fax AS fax_115,
c2_.email1 AS email1_116,
c2_.email1_online AS email1_online_117,
c2_.email2_online AS email2_online_118,
c2_.email2 AS email2_119,
c2_.url AS url_120,
c2_.url_ticket AS url_ticket_121,
c2_.facebook AS facebook_122,
c2_.twitter AS twitter_123,
c2_.instagram AS instagram_124,
c2_.mobile AS mobile_125,
c2_.geocodable AS geocodable_126,
c2_.x AS x_127,
c2_.y AS y_128,
c2_.idmultimedia AS idmultimedia_129,
c2_.type_view AS type_view_130,
c2_.stats_access AS stats_access_131,
c2_.ga_tracking_id AS ga_tracking_id_132,
c2_.is_festival AS is_festival_133,
c2_.link_on_video AS link_on_video_134,
c2_.is_partenaire AS is_partenaire_135,
c2_.valid_version AS valid_version_136,
c2_.other_versions AS other_versions_137,
c2_.url_redirect AS url_redirect_138,
c2_.url_clean AS url_clean_139,
c2_.dateupdate AS dateupdate_140,
c2_.dateinsert AS dateinsert_141,
c2_.publish AS publish_142,
c2_.valid AS valid_143,
g3_.idgenretext AS idgenretext_144,
g3_.genretext AS genretext_145,
g3_.ordergenre AS ordergenre_146,
g3_.visibility AS visibility_147,
c4_.id AS id_148,
c4_.fr AS fr_149,
c4_.en AS en_150,
c4_.es AS es_151,
c4_.pt AS pt_152,
c4_.de AS de_153,
c4_.ru AS ru_154,
c4_.orderby AS orderby_155
FROM
texts t0_
LEFT JOIN extranetusers e1_ ON t0_.idextranetuser = e1_.idextranetuser
LEFT JOIN contacts c2_ ON t0_.idcontact_publisher = c2_.idcontact
LEFT JOIN genretexts g3_ ON t0_.idgenretext = g3_.idgenretext
LEFT JOIN contacts c5_ ON t0_.idcontact_performing = c5_.idcontact
LEFT JOIN countries c4_ ON t0_.country = c4_.id
WHERE
t0_.idtext = ?
SELECT t0_.idtext AS idtext_0, t0_.type AS type_1, t0_.idtypetext AS idtypetext_2, t0_.special_text AS special_text_3, t0_.title AS title_4, t0_.subtitle AS subtitle_5, t0_.date AS date_6, t0_.language AS language_7, t0_.markdown AS markdown_8, t0_.abstract AS abstract_9, t0_.abstract_author AS abstract_author_10, t0_.abstract_date AS abstract_date_11, t0_.abstract_url AS abstract_url_12, t0_.publisher_url_text AS publisher_url_text_13, t0_.publication_year AS publication_year_14, t0_.publication_month AS publication_month_15, t0_.isbn AS isbn_16, t0_.ean AS ean_17, t0_.publishinfos AS publishinfos_18, t0_.urltextaccess AS urltextaccess_19, t0_.emailtextaccess AS emailtextaccess_20, t0_.idfiletextaccess AS idfiletextaccess_21, t0_.filetextaccesssave AS filetextaccesssave_22, t0_.textaccessmore AS textaccessmore_23, t0_.request_translation_text AS request_translation_text_24, t0_.request_performing_text AS request_performing_text_25, t0_.help_translation AS help_translation_26, t0_.help_publishing AS help_publishing_27, t0_.help_other AS help_other_28, t0_.moreinfo AS moreinfo_29, t0_.nmale AS nmale_30, t0_.nfemale AS nfemale_31, t0_.npeople AS npeople_32, t0_.textorder AS textorder_33, t0_.nbpages AS nbpages_34, t0_.price AS price_35, t0_.selection_aneth AS selection_aneth_36, t0_.idtext_aneth AS idtext_aneth_37, t0_.aide_creation AS aide_creation_38, t0_.comments AS comments_39, t0_.url_clean AS url_clean_40, t0_.textfictif AS textfictif_41, t0_.valid_opendata AS valid_opendata_42, t0_.dateupdate AS dateupdate_43, t0_.dateinsert AS dateinsert_44, t0_.publish AS publish_45, t0_.statut AS statut_46, t0_.valid AS valid_47, e1_.idextranetuser AS idextranetuser_48, e1_.lastname AS lastname_49, e1_.firstname AS firstname_50, e1_.avatar AS avatar_51, e1_.signature AS signature_52, e1_.email AS email_53, e1_.token AS token_54, e1_.public_api_token AS public_api_token_55, e1_.public_api_desc AS public_api_desc_56, e1_.address AS address_57, e1_.zip AS zip_58, e1_.city AS city_59, e1_.secteur AS secteur_60, e1_.structure AS structure_61, e1_.fonction AS fonction_62, e1_.phone AS phone_63, e1_.enseignant_fonction AS enseignant_fonction_64, e1_.enseignant_matiere AS enseignant_matiere_65, e1_.enseignant_etablissement AS enseignant_etablissement_66, e1_.enseignant_qualite AS enseignant_qualite_67, e1_.enseignant_precision_qualite AS enseignant_precision_qualite_68, e1_.enseignant_active AS enseignant_active_69, e1_.stats_acces AS stats_acces_70, e1_.alerte_bac AS alerte_bac_71, e1_.email_validation AS email_validation_72, e1_.connexion_theduc AS connexion_theduc_73, e1_.inscription_from AS inscription_from_74, e1_.private_comment AS private_comment_75, e1_.login AS login_76, e1_.other_email AS other_email_77, e1_.code_chge_email AS code_chge_email_78, e1_.old_login AS old_login_79, e1_.password AS password_80, e1_.thnetuser AS thnetuser_81, e1_.last_visit_annonces AS last_visit_annonces_82, e1_.address_ip AS address_ip_83, e1_.verified AS verified_84, e1_.activekey AS activekey_85, e1_.token_cookie AS token_cookie_86, e1_.date_resend AS date_resend_87, e1_.tokenpass AS tokenpass_88, e1_.sub_subscriber_id AS sub_subscriber_id_89, e1_.userrights AS userrights_90, e1_.special_user AS special_user_91, e1_.pseudo_streaming AS pseudo_streaming_92, e1_.contact_owner AS contact_owner_93, e1_.justification AS justification_94, e1_.sent AS sent_95, e1_.dateupdate AS dateupdate_96, e1_.dateinsert AS dateinsert_97, e1_.active AS active_98, c2_.idcontact AS idcontact_99, c2_.type AS type_100, c2_.organisation AS organisation_101, c2_.nom_suite AS nom_suite_102, c2_.lastname AS lastname_103, c2_.firstname AS firstname_104, c2_.idtypestructure AS idtypestructure_105, c2_.license AS license_106, c2_.comment AS comment_107, c2_.private_comment AS private_comment_108, c2_.address1 AS address1_109, c2_.address2 AS address2_110, c2_.zip AS zip_111, c2_.city AS city_112, c2_.phone1 AS phone1_113, c2_.phone2 AS phone2_114, c2_.fax AS fax_115, c2_.email1 AS email1_116, c2_.email1_online AS email1_online_117, c2_.email2_online AS email2_online_118, c2_.email2 AS email2_119, c2_.url AS url_120, c2_.url_ticket AS url_ticket_121, c2_.facebook AS facebook_122, c2_.twitter AS twitter_123, c2_.instagram AS instagram_124, c2_.mobile AS mobile_125, c2_.geocodable AS geocodable_126, c2_.x AS x_127, c2_.y AS y_128, c2_.idmultimedia AS idmultimedia_129, c2_.type_view AS type_view_130, c2_.stats_access AS stats_access_131, c2_.ga_tracking_id AS ga_tracking_id_132, c2_.is_festival AS is_festival_133, c2_.link_on_video AS link_on_video_134, c2_.is_partenaire AS is_partenaire_135, c2_.valid_version AS valid_version_136, c2_.other_versions AS other_versions_137, c2_.url_redirect AS url_redirect_138, c2_.url_clean AS url_clean_139, c2_.dateupdate AS dateupdate_140, c2_.dateinsert AS dateinsert_141, c2_.publish AS publish_142, c2_.valid AS valid_143, g3_.idgenretext AS idgenretext_144, g3_.genretext AS genretext_145, g3_.ordergenre AS ordergenre_146, g3_.visibility AS visibility_147, c4_.id AS id_148, c4_.fr AS fr_149, c4_.en AS en_150, c4_.es AS es_151, c4_.pt AS pt_152, c4_.de AS de_153, c4_.ru AS ru_154, c4_.orderby AS orderby_155 FROM texts t0_ LEFT JOIN extranetusers e1_ ON t0_.idextranetuser = e1_.idextranetuser LEFT JOIN contacts c2_ ON t0_.idcontact_publisher = c2_.idcontact LEFT JOIN genretexts g3_ ON t0_.idgenretext = g3_.idgenretext LEFT JOIN contacts c5_ ON t0_.idcontact_performing = c5_.idcontact LEFT JOIN countries c4_ ON t0_.country = c4_.id WHERE t0_.idtext = '2659';
|
3 |
0.52 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=2659 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=2659 ORDER BY j2.classement ASC;
|
4 |
0.20 ms |
SELECT DISTINCT(ta.idtextadaptation) FROM text_adaptation ta WHERE ta.idtext=2659
SELECT DISTINCT(ta.idtextadaptation) FROM text_adaptation ta WHERE ta.idtext=2659;
|
5 |
0.22 ms |
SELECT t.idtext FROM texts t WHERE t.idtext=2659
SELECT t.idtext FROM texts t WHERE t.idtext=2659;
|
6 |
132.42 ms |
SELECT COUNT(DISTINCT(s.idspectacle)) as total
FROM text_spectacle ts, spectacles s
WHERE ts.idspectacle=s.idspectacle AND s.publish=1 AND (ts.idtext=2659
OR ts.idtext IN (
2659
)OR ts.idtext IN(
SELECT DISTINCT(t.idtext)
FROM
texts t,
text_traduction tt
WHERE
t.idtext = tt.idtexttraduction
AND tt.idtext = 2659
))
SELECT COUNT(DISTINCT(s.idspectacle)) as total
FROM text_spectacle ts, spectacles s
WHERE ts.idspectacle=s.idspectacle AND s.publish=1 AND (ts.idtext=2659
OR ts.idtext IN (
2659
)OR ts.idtext IN(
SELECT DISTINCT(t.idtext)
FROM
texts t,
text_traduction tt
WHERE
t.idtext = tt.idtexttraduction
AND tt.idtext = 2659
));
|
7 |
0.99 ms |
SELECT COUNT(DISTINCT(t.`idtext`)) as total
FROM text_traduction tt, texts t
WHERE tt.`idtexttraduction`=t.`idtext` AND tt.`idtext`=2659 AND t.publish=1
SELECT COUNT(DISTINCT(t.`idtext`)) as total
FROM text_traduction tt, texts t
WHERE tt.`idtexttraduction`=t.`idtext` AND tt.`idtext`=2659 AND t.publish=1;
|
8 |
0.08 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_couv'))) AND texts=1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_couv'))) AND texts=1;
|
9 |
1.14 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='2659'
AND of.object='texts'
AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_couv'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT *
FROM object_file of,
files f,
file_classification fc,
classifications cl,typesfiles tf
WHERE of.idfile=f.idfile
AND f.idfile=fc.idfile
AND of.idobject='2659'
AND of.object='texts'
AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_couv'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;
|
10 |
1.24 ms |
SELECT t.`idtext`,t.`title`,t.`date`,t.`type`,t.`language`,t.`country`,t.`idcontact_publisher`,t.`isbn`,t.`ean`,t.`publication_year`,t.`nbpages`,t.`idgenretext`,t.`textorder`,t.`url_clean`,contacts.`organisation`, contacts.`url_clean` as url_clean_publisher
FROM text_traduction tt, texts t
LEFT JOIN contacts ON contacts.idcontact=t.idcontact_publisher
WHERE 1
AND t.idtext=tt.idtexttraduction
AND tt.idtext=2659
AND t.type=1 AND t.publish=1 AND t.textfictif=0 GROUP BY t.idtext ORDER BY date DESC
SELECT t.`idtext`,t.`title`,t.`date`,t.`type`,t.`language`,t.`country`,t.`idcontact_publisher`,t.`isbn`,t.`ean`,t.`publication_year`,t.`nbpages`,t.`idgenretext`,t.`textorder`,t.`url_clean`,contacts.`organisation`, contacts.`url_clean` as url_clean_publisher
FROM text_traduction tt, texts t
LEFT JOIN contacts ON contacts.idcontact=t.idcontact_publisher
WHERE 1
AND t.idtext=tt.idtexttraduction
AND tt.idtext=2659
AND t.type=1 AND t.publish=1 AND t.textfictif=0 GROUP BY t.idtext ORDER BY date DESC;
|
11 |
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_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4882 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=4882 ORDER BY j2.classement ASC;
|
12 |
0.36 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=4882
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=4882
ORDER BY t.title;
|
13 |
0.16 ms |
SELECT fr FROM languages WHERE id='sk'
SELECT fr FROM languages WHERE id='sk';
|
14 |
0.12 ms |
SELECT fr FROM countries WHERE id='SK'
SELECT fr FROM countries WHERE id='SK';
|
15 |
0.04 ms |
SELECT fr FROM languages WHERE id='sk'
SELECT fr FROM languages WHERE id='sk';
|
16 |
0.36 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=4878 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=4878 ORDER BY j2.classement ASC;
|
17 |
0.29 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=4878
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=4878
ORDER BY t.title;
|
18 |
0.19 ms |
SELECT fr FROM languages WHERE id='el'
SELECT fr FROM languages WHERE id='el';
|
19 |
0.26 ms |
SELECT fr FROM countries WHERE id='GR'
SELECT fr FROM countries WHERE id='GR';
|
20 |
0.03 ms |
SELECT fr FROM languages WHERE id='el'
SELECT fr FROM languages WHERE id='el';
|
21 |
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_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4880 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=4880 ORDER BY j2.classement ASC;
|
22 |
0.31 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=4880
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=4880
ORDER BY t.title;
|
23 |
0.23 ms |
SELECT fr FROM languages WHERE id='ro'
SELECT fr FROM languages WHERE id='ro';
|
24 |
0.19 ms |
SELECT fr FROM countries WHERE id='RO'
SELECT fr FROM countries WHERE id='RO';
|
25 |
0.03 ms |
SELECT fr FROM languages WHERE id='ro'
SELECT fr FROM languages WHERE id='ro';
|
26 |
0.21 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=4883 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=4883 ORDER BY j2.classement ASC;
|
27 |
0.19 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=4883
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=4883
ORDER BY t.title;
|
28 |
0.10 ms |
SELECT fr FROM languages WHERE id='en'
SELECT fr FROM languages WHERE id='en';
|
29 |
0.03 ms |
SELECT fr FROM countries WHERE id='US'
SELECT fr FROM countries WHERE id='US';
|
30 |
0.03 ms |
SELECT fr FROM languages WHERE id='en'
SELECT fr FROM languages WHERE id='en';
|
31 |
0.36 ms |
SELECT DISTINCT t0_.idtext AS idtext_0 FROM texts t1_ INNER JOIN text_adaptation t2_ ON t1_.idtext = t2_.idtextadaptation INNER JOIN texts t0_ ON t0_.idtext = t2_.idtext WHERE t1_.idtext = 2659
SELECT DISTINCT t0_.idtext AS idtext_0 FROM texts t1_ INNER JOIN text_adaptation t2_ ON t1_.idtext = t2_.idtextadaptation INNER JOIN texts t0_ ON t0_.idtext = t2_.idtext WHERE t1_.idtext = 2659;
|
32 |
1.80 ms |
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, s2_.idspectacle AS idspectacle_2, s2_.title AS title_3, s2_.language AS language_4, s2_.creation_date AS creation_date_5, s2_.url_page AS url_page_6, s2_.infos AS infos_7, s2_.tag AS tag_8, s2_.id_rubrique AS id_rubrique_9, s2_.duration AS duration_10, s2_.interlude AS interlude_11, s2_.textfictif AS textfictif_12, s2_.url_redirect AS url_redirect_13, s2_.url_clean AS url_clean_14, s2_.dateupdate AS dateupdate_15, s2_.dateinsert AS dateinsert_16, s2_.publish AS publish_17, s2_.statut AS statut_18, s2_.valid AS valid_19, t1_.idtext AS idtext_20, t1_.type AS type_21, t1_.idtypetext AS idtypetext_22, t1_.special_text AS special_text_23, t1_.title AS title_24, t1_.subtitle AS subtitle_25, t1_.date AS date_26, t1_.language AS language_27, t1_.markdown AS markdown_28, t1_.abstract AS abstract_29, t1_.abstract_author AS abstract_author_30, t1_.abstract_date AS abstract_date_31, t1_.abstract_url AS abstract_url_32, t1_.publisher_url_text AS publisher_url_text_33, t1_.publication_year AS publication_year_34, t1_.publication_month AS publication_month_35, t1_.isbn AS isbn_36, t1_.ean AS ean_37, t1_.publishinfos AS publishinfos_38, t1_.urltextaccess AS urltextaccess_39, t1_.emailtextaccess AS emailtextaccess_40, t1_.idfiletextaccess AS idfiletextaccess_41, t1_.filetextaccesssave AS filetextaccesssave_42, t1_.textaccessmore AS textaccessmore_43, t1_.request_translation_text AS request_translation_text_44, t1_.request_performing_text AS request_performing_text_45, t1_.help_translation AS help_translation_46, t1_.help_publishing AS help_publishing_47, t1_.help_other AS help_other_48, t1_.moreinfo AS moreinfo_49, t1_.nmale AS nmale_50, t1_.nfemale AS nfemale_51, t1_.npeople AS npeople_52, t1_.textorder AS textorder_53, t1_.nbpages AS nbpages_54, t1_.price AS price_55, t1_.selection_aneth AS selection_aneth_56, t1_.idtext_aneth AS idtext_aneth_57, t1_.aide_creation AS aide_creation_58, t1_.comments AS comments_59, t1_.url_clean AS url_clean_60, t1_.textfictif AS textfictif_61, t1_.valid_opendata AS valid_opendata_62, t1_.dateupdate AS dateupdate_63, t1_.dateinsert AS dateinsert_64, t1_.publish AS publish_65, t1_.statut AS statut_66, t1_.valid AS valid_67, t3_.idtypespectacle AS idtypespectacle_68 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle LEFT JOIN text_spectacle t6_ ON s2_.idspectacle = t6_.idspectacle LEFT JOIN texts t5_ ON t5_.idtext = t6_.idtext LEFT JOIN spectacle_person s8_ ON s2_.idspectacle = s8_.idspectacle LEFT JOIN persons p7_ ON p7_.idperson = s8_.idperson INNER JOIN contacts c9_ ON s0_.idcontact = c9_.idcontact WHERE s2_.language = 'fr' AND (s2_.publish = 1 AND t1_.idtext = 2659) GROUP BY s2_.idspectacle ORDER BY sclr_0 DESC LIMIT 500
SELECT
DISTINCT MIN(s0_.date) AS sclr_0,
t1_.url_clean AS url_clean_1,
s2_.idspectacle AS idspectacle_2,
s2_.title AS title_3,
s2_.language AS language_4,
s2_.creation_date AS creation_date_5,
s2_.url_page AS url_page_6,
s2_.infos AS infos_7,
s2_.tag AS tag_8,
s2_.id_rubrique AS id_rubrique_9,
s2_.duration AS duration_10,
s2_.interlude AS interlude_11,
s2_.textfictif AS textfictif_12,
s2_.url_redirect AS url_redirect_13,
s2_.url_clean AS url_clean_14,
s2_.dateupdate AS dateupdate_15,
s2_.dateinsert AS dateinsert_16,
s2_.publish AS publish_17,
s2_.statut AS statut_18,
s2_.valid AS valid_19,
t1_.idtext AS idtext_20,
t1_.type AS type_21,
t1_.idtypetext AS idtypetext_22,
t1_.special_text AS special_text_23,
t1_.title AS title_24,
t1_.subtitle AS subtitle_25,
t1_.date AS date_26,
t1_.language AS language_27,
t1_.markdown AS markdown_28,
t1_.abstract AS abstract_29,
t1_.abstract_author AS abstract_author_30,
t1_.abstract_date AS abstract_date_31,
t1_.abstract_url AS abstract_url_32,
t1_.publisher_url_text AS publisher_url_text_33,
t1_.publication_year AS publication_year_34,
t1_.publication_month AS publication_month_35,
t1_.isbn AS isbn_36,
t1_.ean AS ean_37,
t1_.publishinfos AS publishinfos_38,
t1_.urltextaccess AS urltextaccess_39,
t1_.emailtextaccess AS emailtextaccess_40,
t1_.idfiletextaccess AS idfiletextaccess_41,
t1_.filetextaccesssave AS filetextaccesssave_42,
t1_.textaccessmore AS textaccessmore_43,
t1_.request_translation_text AS request_translation_text_44,
t1_.request_performing_text AS request_performing_text_45,
t1_.help_translation AS help_translation_46,
t1_.help_publishing AS help_publishing_47,
t1_.help_other AS help_other_48,
t1_.moreinfo AS moreinfo_49,
t1_.nmale AS nmale_50,
t1_.nfemale AS nfemale_51,
t1_.npeople AS npeople_52,
t1_.textorder AS textorder_53,
t1_.nbpages AS nbpages_54,
t1_.price AS price_55,
t1_.selection_aneth AS selection_aneth_56,
t1_.idtext_aneth AS idtext_aneth_57,
t1_.aide_creation AS aide_creation_58,
t1_.comments AS comments_59,
t1_.url_clean AS url_clean_60,
t1_.textfictif AS textfictif_61,
t1_.valid_opendata AS valid_opendata_62,
t1_.dateupdate AS dateupdate_63,
t1_.dateinsert AS dateinsert_64,
t1_.publish AS publish_65,
t1_.statut AS statut_66,
t1_.valid AS valid_67,
t3_.idtypespectacle AS idtypespectacle_68
FROM
spectacles s2_
LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle
LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext
LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle
LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle
LEFT JOIN text_spectacle t6_ ON s2_.idspectacle = t6_.idspectacle
LEFT JOIN texts t5_ ON t5_.idtext = t6_.idtext
LEFT JOIN spectacle_person s8_ ON s2_.idspectacle = s8_.idspectacle
LEFT JOIN persons p7_ ON p7_.idperson = s8_.idperson
INNER JOIN contacts c9_ ON s0_.idcontact = c9_.idcontact
WHERE
s2_.language = 'fr'
AND (
s2_.publish = 1
AND t1_.idtext = 2659
)
GROUP BY
s2_.idspectacle
ORDER BY
sclr_0 DESC
LIMIT
500
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, s2_.idspectacle AS idspectacle_2, s2_.title AS title_3, s2_.language AS language_4, s2_.creation_date AS creation_date_5, s2_.url_page AS url_page_6, s2_.infos AS infos_7, s2_.tag AS tag_8, s2_.id_rubrique AS id_rubrique_9, s2_.duration AS duration_10, s2_.interlude AS interlude_11, s2_.textfictif AS textfictif_12, s2_.url_redirect AS url_redirect_13, s2_.url_clean AS url_clean_14, s2_.dateupdate AS dateupdate_15, s2_.dateinsert AS dateinsert_16, s2_.publish AS publish_17, s2_.statut AS statut_18, s2_.valid AS valid_19, t1_.idtext AS idtext_20, t1_.type AS type_21, t1_.idtypetext AS idtypetext_22, t1_.special_text AS special_text_23, t1_.title AS title_24, t1_.subtitle AS subtitle_25, t1_.date AS date_26, t1_.language AS language_27, t1_.markdown AS markdown_28, t1_.abstract AS abstract_29, t1_.abstract_author AS abstract_author_30, t1_.abstract_date AS abstract_date_31, t1_.abstract_url AS abstract_url_32, t1_.publisher_url_text AS publisher_url_text_33, t1_.publication_year AS publication_year_34, t1_.publication_month AS publication_month_35, t1_.isbn AS isbn_36, t1_.ean AS ean_37, t1_.publishinfos AS publishinfos_38, t1_.urltextaccess AS urltextaccess_39, t1_.emailtextaccess AS emailtextaccess_40, t1_.idfiletextaccess AS idfiletextaccess_41, t1_.filetextaccesssave AS filetextaccesssave_42, t1_.textaccessmore AS textaccessmore_43, t1_.request_translation_text AS request_translation_text_44, t1_.request_performing_text AS request_performing_text_45, t1_.help_translation AS help_translation_46, t1_.help_publishing AS help_publishing_47, t1_.help_other AS help_other_48, t1_.moreinfo AS moreinfo_49, t1_.nmale AS nmale_50, t1_.nfemale AS nfemale_51, t1_.npeople AS npeople_52, t1_.textorder AS textorder_53, t1_.nbpages AS nbpages_54, t1_.price AS price_55, t1_.selection_aneth AS selection_aneth_56, t1_.idtext_aneth AS idtext_aneth_57, t1_.aide_creation AS aide_creation_58, t1_.comments AS comments_59, t1_.url_clean AS url_clean_60, t1_.textfictif AS textfictif_61, t1_.valid_opendata AS valid_opendata_62, t1_.dateupdate AS dateupdate_63, t1_.dateinsert AS dateinsert_64, t1_.publish AS publish_65, t1_.statut AS statut_66, t1_.valid AS valid_67, t3_.idtypespectacle AS idtypespectacle_68 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle LEFT JOIN text_spectacle t6_ ON s2_.idspectacle = t6_.idspectacle LEFT JOIN texts t5_ ON t5_.idtext = t6_.idtext LEFT JOIN spectacle_person s8_ ON s2_.idspectacle = s8_.idspectacle LEFT JOIN persons p7_ ON p7_.idperson = s8_.idperson INNER JOIN contacts c9_ ON s0_.idcontact = c9_.idcontact WHERE s2_.language = 'fr' AND (s2_.publish = 1 AND t1_.idtext = 2659) GROUP BY s2_.idspectacle ORDER BY sclr_0 DESC LIMIT 500;
|
33 |
0.06 ms |
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (4) LIMIT 1;
|
34 |
0.23 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 = 2659;
|
35 |
0.05 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=2659 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=2659 ORDER BY j2.classement ASC;
|
36 |
0.82 ms |
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
lt.`fr`,
r.`idrole`, r.`role`, r.`type`,
sp.`comment`,sp.`date_start`,sp.`date_end`
FROM persons p
JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
JOIN roles r ON r.`idrole`=sp.`idrole`
JOIN langterms lt ON r.`role`=lt.`id`
WHERE sp.idspectacle=9928 ORDER BY p.`lastname`
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
lt.`fr`,
r.`idrole`, r.`role`, r.`type`,
sp.`comment`,sp.`date_start`,sp.`date_end`
FROM persons p
JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
JOIN roles r ON r.`idrole`=sp.`idrole`
JOIN langterms lt ON r.`role`=lt.`id`
WHERE sp.idspectacle=9928 ORDER BY p.`lastname` ;
|
37 |
1.02 ms |
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: [
9928
"2024-04-26"
]
SELECT
MIN(s0_.date) AS sclr_0,
MAX(s0_.date) AS sclr_1,
s0_.idschedule AS idschedule_2,
s0_.date AS date_3,
s0_.hour AS hour_4,
s0_.is_creation AS is_creation_5,
s0_.is_cancelled AS is_cancelled_6,
s0_.idcontact_festival AS idcontact_festival_7,
s0_.url_spectacle AS url_spectacle_8,
s0_.url_booking AS url_booking_9,
s0_.note AS note_10,
s0_.dateupdate AS dateupdate_11,
s0_.dateinsert AS dateinsert_12,
s0_.publish AS publish_13,
s0_.valid AS valid_14,
c1_.idcontact AS idcontact_15,
c1_.type AS type_16,
c1_.organisation AS organisation_17,
c1_.nom_suite AS nom_suite_18,
c1_.lastname AS lastname_19,
c1_.firstname AS firstname_20,
c1_.idtypestructure AS idtypestructure_21,
c1_.license AS license_22,
c1_.comment AS comment_23,
c1_.private_comment AS private_comment_24,
c1_.address1 AS address1_25,
c1_.address2 AS address2_26,
c1_.zip AS zip_27,
c1_.city AS city_28,
c1_.phone1 AS phone1_29,
c1_.phone2 AS phone2_30,
c1_.fax AS fax_31,
c1_.email1 AS email1_32,
c1_.email1_online AS email1_online_33,
c1_.email2_online AS email2_online_34,
c1_.email2 AS email2_35,
c1_.url AS url_36,
c1_.url_ticket AS url_ticket_37,
c1_.facebook AS facebook_38,
c1_.twitter AS twitter_39,
c1_.instagram AS instagram_40,
c1_.mobile AS mobile_41,
c1_.geocodable AS geocodable_42,
c1_.x AS x_43,
c1_.y AS y_44,
c1_.idmultimedia AS idmultimedia_45,
c1_.type_view AS type_view_46,
c1_.stats_access AS stats_access_47,
c1_.ga_tracking_id AS ga_tracking_id_48,
c1_.is_festival AS is_festival_49,
c1_.link_on_video AS link_on_video_50,
c1_.is_partenaire AS is_partenaire_51,
c1_.valid_version AS valid_version_52,
c1_.other_versions AS other_versions_53,
c1_.url_redirect AS url_redirect_54,
c1_.url_clean AS url_clean_55,
c1_.dateupdate AS dateupdate_56,
c1_.dateinsert AS dateinsert_57,
c1_.publish AS publish_58,
c1_.valid AS valid_59,
s0_.idspectacle AS idspectacle_60,
s0_.idcontact AS idcontact_61,
s0_.idextranetuser AS idextranetuser_62,
c1_.country AS country_63,
c1_.idextranetuser AS idextranetuser_64
FROM
schedules s0_
LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact
WHERE
s0_.idspectacle = ?
AND s0_.date >= ?
GROUP BY
s0_.idcontact
ORDER BY
s0_.date ASC
LIMIT
1
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = 9928 AND s0_.date >= '2024-04-26' GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1;
|
38 |
0.30 ms |
SELECT COUNT(DISTINCT(m.idmultimedia))
FROM object_multimedia om, multimedias m
WHERE om.idmultimedia=m.idmultimedia
AND om.idobject=9928
AND om.object='spectacles'
AND m.publish=1
SELECT COUNT(DISTINCT(m.idmultimedia))
FROM object_multimedia om, multimedias m
WHERE om.idmultimedia=m.idmultimedia
AND om.idobject=9928
AND om.object='spectacles'
AND m.publish=1;
|
39 |
0.21 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`=9928 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`=9928 AND d.code_franceinter IS NOT NULL ;
|
40 |
0.05 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) ;
|
41 |
0.38 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='9928'
AND of.object='spectacles'
AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(DISTINCT(of.idfile)) as total
FROM object_file of,
files f,
file_classification fc,
classifications cl,typesfiles tf
WHERE of.idfile=f.idfile
AND f.idfile=fc.idfile
AND of.idobject='9928'
AND of.object='spectacles'
AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype;
|
42 |
0.29 ms |
SELECT COUNT(oc.idcontent)
FROM object_content oc, contents c, content_classification cc
WHERE oc.idcontent=c.idcontent
AND cc.idcontent=c.idcontent
AND c.publish=1
AND oc.object='spectacles'
AND oc.idobject=9928 AND cc.idclassification=6 LIMIT 1
SELECT COUNT(oc.idcontent)
FROM object_content oc, contents c, content_classification cc
WHERE oc.idcontent=c.idcontent
AND cc.idcontent=c.idcontent
AND c.publish=1
AND oc.object='spectacles'
AND oc.idobject=9928 AND cc.idclassification=6 LIMIT 1;
|
43 |
0.29 ms |
SELECT COUNT(oc.idcontent)
FROM object_content oc, contents c, content_classification cc
WHERE oc.idcontent=c.idcontent
AND cc.idcontent=c.idcontent
AND c.publish=1
AND oc.object='spectacles'
AND oc.idobject=9928 AND cc.idclassification=125 LIMIT 1
SELECT COUNT(oc.idcontent)
FROM object_content oc, contents c, content_classification cc
WHERE oc.idcontent=c.idcontent
AND cc.idcontent=c.idcontent
AND c.publish=1
AND oc.object='spectacles'
AND oc.idobject=9928 AND cc.idclassification=125 LIMIT 1;
|
44 |
0.38 ms |
SELECT COUNT(oc.idcontent)
FROM object_content oc, contents c, content_classification cc
WHERE oc.idcontent=c.idcontent
AND cc.idcontent=c.idcontent
AND c.publish=1
AND oc.object='spectacles'
AND oc.idobject=9928 AND cc.idclassification=101 LIMIT 1
SELECT COUNT(oc.idcontent)
FROM object_content oc, contents c, content_classification cc
WHERE oc.idcontent=c.idcontent
AND cc.idcontent=c.idcontent
AND c.publish=1
AND oc.object='spectacles'
AND oc.idobject=9928 AND cc.idclassification=101 LIMIT 1;
|
45 |
0.65 ms |
SELECT DISTINCT(s.idschedule),s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,
c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,MIN(s.date) AS datedebut,
ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean
FROM schedules s
JOIN contacts c ON s.idcontact=c.idcontact
LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact
WHERE s.idspectacle=9928 AND s.date>='2024-04-26' GROUP BY c.idcontact ORDER BY s.date ASC
SELECT DISTINCT(s.idschedule),s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,
c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,MIN(s.date) AS datedebut,
ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean
FROM schedules s
JOIN contacts c ON s.idcontact=c.idcontact
LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact
WHERE s.idspectacle=9928 AND s.date>='2024-04-26' GROUP BY c.idcontact ORDER BY s.date ASC;
|
46 |
0.07 ms |
SELECT t.`idtext`,t.`title`,t.`date`,t.`type`,t.`language`,t.`country`,t.`idcontact_publisher`,t.`isbn`,t.`ean`,t.`publication_year`,t.`nbpages`,t.`idgenretext`,t.`textorder`,t.`url_clean`,contacts.`organisation`, contacts.`url_clean` as url_clean_publisher
FROM text_traduction tt, texts t
LEFT JOIN contacts ON contacts.idcontact=t.idcontact_publisher
WHERE 1
AND t.idtext=tt.idtexttraduction
AND tt.idtext=2659
AND t.type=1 AND t.publish=1 AND t.textfictif=0 GROUP BY t.idtext ORDER BY date DESC
SELECT t.`idtext`,t.`title`,t.`date`,t.`type`,t.`language`,t.`country`,t.`idcontact_publisher`,t.`isbn`,t.`ean`,t.`publication_year`,t.`nbpages`,t.`idgenretext`,t.`textorder`,t.`url_clean`,contacts.`organisation`, contacts.`url_clean` as url_clean_publisher
FROM text_traduction tt, texts t
LEFT JOIN contacts ON contacts.idcontact=t.idcontact_publisher
WHERE 1
AND t.idtext=tt.idtexttraduction
AND tt.idtext=2659
AND t.type=1 AND t.publish=1 AND t.textfictif=0 GROUP BY t.idtext ORDER BY date DESC;
|
47 |
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_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4882 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=4882 ORDER BY j2.classement ASC;
|
48 |
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=4882
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=4882
ORDER BY t.title;
|
49 |
0.04 ms |
SELECT fr FROM languages WHERE id='sk'
SELECT fr FROM languages WHERE id='sk';
|
50 |
0.03 ms |
SELECT fr FROM languages WHERE id='sk'
SELECT fr FROM languages WHERE id='sk';
|
51 |
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_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4878 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=4878 ORDER BY j2.classement ASC;
|
52 |
0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=4878
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=4878
ORDER BY t.title;
|
53 |
0.04 ms |
SELECT fr FROM languages WHERE id='el'
SELECT fr FROM languages WHERE id='el';
|
54 |
0.03 ms |
SELECT fr FROM languages WHERE id='el'
SELECT fr FROM languages WHERE id='el';
|
55 |
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_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4880 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=4880 ORDER BY j2.classement ASC;
|
56 |
0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=4880
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=4880
ORDER BY t.title;
|
57 |
0.04 ms |
SELECT fr FROM languages WHERE id='ro'
SELECT fr FROM languages WHERE id='ro';
|
58 |
0.03 ms |
SELECT fr FROM languages WHERE id='ro'
SELECT fr FROM languages WHERE id='ro';
|
59 |
0.03 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4883 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=4883 ORDER BY j2.classement ASC;
|
60 |
0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=4883
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=4883
ORDER BY t.title;
|
61 |
0.04 ms |
SELECT fr FROM languages WHERE id='en'
SELECT fr FROM languages WHERE id='en';
|
62 |
0.03 ms |
SELECT fr FROM languages WHERE id='en'
SELECT fr FROM languages WHERE id='en';
|
63 |
0.04 ms |
SELECT DISTINCT t0_.idtext AS idtext_0 FROM texts t1_ INNER JOIN text_adaptation t2_ ON t1_.idtext = t2_.idtextadaptation INNER JOIN texts t0_ ON t0_.idtext = t2_.idtext WHERE t1_.idtext = 2659
SELECT DISTINCT t0_.idtext AS idtext_0 FROM texts t1_ INNER JOIN text_adaptation t2_ ON t1_.idtext = t2_.idtextadaptation INNER JOIN texts t0_ ON t0_.idtext = t2_.idtext WHERE t1_.idtext = 2659;
|
64 |
0.05 ms |
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (4) LIMIT 1;
|
65 |
0.05 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 = 2659;
|
66 |
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=2659 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=2659 ORDER BY j2.classement ASC;
|
67 |
0.06 ms |
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
lt.`fr`,
r.`idrole`, r.`role`, r.`type`,
sp.`comment`,sp.`date_start`,sp.`date_end`
FROM persons p
JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
JOIN roles r ON r.`idrole`=sp.`idrole`
JOIN langterms lt ON r.`role`=lt.`id`
WHERE sp.idspectacle=9928 ORDER BY p.`lastname`
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
lt.`fr`,
r.`idrole`, r.`role`, r.`type`,
sp.`comment`,sp.`date_start`,sp.`date_end`
FROM persons p
JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
JOIN roles r ON r.`idrole`=sp.`idrole`
JOIN langterms lt ON r.`role`=lt.`id`
WHERE sp.idspectacle=9928 ORDER BY p.`lastname` ;
|
68 |
0.09 ms |
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: [
9928
"2024-04-26"
]
SELECT
MIN(s0_.date) AS sclr_0,
MAX(s0_.date) AS sclr_1,
s0_.idschedule AS idschedule_2,
s0_.date AS date_3,
s0_.hour AS hour_4,
s0_.is_creation AS is_creation_5,
s0_.is_cancelled AS is_cancelled_6,
s0_.idcontact_festival AS idcontact_festival_7,
s0_.url_spectacle AS url_spectacle_8,
s0_.url_booking AS url_booking_9,
s0_.note AS note_10,
s0_.dateupdate AS dateupdate_11,
s0_.dateinsert AS dateinsert_12,
s0_.publish AS publish_13,
s0_.valid AS valid_14,
c1_.idcontact AS idcontact_15,
c1_.type AS type_16,
c1_.organisation AS organisation_17,
c1_.nom_suite AS nom_suite_18,
c1_.lastname AS lastname_19,
c1_.firstname AS firstname_20,
c1_.idtypestructure AS idtypestructure_21,
c1_.license AS license_22,
c1_.comment AS comment_23,
c1_.private_comment AS private_comment_24,
c1_.address1 AS address1_25,
c1_.address2 AS address2_26,
c1_.zip AS zip_27,
c1_.city AS city_28,
c1_.phone1 AS phone1_29,
c1_.phone2 AS phone2_30,
c1_.fax AS fax_31,
c1_.email1 AS email1_32,
c1_.email1_online AS email1_online_33,
c1_.email2_online AS email2_online_34,
c1_.email2 AS email2_35,
c1_.url AS url_36,
c1_.url_ticket AS url_ticket_37,
c1_.facebook AS facebook_38,
c1_.twitter AS twitter_39,
c1_.instagram AS instagram_40,
c1_.mobile AS mobile_41,
c1_.geocodable AS geocodable_42,
c1_.x AS x_43,
c1_.y AS y_44,
c1_.idmultimedia AS idmultimedia_45,
c1_.type_view AS type_view_46,
c1_.stats_access AS stats_access_47,
c1_.ga_tracking_id AS ga_tracking_id_48,
c1_.is_festival AS is_festival_49,
c1_.link_on_video AS link_on_video_50,
c1_.is_partenaire AS is_partenaire_51,
c1_.valid_version AS valid_version_52,
c1_.other_versions AS other_versions_53,
c1_.url_redirect AS url_redirect_54,
c1_.url_clean AS url_clean_55,
c1_.dateupdate AS dateupdate_56,
c1_.dateinsert AS dateinsert_57,
c1_.publish AS publish_58,
c1_.valid AS valid_59,
s0_.idspectacle AS idspectacle_60,
s0_.idcontact AS idcontact_61,
s0_.idextranetuser AS idextranetuser_62,
c1_.country AS country_63,
c1_.idextranetuser AS idextranetuser_64
FROM
schedules s0_
LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact
WHERE
s0_.idspectacle = ?
AND s0_.date >= ?
GROUP BY
s0_.idcontact
ORDER BY
s0_.date ASC
LIMIT
1
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = 9928 AND s0_.date >= '2024-04-26' GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1;
|
69 |
0.06 ms |
SELECT t.`idtext`,t.`title`,t.`date`,t.`type`,t.`language`,t.`country`,t.`idcontact_publisher`,t.`isbn`,t.`ean`,t.`publication_year`,t.`nbpages`,t.`idgenretext`,t.`textorder`,t.`url_clean`,contacts.`organisation`, contacts.`url_clean` as url_clean_publisher
FROM text_traduction tt, texts t
LEFT JOIN contacts ON contacts.idcontact=t.idcontact_publisher
WHERE 1
AND t.idtext=tt.idtexttraduction
AND tt.idtext=2659
AND t.type=1 AND t.publish=1 AND t.textfictif=0 GROUP BY t.idtext ORDER BY date DESC
SELECT t.`idtext`,t.`title`,t.`date`,t.`type`,t.`language`,t.`country`,t.`idcontact_publisher`,t.`isbn`,t.`ean`,t.`publication_year`,t.`nbpages`,t.`idgenretext`,t.`textorder`,t.`url_clean`,contacts.`organisation`, contacts.`url_clean` as url_clean_publisher
FROM text_traduction tt, texts t
LEFT JOIN contacts ON contacts.idcontact=t.idcontact_publisher
WHERE 1
AND t.idtext=tt.idtexttraduction
AND tt.idtext=2659
AND t.type=1 AND t.publish=1 AND t.textfictif=0 GROUP BY t.idtext ORDER BY date DESC;
|
70 |
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_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4882 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=4882 ORDER BY j2.classement ASC;
|
71 |
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=4882
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=4882
ORDER BY t.title;
|
72 |
0.04 ms |
SELECT fr FROM languages WHERE id='sk'
SELECT fr FROM languages WHERE id='sk';
|
73 |
0.03 ms |
SELECT fr FROM languages WHERE id='sk'
SELECT fr FROM languages WHERE id='sk';
|
74 |
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_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4878 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=4878 ORDER BY j2.classement ASC;
|
75 |
0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=4878
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=4878
ORDER BY t.title;
|
76 |
0.03 ms |
SELECT fr FROM languages WHERE id='el'
SELECT fr FROM languages WHERE id='el';
|
77 |
0.03 ms |
SELECT fr FROM languages WHERE id='el'
SELECT fr FROM languages WHERE id='el';
|
78 |
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_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4880 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=4880 ORDER BY j2.classement ASC;
|
79 |
0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=4880
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=4880
ORDER BY t.title;
|
80 |
0.03 ms |
SELECT fr FROM languages WHERE id='ro'
SELECT fr FROM languages WHERE id='ro';
|
81 |
0.03 ms |
SELECT fr FROM languages WHERE id='ro'
SELECT fr FROM languages WHERE id='ro';
|
82 |
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_translator j2, theatreok_dev.texts j3
WHERE j3.idtext=j2.idtext
AND j1.idperson=j2.idperson
AND j3.idtext=4883 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=4883 ORDER BY j2.classement ASC;
|
83 |
0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
FROM texts t, text_traduction tt
WHERE t.idtext=tt.idtext
AND tt.idtexttraduction=4883
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=4883
ORDER BY t.title;
|
84 |
0.03 ms |
SELECT fr FROM languages WHERE id='en'
SELECT fr FROM languages WHERE id='en';
|
85 |
0.03 ms |
SELECT fr FROM languages WHERE id='en'
SELECT fr FROM languages WHERE id='en';
|
86 |
1.53 ms |
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, s2_.idspectacle AS idspectacle_2, s2_.title AS title_3, s2_.language AS language_4, s2_.creation_date AS creation_date_5, s2_.url_page AS url_page_6, s2_.infos AS infos_7, s2_.tag AS tag_8, s2_.id_rubrique AS id_rubrique_9, s2_.duration AS duration_10, s2_.interlude AS interlude_11, s2_.textfictif AS textfictif_12, s2_.url_redirect AS url_redirect_13, s2_.url_clean AS url_clean_14, s2_.dateupdate AS dateupdate_15, s2_.dateinsert AS dateinsert_16, s2_.publish AS publish_17, s2_.statut AS statut_18, s2_.valid AS valid_19, t1_.idtext AS idtext_20, t1_.type AS type_21, t1_.idtypetext AS idtypetext_22, t1_.special_text AS special_text_23, t1_.title AS title_24, t1_.subtitle AS subtitle_25, t1_.date AS date_26, t1_.language AS language_27, t1_.markdown AS markdown_28, t1_.abstract AS abstract_29, t1_.abstract_author AS abstract_author_30, t1_.abstract_date AS abstract_date_31, t1_.abstract_url AS abstract_url_32, t1_.publisher_url_text AS publisher_url_text_33, t1_.publication_year AS publication_year_34, t1_.publication_month AS publication_month_35, t1_.isbn AS isbn_36, t1_.ean AS ean_37, t1_.publishinfos AS publishinfos_38, t1_.urltextaccess AS urltextaccess_39, t1_.emailtextaccess AS emailtextaccess_40, t1_.idfiletextaccess AS idfiletextaccess_41, t1_.filetextaccesssave AS filetextaccesssave_42, t1_.textaccessmore AS textaccessmore_43, t1_.request_translation_text AS request_translation_text_44, t1_.request_performing_text AS request_performing_text_45, t1_.help_translation AS help_translation_46, t1_.help_publishing AS help_publishing_47, t1_.help_other AS help_other_48, t1_.moreinfo AS moreinfo_49, t1_.nmale AS nmale_50, t1_.nfemale AS nfemale_51, t1_.npeople AS npeople_52, t1_.textorder AS textorder_53, t1_.nbpages AS nbpages_54, t1_.price AS price_55, t1_.selection_aneth AS selection_aneth_56, t1_.idtext_aneth AS idtext_aneth_57, t1_.aide_creation AS aide_creation_58, t1_.comments AS comments_59, t1_.url_clean AS url_clean_60, t1_.textfictif AS textfictif_61, t1_.valid_opendata AS valid_opendata_62, t1_.dateupdate AS dateupdate_63, t1_.dateinsert AS dateinsert_64, t1_.publish AS publish_65, t1_.statut AS statut_66, t1_.valid AS valid_67, t3_.idtypespectacle AS idtypespectacle_68 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s0_.idcontact = c7_.idcontact WHERE s2_.language <> 'fr' AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND t1_.idtext IN ('4882', '4878', '4880', '4883') GROUP BY s2_.idspectacle ORDER BY sclr_0 DESC LIMIT 500
SELECT
DISTINCT MIN(s0_.date) AS sclr_0,
t1_.url_clean AS url_clean_1,
s2_.idspectacle AS idspectacle_2,
s2_.title AS title_3,
s2_.language AS language_4,
s2_.creation_date AS creation_date_5,
s2_.url_page AS url_page_6,
s2_.infos AS infos_7,
s2_.tag AS tag_8,
s2_.id_rubrique AS id_rubrique_9,
s2_.duration AS duration_10,
s2_.interlude AS interlude_11,
s2_.textfictif AS textfictif_12,
s2_.url_redirect AS url_redirect_13,
s2_.url_clean AS url_clean_14,
s2_.dateupdate AS dateupdate_15,
s2_.dateinsert AS dateinsert_16,
s2_.publish AS publish_17,
s2_.statut AS statut_18,
s2_.valid AS valid_19,
t1_.idtext AS idtext_20,
t1_.type AS type_21,
t1_.idtypetext AS idtypetext_22,
t1_.special_text AS special_text_23,
t1_.title AS title_24,
t1_.subtitle AS subtitle_25,
t1_.date AS date_26,
t1_.language AS language_27,
t1_.markdown AS markdown_28,
t1_.abstract AS abstract_29,
t1_.abstract_author AS abstract_author_30,
t1_.abstract_date AS abstract_date_31,
t1_.abstract_url AS abstract_url_32,
t1_.publisher_url_text AS publisher_url_text_33,
t1_.publication_year AS publication_year_34,
t1_.publication_month AS publication_month_35,
t1_.isbn AS isbn_36,
t1_.ean AS ean_37,
t1_.publishinfos AS publishinfos_38,
t1_.urltextaccess AS urltextaccess_39,
t1_.emailtextaccess AS emailtextaccess_40,
t1_.idfiletextaccess AS idfiletextaccess_41,
t1_.filetextaccesssave AS filetextaccesssave_42,
t1_.textaccessmore AS textaccessmore_43,
t1_.request_translation_text AS request_translation_text_44,
t1_.request_performing_text AS request_performing_text_45,
t1_.help_translation AS help_translation_46,
t1_.help_publishing AS help_publishing_47,
t1_.help_other AS help_other_48,
t1_.moreinfo AS moreinfo_49,
t1_.nmale AS nmale_50,
t1_.nfemale AS nfemale_51,
t1_.npeople AS npeople_52,
t1_.textorder AS textorder_53,
t1_.nbpages AS nbpages_54,
t1_.price AS price_55,
t1_.selection_aneth AS selection_aneth_56,
t1_.idtext_aneth AS idtext_aneth_57,
t1_.aide_creation AS aide_creation_58,
t1_.comments AS comments_59,
t1_.url_clean AS url_clean_60,
t1_.textfictif AS textfictif_61,
t1_.valid_opendata AS valid_opendata_62,
t1_.dateupdate AS dateupdate_63,
t1_.dateinsert AS dateinsert_64,
t1_.publish AS publish_65,
t1_.statut AS statut_66,
t1_.valid AS valid_67,
t3_.idtypespectacle AS idtypespectacle_68
FROM
spectacles s2_
LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle
LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext
LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle
LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle
LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle
LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson
INNER JOIN contacts c7_ ON s0_.idcontact = c7_.idcontact
WHERE
s2_.language <> 'fr'
AND s0_.idspectacle = s2_.idspectacle
AND (
s0_.idcontact = c7_.idcontact
OR s0_.idcontact_festival = c7_.idcontact
)
AND t1_.idtext IN ('4882', '4878', '4880', '4883')
GROUP BY
s2_.idspectacle
ORDER BY
sclr_0 DESC
LIMIT
500
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, s2_.idspectacle AS idspectacle_2, s2_.title AS title_3, s2_.language AS language_4, s2_.creation_date AS creation_date_5, s2_.url_page AS url_page_6, s2_.infos AS infos_7, s2_.tag AS tag_8, s2_.id_rubrique AS id_rubrique_9, s2_.duration AS duration_10, s2_.interlude AS interlude_11, s2_.textfictif AS textfictif_12, s2_.url_redirect AS url_redirect_13, s2_.url_clean AS url_clean_14, s2_.dateupdate AS dateupdate_15, s2_.dateinsert AS dateinsert_16, s2_.publish AS publish_17, s2_.statut AS statut_18, s2_.valid AS valid_19, t1_.idtext AS idtext_20, t1_.type AS type_21, t1_.idtypetext AS idtypetext_22, t1_.special_text AS special_text_23, t1_.title AS title_24, t1_.subtitle AS subtitle_25, t1_.date AS date_26, t1_.language AS language_27, t1_.markdown AS markdown_28, t1_.abstract AS abstract_29, t1_.abstract_author AS abstract_author_30, t1_.abstract_date AS abstract_date_31, t1_.abstract_url AS abstract_url_32, t1_.publisher_url_text AS publisher_url_text_33, t1_.publication_year AS publication_year_34, t1_.publication_month AS publication_month_35, t1_.isbn AS isbn_36, t1_.ean AS ean_37, t1_.publishinfos AS publishinfos_38, t1_.urltextaccess AS urltextaccess_39, t1_.emailtextaccess AS emailtextaccess_40, t1_.idfiletextaccess AS idfiletextaccess_41, t1_.filetextaccesssave AS filetextaccesssave_42, t1_.textaccessmore AS textaccessmore_43, t1_.request_translation_text AS request_translation_text_44, t1_.request_performing_text AS request_performing_text_45, t1_.help_translation AS help_translation_46, t1_.help_publishing AS help_publishing_47, t1_.help_other AS help_other_48, t1_.moreinfo AS moreinfo_49, t1_.nmale AS nmale_50, t1_.nfemale AS nfemale_51, t1_.npeople AS npeople_52, t1_.textorder AS textorder_53, t1_.nbpages AS nbpages_54, t1_.price AS price_55, t1_.selection_aneth AS selection_aneth_56, t1_.idtext_aneth AS idtext_aneth_57, t1_.aide_creation AS aide_creation_58, t1_.comments AS comments_59, t1_.url_clean AS url_clean_60, t1_.textfictif AS textfictif_61, t1_.valid_opendata AS valid_opendata_62, t1_.dateupdate AS dateupdate_63, t1_.dateinsert AS dateinsert_64, t1_.publish AS publish_65, t1_.statut AS statut_66, t1_.valid AS valid_67, t3_.idtypespectacle AS idtypespectacle_68 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s0_.idcontact = c7_.idcontact WHERE s2_.language <> 'fr' AND s0_.idspectacle = s2_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND t1_.idtext IN ('4882', '4878', '4880', '4883') GROUP BY s2_.idspectacle ORDER BY sclr_0 DESC LIMIT 500;
|
87 |
0.05 ms |
SELECT DISTINCT t0_.idtext AS idtext_0 FROM texts t1_ INNER JOIN text_adaptation t2_ ON t1_.idtext = t2_.idtextadaptation INNER JOIN texts t0_ ON t0_.idtext = t2_.idtext WHERE t1_.idtext = 2659
SELECT DISTINCT t0_.idtext AS idtext_0 FROM texts t1_ INNER JOIN text_adaptation t2_ ON t1_.idtext = t2_.idtextadaptation INNER JOIN texts t0_ ON t0_.idtext = t2_.idtext WHERE t1_.idtext = 2659;
|
88 |
0.81 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 text_spectacle t6_ ON s0_.idspectacle = t6_.idspectacle LEFT JOIN texts t5_ ON t5_.idtext = t6_.idtext LEFT JOIN spectacle_person s8_ ON s0_.idspectacle = s8_.idspectacle LEFT JOIN persons p7_ ON p7_.idperson = s8_.idperson INNER JOIN contacts c9_ ON s1_.idcontact = c9_.idcontact WHERE s0_.language = 'fr' AND (s0_.publish = 1 AND t2_.idtext = 2659) 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 text_spectacle t6_ ON s0_.idspectacle = t6_.idspectacle LEFT JOIN texts t5_ ON t5_.idtext = t6_.idtext LEFT JOIN spectacle_person s8_ ON s0_.idspectacle = s8_.idspectacle LEFT JOIN persons p7_ ON p7_.idperson = s8_.idperson INNER JOIN contacts c9_ ON s1_.idcontact = c9_.idcontact WHERE s0_.language = 'fr' AND (s0_.publish = 1 AND t2_.idtext = 2659) ORDER BY s1_.date ASC;
|
89 |
0.54 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
FROM podcasts d, podcast_text do
WHERE d.`publish`=1
AND do.`idpodcast`= d.`idpodcast` AND do.`idtext`=2659 AND d.code_franceinter IS NOT NULL
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
FROM podcasts d, podcast_text do
WHERE d.`publish`=1
AND do.`idpodcast`= d.`idpodcast` AND do.`idtext`=2659 AND d.code_franceinter IS NOT NULL ;
|
90 |
0.28 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
FROM podcasts d, podcast_text do
WHERE d.`publish`=1
AND do.`idpodcast`= d.`idpodcast` AND do.`idtext`=2659 AND d.code_soundcloud IS NOT NULL
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
FROM podcasts d, podcast_text do
WHERE d.`publish`=1
AND do.`idpodcast`= d.`idpodcast` AND do.`idtext`=2659 AND d.code_soundcloud IS NOT NULL ;
|
91 |
0.58 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_genese'))) AND texts=1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_genese'))) AND texts=1;
|
92 |
0.46 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_genese')))
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_genese')));
|
93 |
0.54 ms |
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
FROM playlists p
LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
WHERE p.`publish`=1
AND p.`idtext` IN ('2659') AND c.`classification`='class_texte_parauteur'
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
FROM playlists p
LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
WHERE p.`publish`=1
AND p.`idtext` IN ('2659') AND c.`classification`='class_texte_parauteur';
|
94 |
0.40 ms |
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
FROM playlists p
LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
WHERE p.`publish`=1
AND p.`idtext` IN ('2659') AND c.`classification`='class_en_video'
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
FROM playlists p
LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
WHERE p.`publish`=1
AND p.`idtext` IN ('2659') AND c.`classification`='class_en_video';
|
95 |
0.33 ms |
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
FROM playlists p
LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
WHERE p.`publish`=1
AND p.`idtext` IN ('2659') AND c.`classification`='class_texte_par_traducteur'
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
FROM playlists p
LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
WHERE p.`publish`=1
AND p.`idtext` IN ('2659') AND c.`classification`='class_texte_par_traducteur';
|
96 |
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
INNER JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_text T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idtext=2659 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=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
INNER JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_text T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idtext=2659 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 ;
|
97 |
0.21 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (6))) AND texts=1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (6))) AND texts=1;
|
98 |
0.42 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (6)))
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (6)));
|
99 |
0.15 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (214))) AND texts=1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (214))) AND texts=1;
|
100 |
0.38 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (214)))
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (214)));
|
101 |
0.14 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (7))) AND texts=1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (7))) AND texts=1;
|
102 |
0.41 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (7)))
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (7)));
|
103 |
0.15 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (8))) AND texts=1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (8))) AND texts=1;
|
104 |
0.36 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (8)))
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (8)));
|
105 |
0.05 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (125))) AND texts=1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (125))) AND texts=1;
|
106 |
0.40 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (125)))
SELECT COUNT(DISTINCT(oc.idcontent)) as total
FROM object_content oc,
contents c,
content_classification cc,
classifications cl
WHERE oc.idcontent=c.idcontent
AND c.idcontent=cc.idcontent
AND oc.idobject='2659'
AND oc.object='texts'
AND cl.idclassification=cc.idclassification AND ((cl.idclassification IN (125)));
|
107 |
0.78 ms |
SELECT COUNT(s.`idspectacle`) FROM spectacles s
JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle`
JOIN object_content oc ON oc.`idobject`=s.`idspectacle`
JOIN contents c ON c.`idcontent`=oc.`idcontent`
JOIN content_classification cc ON cc.`idcontent`=c.`idcontent`
WHERE c.publish=1
AND oc.object='spectacles'
AND cc.idclassification=125
AND ts.idtext IN (2659)
AND s.`publish`=1 AND s.`valid`=1
SELECT COUNT(s.`idspectacle`) FROM spectacles s
JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle`
JOIN object_content oc ON oc.`idobject`=s.`idspectacle`
JOIN contents c ON c.`idcontent`=oc.`idcontent`
JOIN content_classification cc ON cc.`idcontent`=c.`idcontent`
WHERE c.publish=1
AND oc.object='spectacles'
AND cc.idclassification=125
AND ts.idtext IN (2659)
AND s.`publish`=1 AND s.`valid`=1;
|
108 |
0.67 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: [
"cdafc72d06f2887d45aeb80d325ecbfc-b30d"
0
"18e3d54b00ec7e500dc760147eedd313"
]
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 = 'cdafc72d06f2887d45aeb80d325ecbfc-b30d' AND t0.idcontent = 0 AND t0.md5url = '18e3d54b00ec7e500dc760147eedd313';
|
109 |
2.43 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"article"
"thnet"
"/textes/Misterioso-119/mises-en-scene/"
"18e3d54b00ec7e500dc760147eedd313"
0
"texts"
2659
0
"fr"
"cdafc72d06f2887d45aeb80d325ecbfc-b30d"
"/home/web/theatre-contemporain.net/dev/src/Controller/TextController.php:333"
]
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES ('article', 'thnet', '/textes/Misterioso-119/mises-en-scene/', '18e3d54b00ec7e500dc760147eedd313', 0, 'texts', 2659, 0, 'fr', 'cdafc72d06f2887d45aeb80d325ecbfc-b30d', '/home/web/theatre-contemporain.net/dev/src/Controller/TextController.php:333');
|
110 |
0.99 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;
|