1
2.12 ms
SELECT idtext FROM texts WHERE url_clean = 'Ana-contre-la-mort-Gabriel-Calderon-39013'
SELECT idtext FROM texts WHERE url_clean = 'Ana-contre-la-mort-Gabriel-Calderon-39013' ;
Copy
2
11.50 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 = ?
Copy
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 = '39013' ;
Copy
3
0.97 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 = 39013
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 = 39013
ORDER BY t . title ;
Copy
4
3.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 = 39013 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 = 39013 ORDER BY j2 . classement ASC ;
Copy
5
1.26 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39001 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 = 39001 ORDER BY j2 . classement ASC ;
Copy
6
1.77 ms
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 39013
SELECT DISTINCT (ta . idtextadaptation ) FROM text_adaptation ta WHERE ta . idtext = 39013 ;
Copy
7
1.28 ms
SELECT t . idtext FROM texts t WHERE t . idtext = 39013
SELECT t . idtext FROM texts t WHERE t . idtext = 39013 ;
Copy
8
313.00 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 = 39013
OR ts . idtext IN (
39013
)OR ts . idtext IN (
SELECT DISTINCT (t . idtext )
FROM
texts t ,
text_traduction tt
WHERE
t . idtext = tt . idtexttraduction
AND tt . idtext = 39013
))
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 = 39013
OR ts . idtext IN (
39013
)OR ts . idtext IN (
SELECT DISTINCT (t . idtext )
FROM
texts t ,
text_traduction tt
WHERE
t . idtext = tt . idtexttraduction
AND tt . idtext = 39013
));
Copy
9
14.57 ms
SELECT COUNT (DISTINCT (t . `idtext` )) as total
FROM text_traduction tt , texts t
WHERE tt . `idtexttraduction` = t . `idtext` AND tt . `idtext` = 39013 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` = 39013 AND t . publish = 1 ;
Copy
10
0.17 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 ;
Copy
11
2.82 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 = '39013'
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 = '39013'
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 ;
Copy
12
3.60 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 = ?
Copy
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 = 39001 ;
Copy
13
0.16 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 = 39001 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 = 39001 ORDER BY j2 . classement ASC ;
Copy
14
0.87 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 = 39013
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 = 39013 ;
Copy
15
2.83 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 = 39013 ) 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 = 39013 ) ORDER BY s1_ . date ASC ;
Copy
16
17.43 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 = 39013
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 = 39013 ;
Copy
17
2.65 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 = 'es' AND (s2_ . publish = 1 AND t1_ . idtext = 39013 ) GROUP BY s2_ . idspectacle ORDER BY sclr_0 DESC
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 = 'es'
AND (
s2_ . publish = 1
AND t1_ . idtext = 39013
)
GROUP BY
s2_ . idspectacle
ORDER BY
sclr_0 DESC
Copy
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 = 'es' AND (s2_ . publish = 1 AND t1_ . idtext = 39013 ) GROUP BY s2_ . idspectacle ORDER BY sclr_0 DESC ;
Copy
18
2.16 ms
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_text` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_text . `idtext` = 39013 AND ( `podcasts` . `code_franceinter` IS NOT NULL OR `podcasts` . `code_soundcloud` IS NOT NULL ) AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_text . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 1
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_text` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_text . `idtext` = 39013 AND ( `podcasts` . `code_franceinter` IS NOT NULL OR `podcasts` . `code_soundcloud` IS NOT NULL ) AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_text . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 1 ;
Copy
19
0.27 ms
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_4couv' ))) AND texts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_4couv' ))) AND texts = 1 ;
Copy
20
2.22 ms
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_4couv' ))) ORDER BY c . `range` , c . idcontent
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_4couv' ))) ORDER BY c . `range` , c . idcontent ;
Copy
21
1.46 ms
SELECT text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (2 , 3 ) AND text_aide . `idtext` = 39013 AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 10
SELECT text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (2 , 3 ) AND text_aide . `idtext` = 39013 AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 10 ;
Copy
22
0.95 ms
SELECT text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (1 ) AND text_aide . `idtext` = 39013 AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 10
SELECT text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (1 ) AND text_aide . `idtext` = 39013 AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 10 ;
Copy
23
10.30 ms
SELECT a0_ . idaide AS idaide_0 , a0_ . aide AS aide_1 , a0_ . type_aide AS type_aide_2 , a0_ . description AS description_3 , a0_ . mention_spectacles AS mention_spectacles_4 , a0_ . mention_texts AS mention_texts_5 , a0_ . mention_contacts AS mention_contacts_6 , a0_ . mention_persons AS mention_persons_7 , a0_ . url_clean AS url_clean_8 , a0_ . dateupdate AS dateupdate_9 , a0_ . dateinsert AS dateinsert_10 , a0_ . publish AS publish_11 , a1_ . idaidecontact AS idaidecontact_12 , a1_ . title AS title_13 , a1_ . description AS description_14 , a1_ . url_clean AS url_clean_15 , a1_ . dateupdate AS dateupdate_16 , a1_ . dateinsert AS dateinsert_17 , a1_ . publish AS publish_18 , c2_ . idcontact AS idcontact_19 , c2_ . type AS type_20 , c2_ . organisation AS organisation_21 , c2_ . nom_suite AS nom_suite_22 , c2_ . lastname AS lastname_23 , c2_ . firstname AS firstname_24 , c2_ . idtypestructure AS idtypestructure_25 , c2_ . license AS license_26 , c2_ . comment AS comment_27 , c2_ . private_comment AS private_comment_28 , c2_ . address1 AS address1_29 , c2_ . address2 AS address2_30 , c2_ . zip AS zip_31 , c2_ . city AS city_32 , c2_ . phone1 AS phone1_33 , c2_ . phone2 AS phone2_34 , c2_ . fax AS fax_35 , c2_ . email1 AS email1_36 , c2_ . email1_online AS email1_online_37 , c2_ . email2_online AS email2_online_38 , c2_ . email2 AS email2_39 , c2_ . url AS url_40 , c2_ . url_ticket AS url_ticket_41 , c2_ . facebook AS facebook_42 , c2_ . twitter AS twitter_43 , c2_ . instagram AS instagram_44 , c2_ . mobile AS mobile_45 , c2_ . geocodable AS geocodable_46 , c2_ . x AS x_47 , c2_ . y AS y_48 , c2_ . idmultimedia AS idmultimedia_49 , c2_ . type_view AS type_view_50 , c2_ . stats_access AS stats_access_51 , c2_ . ga_tracking_id AS ga_tracking_id_52 , c2_ . is_festival AS is_festival_53 , c2_ . link_on_video AS link_on_video_54 , c2_ . is_partenaire AS is_partenaire_55 , c2_ . valid_version AS valid_version_56 , c2_ . other_versions AS other_versions_57 , c2_ . url_redirect AS url_redirect_58 , c2_ . url_clean AS url_clean_59 , c2_ . dateupdate AS dateupdate_60 , c2_ . dateinsert AS dateinsert_61 , c2_ . publish AS publish_62 , c2_ . valid AS valid_63 FROM aides a0_ LEFT JOIN aidecontacts a1_ ON a0_ . idaidecontact = a1_ . idaidecontact LEFT JOIN contacts c2_ ON a0_ . idcontact = c2_ . idcontact WHERE a0_ . idaide = ?
SELECT
a0_ . idaide AS idaide_0 ,
a0_ . aide AS aide_1 ,
a0_ . type_aide AS type_aide_2 ,
a0_ . description AS description_3 ,
a0_ . mention_spectacles AS mention_spectacles_4 ,
a0_ . mention_texts AS mention_texts_5 ,
a0_ . mention_contacts AS mention_contacts_6 ,
a0_ . mention_persons AS mention_persons_7 ,
a0_ . url_clean AS url_clean_8 ,
a0_ . dateupdate AS dateupdate_9 ,
a0_ . dateinsert AS dateinsert_10 ,
a0_ . publish AS publish_11 ,
a1_ . idaidecontact AS idaidecontact_12 ,
a1_ . title AS title_13 ,
a1_ . description AS description_14 ,
a1_ . url_clean AS url_clean_15 ,
a1_ . dateupdate AS dateupdate_16 ,
a1_ . dateinsert AS dateinsert_17 ,
a1_ . publish AS publish_18 ,
c2_ . idcontact AS idcontact_19 ,
c2_ . type AS type_20 ,
c2_ . organisation AS organisation_21 ,
c2_ . nom_suite AS nom_suite_22 ,
c2_ . lastname AS lastname_23 ,
c2_ . firstname AS firstname_24 ,
c2_ . idtypestructure AS idtypestructure_25 ,
c2_ . license AS license_26 ,
c2_ . comment AS comment_27 ,
c2_ . private_comment AS private_comment_28 ,
c2_ . address1 AS address1_29 ,
c2_ . address2 AS address2_30 ,
c2_ . zip AS zip_31 ,
c2_ . city AS city_32 ,
c2_ . phone1 AS phone1_33 ,
c2_ . phone2 AS phone2_34 ,
c2_ . fax AS fax_35 ,
c2_ . email1 AS email1_36 ,
c2_ . email1_online AS email1_online_37 ,
c2_ . email2_online AS email2_online_38 ,
c2_ . email2 AS email2_39 ,
c2_ . url AS url_40 ,
c2_ . url_ticket AS url_ticket_41 ,
c2_ . facebook AS facebook_42 ,
c2_ . twitter AS twitter_43 ,
c2_ . instagram AS instagram_44 ,
c2_ . mobile AS mobile_45 ,
c2_ . geocodable AS geocodable_46 ,
c2_ . x AS x_47 ,
c2_ . y AS y_48 ,
c2_ . idmultimedia AS idmultimedia_49 ,
c2_ . type_view AS type_view_50 ,
c2_ . stats_access AS stats_access_51 ,
c2_ . ga_tracking_id AS ga_tracking_id_52 ,
c2_ . is_festival AS is_festival_53 ,
c2_ . link_on_video AS link_on_video_54 ,
c2_ . is_partenaire AS is_partenaire_55 ,
c2_ . valid_version AS valid_version_56 ,
c2_ . other_versions AS other_versions_57 ,
c2_ . url_redirect AS url_redirect_58 ,
c2_ . url_clean AS url_clean_59 ,
c2_ . dateupdate AS dateupdate_60 ,
c2_ . dateinsert AS dateinsert_61 ,
c2_ . publish AS publish_62 ,
c2_ . valid AS valid_63
FROM
aides a0_
LEFT JOIN aidecontacts a1_ ON a0_ . idaidecontact = a1_ . idaidecontact
LEFT JOIN contacts c2_ ON a0_ . idcontact = c2_ . idcontact
WHERE
a0_ . idaide = ?
Copy
SELECT a0_ . idaide AS idaide_0 , a0_ . aide AS aide_1 , a0_ . type_aide AS type_aide_2 , a0_ . description AS description_3 , a0_ . mention_spectacles AS mention_spectacles_4 , a0_ . mention_texts AS mention_texts_5 , a0_ . mention_contacts AS mention_contacts_6 , a0_ . mention_persons AS mention_persons_7 , a0_ . url_clean AS url_clean_8 , a0_ . dateupdate AS dateupdate_9 , a0_ . dateinsert AS dateinsert_10 , a0_ . publish AS publish_11 , a1_ . idaidecontact AS idaidecontact_12 , a1_ . title AS title_13 , a1_ . description AS description_14 , a1_ . url_clean AS url_clean_15 , a1_ . dateupdate AS dateupdate_16 , a1_ . dateinsert AS dateinsert_17 , a1_ . publish AS publish_18 , c2_ . idcontact AS idcontact_19 , c2_ . type AS type_20 , c2_ . organisation AS organisation_21 , c2_ . nom_suite AS nom_suite_22 , c2_ . lastname AS lastname_23 , c2_ . firstname AS firstname_24 , c2_ . idtypestructure AS idtypestructure_25 , c2_ . license AS license_26 , c2_ . comment AS comment_27 , c2_ . private_comment AS private_comment_28 , c2_ . address1 AS address1_29 , c2_ . address2 AS address2_30 , c2_ . zip AS zip_31 , c2_ . city AS city_32 , c2_ . phone1 AS phone1_33 , c2_ . phone2 AS phone2_34 , c2_ . fax AS fax_35 , c2_ . email1 AS email1_36 , c2_ . email1_online AS email1_online_37 , c2_ . email2_online AS email2_online_38 , c2_ . email2 AS email2_39 , c2_ . url AS url_40 , c2_ . url_ticket AS url_ticket_41 , c2_ . facebook AS facebook_42 , c2_ . twitter AS twitter_43 , c2_ . instagram AS instagram_44 , c2_ . mobile AS mobile_45 , c2_ . geocodable AS geocodable_46 , c2_ . x AS x_47 , c2_ . y AS y_48 , c2_ . idmultimedia AS idmultimedia_49 , c2_ . type_view AS type_view_50 , c2_ . stats_access AS stats_access_51 , c2_ . ga_tracking_id AS ga_tracking_id_52 , c2_ . is_festival AS is_festival_53 , c2_ . link_on_video AS link_on_video_54 , c2_ . is_partenaire AS is_partenaire_55 , c2_ . valid_version AS valid_version_56 , c2_ . other_versions AS other_versions_57 , c2_ . url_redirect AS url_redirect_58 , c2_ . url_clean AS url_clean_59 , c2_ . dateupdate AS dateupdate_60 , c2_ . dateinsert AS dateinsert_61 , c2_ . publish AS publish_62 , c2_ . valid AS valid_63 FROM aides a0_ LEFT JOIN aidecontacts a1_ ON a0_ . idaidecontact = a1_ . idaidecontact LEFT JOIN contacts c2_ ON a0_ . idcontact = c2_ . idcontact WHERE a0_ . idaide = '3' ;
Copy
24
1.14 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_ . url_clean = ?
Parameters :
[
"Maison-Antoine-Vitez "
]
SELECT
c0_ . idcontact AS idcontact_0 ,
c0_ . type AS type_1 ,
c0_ . organisation AS organisation_2 ,
c0_ . nom_suite AS nom_suite_3 ,
c0_ . lastname AS lastname_4 ,
c0_ . firstname AS firstname_5 ,
c0_ . idtypestructure AS idtypestructure_6 ,
c0_ . license AS license_7 ,
c0_ . comment AS comment_8 ,
c0_ . private_comment AS private_comment_9 ,
c0_ . address1 AS address1_10 ,
c0_ . address2 AS address2_11 ,
c0_ . zip AS zip_12 ,
c0_ . city AS city_13 ,
c0_ . phone1 AS phone1_14 ,
c0_ . phone2 AS phone2_15 ,
c0_ . fax AS fax_16 ,
c0_ . email1 AS email1_17 ,
c0_ . email1_online AS email1_online_18 ,
c0_ . email2_online AS email2_online_19 ,
c0_ . email2 AS email2_20 ,
c0_ . url AS url_21 ,
c0_ . url_ticket AS url_ticket_22 ,
c0_ . facebook AS facebook_23 ,
c0_ . twitter AS twitter_24 ,
c0_ . instagram AS instagram_25 ,
c0_ . mobile AS mobile_26 ,
c0_ . geocodable AS geocodable_27 ,
c0_ . x AS x_28 ,
c0_ . y AS y_29 ,
c0_ . idmultimedia AS idmultimedia_30 ,
c0_ . type_view AS type_view_31 ,
c0_ . stats_access AS stats_access_32 ,
c0_ . ga_tracking_id AS ga_tracking_id_33 ,
c0_ . is_festival AS is_festival_34 ,
c0_ . link_on_video AS link_on_video_35 ,
c0_ . is_partenaire AS is_partenaire_36 ,
c0_ . valid_version AS valid_version_37 ,
c0_ . other_versions AS other_versions_38 ,
c0_ . url_redirect AS url_redirect_39 ,
c0_ . url_clean AS url_clean_40 ,
c0_ . dateupdate AS dateupdate_41 ,
c0_ . dateinsert AS dateinsert_42 ,
c0_ . publish AS publish_43 ,
c0_ . valid AS valid_44 ,
c1_ . id AS id_45 ,
c1_ . fr AS fr_46 ,
c1_ . en AS en_47 ,
c1_ . es AS es_48 ,
c1_ . pt AS pt_49 ,
c1_ . de AS de_50 ,
c1_ . ru AS ru_51 ,
c1_ . orderby AS orderby_52
FROM
contacts c0_
LEFT JOIN countries c1_ ON c0_ . country = c1_ . id
WHERE
c0_ . url_clean = ?
Copy
SELECT c0_ . idcontact AS idcontact_0 , c0_ . type AS type_1 , c0_ . organisation AS organisation_2 , c0_ . nom_suite AS nom_suite_3 , c0_ . lastname AS lastname_4 , c0_ . firstname AS firstname_5 , c0_ . idtypestructure AS idtypestructure_6 , c0_ . license AS license_7 , c0_ . comment AS comment_8 , c0_ . private_comment AS private_comment_9 , c0_ . address1 AS address1_10 , c0_ . address2 AS address2_11 , c0_ . zip AS zip_12 , c0_ . city AS city_13 , c0_ . phone1 AS phone1_14 , c0_ . phone2 AS phone2_15 , c0_ . fax AS fax_16 , c0_ . email1 AS email1_17 , c0_ . email1_online AS email1_online_18 , c0_ . email2_online AS email2_online_19 , c0_ . email2 AS email2_20 , c0_ . url AS url_21 , c0_ . url_ticket AS url_ticket_22 , c0_ . facebook AS facebook_23 , c0_ . twitter AS twitter_24 , c0_ . instagram AS instagram_25 , c0_ . mobile AS mobile_26 , c0_ . geocodable AS geocodable_27 , c0_ . x AS x_28 , c0_ . y AS y_29 , c0_ . idmultimedia AS idmultimedia_30 , c0_ . type_view AS type_view_31 , c0_ . stats_access AS stats_access_32 , c0_ . ga_tracking_id AS ga_tracking_id_33 , c0_ . is_festival AS is_festival_34 , c0_ . link_on_video AS link_on_video_35 , c0_ . is_partenaire AS is_partenaire_36 , c0_ . valid_version AS valid_version_37 , c0_ . other_versions AS other_versions_38 , c0_ . url_redirect AS url_redirect_39 , c0_ . url_clean AS url_clean_40 , c0_ . dateupdate AS dateupdate_41 , c0_ . dateinsert AS dateinsert_42 , c0_ . publish AS publish_43 , c0_ . valid AS valid_44 , c1_ . id AS id_45 , c1_ . fr AS fr_46 , c1_ . en AS en_47 , c1_ . es AS es_48 , c1_ . pt AS pt_49 , c1_ . de AS de_50 , c1_ . ru AS ru_51 , c1_ . orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_ . country = c1_ . id WHERE c0_ . url_clean = 'Maison-Antoine-Vitez' ;
Copy
25
0.10 ms
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
26
1.99 ms
SELECT a0_ . idaidecontact AS idaidecontact_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . url_clean AS url_clean_3 , a0_ . dateupdate AS dateupdate_4 , a0_ . dateinsert AS dateinsert_5 , a0_ . publish AS publish_6 FROM aidecontacts a0_ WHERE a0_ . idaidecontact = ?
SELECT a0_ . idaidecontact AS idaidecontact_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . url_clean AS url_clean_3 , a0_ . dateupdate AS dateupdate_4 , a0_ . dateinsert AS dateinsert_5 , a0_ . publish AS publish_6 FROM aidecontacts a0_ WHERE a0_ . idaidecontact = 79 ;
Copy
27
1.27 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 . `idtext` IN (39013 ) GROUP BY T1 . idtext ORDER BY CAST (CONCAT (T1 . `publication_year` , '-' , T1 . `publication_month` , '-00' ) AS DATE ) ASC
SELECT DISTINCT (T1 . `idtext` ), T1 . `title` , T1 . `url_clean` , T1 . `publication_year` , T1 . `publication_month` , T1 . `isbn` , T1 . `textfictif` , T1 . `dateinsert` , T1 . `textorder` , T1 . `type` , T1 . `publish` , T1 . `statut` , T1 . `valid` , T2 . `idcontact` , T2 . `url_clean` as `url_clean_publisher` , T2 . `organisation` ,
CONCAT (T1 . `publication_year` , T1 . `publication_month` ) AS publication_date ,
CAST (CONCAT (T1 . `publication_year` , T1 . `publication_month` ) AS DATE ) AS publication_date_full FROM texts T1
LEFT JOIN contacts T2 ON T2 . `idcontact` = T1 . `idcontact_publisher` WHERE 1 AND T1 . `idtext` IN (39013 ) GROUP BY T1 . idtext ORDER BY CAST (CONCAT (T1 . `publication_year` , '-' , T1 . `publication_month` , '-00' ) AS DATE ) ASC ;
Copy
28
0.35 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 = '39013' ;
Copy
29
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 = 39013
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 = 39013
ORDER BY t . title ;
Copy
30
0.08 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 = 39001 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 = 39001 ORDER BY j2 . classement ASC ;
Copy
31
1.29 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 = 39013 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 = 39013 ORDER BY j2 . classement ASC ;
Copy
32
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 ;
Copy
33
1.66 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 = '39013'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '39013'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
34
0.10 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 ;
Copy
35
0.12 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 = '39013'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '39013'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
36
0.96 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 = 39013
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 = 39013
ORDER BY t . title ;
Copy
37
5.20 ms
SELECT fr FROM languages WHERE id = 'es'
SELECT fr FROM languages WHERE id = 'es' ;
Copy
38
1.65 ms
SELECT fr FROM countries WHERE id = 'UY'
SELECT fr FROM countries WHERE id = 'UY' ;
Copy
39
4.08 ms
SELECT text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (4 ) AND text_aide . `idtext` = 39013 AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 10
SELECT text_aide . * , aides . * , `text_aide` . `publish` as text_aide_publish
FROM `aides` ,
`text_aide`
WHERE 1 AND text_aide . `publish` = 1 AND aides . `publish` = 1 AND aides . `type_aide` IN (4 ) AND text_aide . `idtext` = 39013 AND aides . `idaide` = text_aide . `idaide`
ORDER BY text_aide . `date_start`
DESC
LIMIT 0 , 10 ;
Copy
40
3.65 ms
SELECT a0_ . idaide AS idaide_0 , a0_ . aide AS aide_1 , a0_ . type_aide AS type_aide_2 , a0_ . description AS description_3 , a0_ . mention_spectacles AS mention_spectacles_4 , a0_ . mention_texts AS mention_texts_5 , a0_ . mention_contacts AS mention_contacts_6 , a0_ . mention_persons AS mention_persons_7 , a0_ . url_clean AS url_clean_8 , a0_ . dateupdate AS dateupdate_9 , a0_ . dateinsert AS dateinsert_10 , a0_ . publish AS publish_11 , a1_ . idaidecontact AS idaidecontact_12 , a1_ . title AS title_13 , a1_ . description AS description_14 , a1_ . url_clean AS url_clean_15 , a1_ . dateupdate AS dateupdate_16 , a1_ . dateinsert AS dateinsert_17 , a1_ . publish AS publish_18 , c2_ . idcontact AS idcontact_19 , c2_ . type AS type_20 , c2_ . organisation AS organisation_21 , c2_ . nom_suite AS nom_suite_22 , c2_ . lastname AS lastname_23 , c2_ . firstname AS firstname_24 , c2_ . idtypestructure AS idtypestructure_25 , c2_ . license AS license_26 , c2_ . comment AS comment_27 , c2_ . private_comment AS private_comment_28 , c2_ . address1 AS address1_29 , c2_ . address2 AS address2_30 , c2_ . zip AS zip_31 , c2_ . city AS city_32 , c2_ . phone1 AS phone1_33 , c2_ . phone2 AS phone2_34 , c2_ . fax AS fax_35 , c2_ . email1 AS email1_36 , c2_ . email1_online AS email1_online_37 , c2_ . email2_online AS email2_online_38 , c2_ . email2 AS email2_39 , c2_ . url AS url_40 , c2_ . url_ticket AS url_ticket_41 , c2_ . facebook AS facebook_42 , c2_ . twitter AS twitter_43 , c2_ . instagram AS instagram_44 , c2_ . mobile AS mobile_45 , c2_ . geocodable AS geocodable_46 , c2_ . x AS x_47 , c2_ . y AS y_48 , c2_ . idmultimedia AS idmultimedia_49 , c2_ . type_view AS type_view_50 , c2_ . stats_access AS stats_access_51 , c2_ . ga_tracking_id AS ga_tracking_id_52 , c2_ . is_festival AS is_festival_53 , c2_ . link_on_video AS link_on_video_54 , c2_ . is_partenaire AS is_partenaire_55 , c2_ . valid_version AS valid_version_56 , c2_ . other_versions AS other_versions_57 , c2_ . url_redirect AS url_redirect_58 , c2_ . url_clean AS url_clean_59 , c2_ . dateupdate AS dateupdate_60 , c2_ . dateinsert AS dateinsert_61 , c2_ . publish AS publish_62 , c2_ . valid AS valid_63 FROM aides a0_ LEFT JOIN aidecontacts a1_ ON a0_ . idaidecontact = a1_ . idaidecontact LEFT JOIN contacts c2_ ON a0_ . idcontact = c2_ . idcontact WHERE a0_ . idaide = ?
SELECT
a0_ . idaide AS idaide_0 ,
a0_ . aide AS aide_1 ,
a0_ . type_aide AS type_aide_2 ,
a0_ . description AS description_3 ,
a0_ . mention_spectacles AS mention_spectacles_4 ,
a0_ . mention_texts AS mention_texts_5 ,
a0_ . mention_contacts AS mention_contacts_6 ,
a0_ . mention_persons AS mention_persons_7 ,
a0_ . url_clean AS url_clean_8 ,
a0_ . dateupdate AS dateupdate_9 ,
a0_ . dateinsert AS dateinsert_10 ,
a0_ . publish AS publish_11 ,
a1_ . idaidecontact AS idaidecontact_12 ,
a1_ . title AS title_13 ,
a1_ . description AS description_14 ,
a1_ . url_clean AS url_clean_15 ,
a1_ . dateupdate AS dateupdate_16 ,
a1_ . dateinsert AS dateinsert_17 ,
a1_ . publish AS publish_18 ,
c2_ . idcontact AS idcontact_19 ,
c2_ . type AS type_20 ,
c2_ . organisation AS organisation_21 ,
c2_ . nom_suite AS nom_suite_22 ,
c2_ . lastname AS lastname_23 ,
c2_ . firstname AS firstname_24 ,
c2_ . idtypestructure AS idtypestructure_25 ,
c2_ . license AS license_26 ,
c2_ . comment AS comment_27 ,
c2_ . private_comment AS private_comment_28 ,
c2_ . address1 AS address1_29 ,
c2_ . address2 AS address2_30 ,
c2_ . zip AS zip_31 ,
c2_ . city AS city_32 ,
c2_ . phone1 AS phone1_33 ,
c2_ . phone2 AS phone2_34 ,
c2_ . fax AS fax_35 ,
c2_ . email1 AS email1_36 ,
c2_ . email1_online AS email1_online_37 ,
c2_ . email2_online AS email2_online_38 ,
c2_ . email2 AS email2_39 ,
c2_ . url AS url_40 ,
c2_ . url_ticket AS url_ticket_41 ,
c2_ . facebook AS facebook_42 ,
c2_ . twitter AS twitter_43 ,
c2_ . instagram AS instagram_44 ,
c2_ . mobile AS mobile_45 ,
c2_ . geocodable AS geocodable_46 ,
c2_ . x AS x_47 ,
c2_ . y AS y_48 ,
c2_ . idmultimedia AS idmultimedia_49 ,
c2_ . type_view AS type_view_50 ,
c2_ . stats_access AS stats_access_51 ,
c2_ . ga_tracking_id AS ga_tracking_id_52 ,
c2_ . is_festival AS is_festival_53 ,
c2_ . link_on_video AS link_on_video_54 ,
c2_ . is_partenaire AS is_partenaire_55 ,
c2_ . valid_version AS valid_version_56 ,
c2_ . other_versions AS other_versions_57 ,
c2_ . url_redirect AS url_redirect_58 ,
c2_ . url_clean AS url_clean_59 ,
c2_ . dateupdate AS dateupdate_60 ,
c2_ . dateinsert AS dateinsert_61 ,
c2_ . publish AS publish_62 ,
c2_ . valid AS valid_63
FROM
aides a0_
LEFT JOIN aidecontacts a1_ ON a0_ . idaidecontact = a1_ . idaidecontact
LEFT JOIN contacts c2_ ON a0_ . idcontact = c2_ . idcontact
WHERE
a0_ . idaide = ?
Copy
SELECT a0_ . idaide AS idaide_0 , a0_ . aide AS aide_1 , a0_ . type_aide AS type_aide_2 , a0_ . description AS description_3 , a0_ . mention_spectacles AS mention_spectacles_4 , a0_ . mention_texts AS mention_texts_5 , a0_ . mention_contacts AS mention_contacts_6 , a0_ . mention_persons AS mention_persons_7 , a0_ . url_clean AS url_clean_8 , a0_ . dateupdate AS dateupdate_9 , a0_ . dateinsert AS dateinsert_10 , a0_ . publish AS publish_11 , a1_ . idaidecontact AS idaidecontact_12 , a1_ . title AS title_13 , a1_ . description AS description_14 , a1_ . url_clean AS url_clean_15 , a1_ . dateupdate AS dateupdate_16 , a1_ . dateinsert AS dateinsert_17 , a1_ . publish AS publish_18 , c2_ . idcontact AS idcontact_19 , c2_ . type AS type_20 , c2_ . organisation AS organisation_21 , c2_ . nom_suite AS nom_suite_22 , c2_ . lastname AS lastname_23 , c2_ . firstname AS firstname_24 , c2_ . idtypestructure AS idtypestructure_25 , c2_ . license AS license_26 , c2_ . comment AS comment_27 , c2_ . private_comment AS private_comment_28 , c2_ . address1 AS address1_29 , c2_ . address2 AS address2_30 , c2_ . zip AS zip_31 , c2_ . city AS city_32 , c2_ . phone1 AS phone1_33 , c2_ . phone2 AS phone2_34 , c2_ . fax AS fax_35 , c2_ . email1 AS email1_36 , c2_ . email1_online AS email1_online_37 , c2_ . email2_online AS email2_online_38 , c2_ . email2 AS email2_39 , c2_ . url AS url_40 , c2_ . url_ticket AS url_ticket_41 , c2_ . facebook AS facebook_42 , c2_ . twitter AS twitter_43 , c2_ . instagram AS instagram_44 , c2_ . mobile AS mobile_45 , c2_ . geocodable AS geocodable_46 , c2_ . x AS x_47 , c2_ . y AS y_48 , c2_ . idmultimedia AS idmultimedia_49 , c2_ . type_view AS type_view_50 , c2_ . stats_access AS stats_access_51 , c2_ . ga_tracking_id AS ga_tracking_id_52 , c2_ . is_festival AS is_festival_53 , c2_ . link_on_video AS link_on_video_54 , c2_ . is_partenaire AS is_partenaire_55 , c2_ . valid_version AS valid_version_56 , c2_ . other_versions AS other_versions_57 , c2_ . url_redirect AS url_redirect_58 , c2_ . url_clean AS url_clean_59 , c2_ . dateupdate AS dateupdate_60 , c2_ . dateinsert AS dateinsert_61 , c2_ . publish AS publish_62 , c2_ . valid AS valid_63 FROM aides a0_ LEFT JOIN aidecontacts a1_ ON a0_ . idaidecontact = a1_ . idaidecontact LEFT JOIN contacts c2_ ON a0_ . idcontact = c2_ . idcontact WHERE a0_ . idaide = '134' ;
Copy
41
4.39 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_ . url_clean = ?
Parameters :
[
"La-Mousson-d-Ete "
]
SELECT
c0_ . idcontact AS idcontact_0 ,
c0_ . type AS type_1 ,
c0_ . organisation AS organisation_2 ,
c0_ . nom_suite AS nom_suite_3 ,
c0_ . lastname AS lastname_4 ,
c0_ . firstname AS firstname_5 ,
c0_ . idtypestructure AS idtypestructure_6 ,
c0_ . license AS license_7 ,
c0_ . comment AS comment_8 ,
c0_ . private_comment AS private_comment_9 ,
c0_ . address1 AS address1_10 ,
c0_ . address2 AS address2_11 ,
c0_ . zip AS zip_12 ,
c0_ . city AS city_13 ,
c0_ . phone1 AS phone1_14 ,
c0_ . phone2 AS phone2_15 ,
c0_ . fax AS fax_16 ,
c0_ . email1 AS email1_17 ,
c0_ . email1_online AS email1_online_18 ,
c0_ . email2_online AS email2_online_19 ,
c0_ . email2 AS email2_20 ,
c0_ . url AS url_21 ,
c0_ . url_ticket AS url_ticket_22 ,
c0_ . facebook AS facebook_23 ,
c0_ . twitter AS twitter_24 ,
c0_ . instagram AS instagram_25 ,
c0_ . mobile AS mobile_26 ,
c0_ . geocodable AS geocodable_27 ,
c0_ . x AS x_28 ,
c0_ . y AS y_29 ,
c0_ . idmultimedia AS idmultimedia_30 ,
c0_ . type_view AS type_view_31 ,
c0_ . stats_access AS stats_access_32 ,
c0_ . ga_tracking_id AS ga_tracking_id_33 ,
c0_ . is_festival AS is_festival_34 ,
c0_ . link_on_video AS link_on_video_35 ,
c0_ . is_partenaire AS is_partenaire_36 ,
c0_ . valid_version AS valid_version_37 ,
c0_ . other_versions AS other_versions_38 ,
c0_ . url_redirect AS url_redirect_39 ,
c0_ . url_clean AS url_clean_40 ,
c0_ . dateupdate AS dateupdate_41 ,
c0_ . dateinsert AS dateinsert_42 ,
c0_ . publish AS publish_43 ,
c0_ . valid AS valid_44 ,
c1_ . id AS id_45 ,
c1_ . fr AS fr_46 ,
c1_ . en AS en_47 ,
c1_ . es AS es_48 ,
c1_ . pt AS pt_49 ,
c1_ . de AS de_50 ,
c1_ . ru AS ru_51 ,
c1_ . orderby AS orderby_52
FROM
contacts c0_
LEFT JOIN countries c1_ ON c0_ . country = c1_ . id
WHERE
c0_ . url_clean = ?
Copy
SELECT c0_ . idcontact AS idcontact_0 , c0_ . type AS type_1 , c0_ . organisation AS organisation_2 , c0_ . nom_suite AS nom_suite_3 , c0_ . lastname AS lastname_4 , c0_ . firstname AS firstname_5 , c0_ . idtypestructure AS idtypestructure_6 , c0_ . license AS license_7 , c0_ . comment AS comment_8 , c0_ . private_comment AS private_comment_9 , c0_ . address1 AS address1_10 , c0_ . address2 AS address2_11 , c0_ . zip AS zip_12 , c0_ . city AS city_13 , c0_ . phone1 AS phone1_14 , c0_ . phone2 AS phone2_15 , c0_ . fax AS fax_16 , c0_ . email1 AS email1_17 , c0_ . email1_online AS email1_online_18 , c0_ . email2_online AS email2_online_19 , c0_ . email2 AS email2_20 , c0_ . url AS url_21 , c0_ . url_ticket AS url_ticket_22 , c0_ . facebook AS facebook_23 , c0_ . twitter AS twitter_24 , c0_ . instagram AS instagram_25 , c0_ . mobile AS mobile_26 , c0_ . geocodable AS geocodable_27 , c0_ . x AS x_28 , c0_ . y AS y_29 , c0_ . idmultimedia AS idmultimedia_30 , c0_ . type_view AS type_view_31 , c0_ . stats_access AS stats_access_32 , c0_ . ga_tracking_id AS ga_tracking_id_33 , c0_ . is_festival AS is_festival_34 , c0_ . link_on_video AS link_on_video_35 , c0_ . is_partenaire AS is_partenaire_36 , c0_ . valid_version AS valid_version_37 , c0_ . other_versions AS other_versions_38 , c0_ . url_redirect AS url_redirect_39 , c0_ . url_clean AS url_clean_40 , c0_ . dateupdate AS dateupdate_41 , c0_ . dateinsert AS dateinsert_42 , c0_ . publish AS publish_43 , c0_ . valid AS valid_44 , c1_ . id AS id_45 , c1_ . fr AS fr_46 , c1_ . en AS en_47 , c1_ . es AS es_48 , c1_ . pt AS pt_49 , c1_ . de AS de_50 , c1_ . ru AS ru_51 , c1_ . orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_ . country = c1_ . id WHERE c0_ . url_clean = 'La-Mousson-d-Ete' ;
Copy
42
1.77 ms
SELECT a0_ . idaidecontact AS idaidecontact_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . url_clean AS url_clean_3 , a0_ . dateupdate AS dateupdate_4 , a0_ . dateinsert AS dateinsert_5 , a0_ . publish AS publish_6 FROM aidecontacts a0_ WHERE a0_ . idaidecontact = ?
SELECT a0_ . idaidecontact AS idaidecontact_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . url_clean AS url_clean_3 , a0_ . dateupdate AS dateupdate_4 , a0_ . dateinsert AS dateinsert_5 , a0_ . publish AS publish_6 FROM aidecontacts a0_ WHERE a0_ . idaidecontact = 102 ;
Copy
43
0.44 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 . `idtext` IN (39013 ) GROUP BY T1 . idtext ORDER BY CAST (CONCAT (T1 . `publication_year` , '-' , T1 . `publication_month` , '-00' ) AS DATE ) ASC
SELECT DISTINCT (T1 . `idtext` ), T1 . `title` , T1 . `url_clean` , T1 . `publication_year` , T1 . `publication_month` , T1 . `isbn` , T1 . `textfictif` , T1 . `dateinsert` , T1 . `textorder` , T1 . `type` , T1 . `publish` , T1 . `statut` , T1 . `valid` , T2 . `idcontact` , T2 . `url_clean` as `url_clean_publisher` , T2 . `organisation` ,
CONCAT (T1 . `publication_year` , T1 . `publication_month` ) AS publication_date ,
CAST (CONCAT (T1 . `publication_year` , T1 . `publication_month` ) AS DATE ) AS publication_date_full FROM texts T1
LEFT JOIN contacts T2 ON T2 . `idcontact` = T1 . `idcontact_publisher` WHERE 1 AND T1 . `idtext` IN (39013 ) GROUP BY T1 . idtext ORDER BY CAST (CONCAT (T1 . `publication_year` , '-' , T1 . `publication_month` , '-00' ) AS DATE ) ASC ;
Copy
44
0.10 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = '39013' ;
Copy
45
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 = 39013
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 = 39013
ORDER BY t . title ;
Copy
46
0.08 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 = 39001 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 = 39001 ORDER BY j2 . classement ASC ;
Copy
47
0.14 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 = 39013 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 = 39013 ORDER BY j2 . classement ASC ;
Copy
48
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 ;
Copy
49
0.21 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 = '39013'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '39013'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
50
0.13 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 ;
Copy
51
0.21 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 = '39013'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '39013'
AND of . object = 'texts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . classification IN ('class_couv' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
52
0.13 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 = 39013
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 = 39013
ORDER BY t . title ;
Copy
53
0.13 ms
SELECT fr FROM languages WHERE id = 'es'
SELECT fr FROM languages WHERE id = 'es' ;
Copy
54
2.71 ms
SELECT COUNT (email_to_get_text )
FROM text_aide
WHERE idtext = 39013
AND email_to_get_text IS NOT NULL
AND publish LIKE 1
SELECT COUNT (email_to_get_text )
FROM text_aide
WHERE idtext = 39013
AND email_to_get_text IS NOT NULL
AND publish LIKE 1
;
Copy
55
3.95 ms
SELECT t0_ . url_to_get_text AS url_to_get_text_0 FROM text_aide t0_ WHERE t0_ . idtext = ? AND t0_ . url_to_get_text IS NOT NULL AND t0_ . publish = 1 ORDER BY t0_ . dateupdate DESC LIMIT 1
SELECT t0_ . url_to_get_text AS url_to_get_text_0 FROM text_aide t0_ WHERE t0_ . idtext = 39013 AND t0_ . url_to_get_text IS NOT NULL AND t0_ . publish = 1 ORDER BY t0_ . dateupdate DESC LIMIT 1 ;
Copy
56
5.68 ms
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
INNER JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_text T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idtext = 39013 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND (( T3 . date > = '2024-03-28' )) GROUP BY T1 . idnew ORDER BY T3 . date ASC LIMIT 0 , 5
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
INNER JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_text T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idtext = 39013 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND (( T3 . date > = '2024-03-28' )) GROUP BY T1 . idnew ORDER BY T3 . date ASC LIMIT 0 , 5 ;
Copy
57
3.67 ms
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
INNER JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_text T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idtext = 39013 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND (( T3 . date < '2024-03-28' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 5
SELECT DISTINCT (T1 . idnew ), T1 . * , T2 . idextranetuser , T2 . lastname , T2 . firstname , T2 . signature , T2 . city as city_extranetuser , T2 . enseignant_etablissement , T2 . enseignant_active , T3 . idnewschedule , T3 . date , T3 . hour , T3 . idcontact , T3 . note FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
INNER JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_text T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idtext = 39013 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 AND (( T3 . date < '2024-03-28' )) GROUP BY T1 . idnew ORDER BY T3 . date DESC LIMIT 0 , 5 ;
Copy
58
0.59 ms
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = ?
SELECT t0 . idnew AS idnew_1 , t0 . title AS title_2 , t0 . type_news AS type_news_3 , t0 . description AS description_4 , t0 . markdown AS markdown_5 , t0 . date_start AS date_start_6 , t0 . date_end AS date_end_7 , t0 . hour AS hour_8 , t0 . location AS location_9 , t0 . city AS city_10 , t0 . zip AS zip_11 , t0 . contacts AS contacts_12 , t0 . url AS url_13 , t0 . url_more AS url_more_14 , t0 . infos_contacts AS infos_contacts_15 , t0 . url_file AS url_file_16 , t0 . copyright_file AS copyright_file_17 , t0 . is_homepage AS is_homepage_18 , t0 . publish AS publish_19 , t0 . valid AS valid_20 , t0 . statut AS statut_21 , t0 . dateinsert AS dateinsert_22 , t0 . dateupdate AS dateupdate_23 , t0 . idextranetuser_lock AS idextranetuser_lock_24 , t0 . idextranetuser AS idextranetuser_25 , t0 . idregion AS idregion_26 , t0 . country AS country_27 FROM news t0 WHERE t0 . idnew = '12352' ;
Copy
59
1.14 ms
SELECT url_file FROM news WHERE idnew = 12352
SELECT url_file FROM news WHERE idnew = 12352 ;
Copy
60
5.37 ms
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12352 AND sc . date < '2024-03-28' ORDER BY sc . date DESC LIMIT 0 , 1
SELECT sc . date , c . city , c . country , c . zip , c . organisation , c . url_clean , c . idcontact FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12352 AND sc . date < '2024-03-28' ORDER BY sc . date DESC LIMIT 0 , 1 ;
Copy
61
0.83 ms
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12352 AND sc . date < '2024-03-28' AND sc . idcontact = 14647 GROUP BY sc . idcontact
SELECT MIN (sc . date ) as datestart , MAX (sc . date ) as dateend , c . city , c . country FROM newschedules sc , contacts c
WHERE sc . idcontact = c . idcontact
AND sc . idnew = 12352 AND sc . date < '2024-03-28' AND sc . idcontact = 14647 GROUP BY sc . idcontact ;
Copy
62
1.00 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12352
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idnew FROM theatreok_dev . persons j1 , theatreok_dev . new_person j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idperson = j2 . idperson
AND j3 . idnew = 12352 ;
Copy
63
1.03 ms
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12352
SELECT j1 . idcontact , j1 . lastname , j1 . firstname , j1 . organisation , j1 . type , j1 . url_clean , j3 . idnew FROM theatreok_dev . contacts j1 , theatreok_dev . new_contact j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idcontact = j2 . idcontact
AND j3 . idnew = 12352 ;
Copy
64
0.71 ms
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12352
SELECT j1 . idspectacle , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . spectacles j1 , theatreok_dev . new_spectacle j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idnew = 12352 ;
Copy
65
0.88 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20335
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 20335 ;
Copy
66
0.43 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24070
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24070 ;
Copy
67
0.59 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31381
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31381 ;
Copy
68
0.63 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31382
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31382 ;
Copy
69
0.33 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31383
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31383 ;
Copy
70
0.27 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31384
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31384 ;
Copy
71
0.35 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31385
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31385 ;
Copy
72
0.45 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31386
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31386 ;
Copy
73
0.52 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31387
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31387 ;
Copy
74
1.25 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31388
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31388 ;
Copy
75
0.45 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31389
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31389 ;
Copy
76
0.77 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31390
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31390 ;
Copy
77
1.69 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31391
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31391 ;
Copy
78
0.54 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31392
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31392 ;
Copy
79
0.54 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31393
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31393 ;
Copy
80
0.91 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31394
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31394 ;
Copy
81
0.45 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31395
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31395 ;
Copy
82
0.89 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31396
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31396 ;
Copy
83
0.75 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31397
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31397 ;
Copy
84
0.34 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31398
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31398 ;
Copy
85
0.72 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31399
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31399 ;
Copy
86
0.44 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31400
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31400 ;
Copy
87
0.74 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31401
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31401 ;
Copy
88
0.69 ms
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31402
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 31402 ;
Copy
89
1.33 ms
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12352
SELECT j1 . idtext , j1 . title , j1 . valid , j1 . publish , j1 . url_clean , j3 . idnew FROM theatreok_dev . texts j1 , theatreok_dev . new_text j2 , theatreok_dev . news j3
WHERE j3 . idnew = j2 . idnew
AND j1 . idtext = j2 . idtext
AND j3 . idnew = 12352 ;
Copy
90
0.34 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 = 25117 ;
Copy
91
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 = 25117 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 = 25117 ORDER BY j2 . classement ASC ;
Copy
92
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 = 29827 ;
Copy
93
0.46 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 = 29827 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 = 29827 ORDER BY j2 . classement ASC ;
Copy
94
0.36 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 = 35906 ;
Copy
95
1.21 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 = 35906 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 = 35906 ORDER BY j2 . classement ASC ;
Copy
96
0.29 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 = 36674 ;
Copy
97
10.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 = 36674 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 = 36674 ORDER BY j2 . classement ASC ;
Copy
98
0.37 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 = 37297 ;
Copy
99
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 = 37297
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 = 37297
ORDER BY t . title ;
Copy
100
1.35 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 = 37296 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 = 37296 ORDER BY j2 . classement ASC ;
Copy
101
4.10 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 37318 ;
Copy
102
1.65 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 = 37318
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 = 37318
ORDER BY t . title ;
Copy
103
1.25 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 37317 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 = 37317 ORDER BY j2 . classement ASC ;
Copy
104
0.49 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 = 37465 ;
Copy
105
1.47 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 = 37465 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 = 37465 ORDER BY j2 . classement ASC ;
Copy
106
0.44 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 = 37466 ;
Copy
107
0.75 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 = 37466 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 = 37466 ORDER BY j2 . classement ASC ;
Copy
108
0.66 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 = 37597 ;
Copy
109
0.91 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 = 37597
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 = 37597
ORDER BY t . title ;
Copy
110
1.45 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 = 37596 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 = 37596 ORDER BY j2 . classement ASC ;
Copy
111
0.29 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 = 37812 ;
Copy
112
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 = 37812 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 = 37812 ORDER BY j2 . classement ASC ;
Copy
113
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 = 38108 ;
Copy
114
0.32 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 = 38108
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 = 38108
ORDER BY t . title ;
Copy
115
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_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38107 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 = 38107 ORDER BY j2 . classement ASC ;
Copy
116
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 = 38994 ;
Copy
117
0.38 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 = 38994 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 = 38994 ORDER BY j2 . classement ASC ;
Copy
118
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 = 38997 ;
Copy
119
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 = 38997
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 = 38997
ORDER BY t . title ;
Copy
120
0.28 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 = 38995 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 = 38995 ORDER BY j2 . classement ASC ;
Copy
121
0.26 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 = 38999 ;
Copy
122
0.56 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 = 38999
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 = 38999
ORDER BY t . title ;
Copy
123
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 = 38998 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 = 38998 ORDER BY j2 . classement ASC ;
Copy
124
0.42 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 = 39012 ;
Copy
125
0.27 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 = 39012
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 = 39012
ORDER BY t . title ;
Copy
126
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 = 39000 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 = 39000 ORDER BY j2 . classement ASC ;
Copy
127
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 = 39013 ;
Copy
128
0.15 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 = 39013
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 = 39013
ORDER BY t . title ;
Copy
129
0.06 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 = 39001 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 = 39001 ORDER BY j2 . classement ASC ;
Copy
130
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 = 39014 ;
Copy
131
0.27 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 = 39014
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 = 39014
ORDER BY t . title ;
Copy
132
0.48 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 = 39002 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 = 39002 ORDER BY j2 . classement ASC ;
Copy
133
0.26 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 = 39015 ;
Copy
134
0.27 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 = 39015
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 = 39015
ORDER BY t . title ;
Copy
135
0.29 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39003 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 = 39003 ORDER BY j2 . classement ASC ;
Copy
136
0.25 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39016 ;
Copy
137
0.50 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 = 39016
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 = 39016
ORDER BY t . title ;
Copy
138
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 = 39004 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 = 39004 ORDER BY j2 . classement ASC ;
Copy
139
0.25 ms
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 39005 ;
Copy
140
0.68 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 = 39005 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 = 39005 ORDER BY j2 . classement ASC ;
Copy
141
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 = 39006 ;
Copy
142
0.47 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 = 39006 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 = 39006 ORDER BY j2 . classement ASC ;
Copy
143
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 = 39007 ;
Copy
144
0.29 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39007 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 = 39007 ORDER BY j2 . classement ASC ;
Copy
145
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 = 39008 ;
Copy
146
0.28 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 = 39008 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 = 39008 ORDER BY j2 . classement ASC ;
Copy
147
0.21 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 = 39017 ;
Copy
148
0.27 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 = 39017
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 = 39017
ORDER BY t . title ;
Copy
149
0.29 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38704 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 = 38704 ORDER BY j2 . classement ASC ;
Copy
150
0.90 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 ('39013' ) 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 ('39013' ) AND c . `classification` = 'class_texte_parauteur' ;
Copy
151
1.71 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 ('39013' ) AND s2_ . idtypespectacle = 4 GROUP BY s2_ . idspectacle ORDER BY sclr_0 DESC LIMIT 2
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 ('39013' )
AND s2_ . idtypespectacle = 4
GROUP BY
s2_ . idspectacle
ORDER BY
sclr_0 DESC
LIMIT
2
Copy
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 ('39013' ) AND s2_ . idtypespectacle = 4 GROUP BY s2_ . idspectacle ORDER BY sclr_0 DESC LIMIT 2 ;
Copy
152
0.98 ms
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_text` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_text . `idtext` IN (39013 ) AND podcasts . `code_ft` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_text . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 1
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcast_text` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_text . `idtext` IN (39013 ) AND podcasts . `code_ft` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `idpodcast` = podcast_text . `idpodcast`
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 1 ;
Copy
153
0.34 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 = 39013
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 = 39013 ;
Copy
154
0.97 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` = 39013 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` = 39013 AND d . code_franceinter IS NOT NULL ;
Copy
155
0.44 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` = 39013 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` = 39013 AND d . code_soundcloud IS NOT NULL ;
Copy
156
0.28 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 ;
Copy
157
0.78 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . classification IN ('class_genese' )));
Copy
158
0.66 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 ('39013' ) 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 ('39013' ) AND c . `classification` = 'class_texte_parauteur' ;
Copy
159
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 ('39013' ) 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 ('39013' ) AND c . `classification` = 'class_en_video' ;
Copy
160
0.42 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 ('39013' ) 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 ('39013' ) AND c . `classification` = 'class_texte_par_traducteur' ;
Copy
161
0.40 ms
SELECT p . `idplaylist`
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` = 39013 AND c . `classification` = 'class_texte_par_traducteur' LIMIT 0 , 1
SELECT p . `idplaylist`
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` = 39013 AND c . `classification` = 'class_texte_par_traducteur' LIMIT 0 , 1 ;
Copy
162
0.35 ms
SELECT p0_ . idplaylist AS idplaylist_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . url_clean AS url_clean_3 , p0_ . dateupdate AS dateupdate_4 , p0_ . dateinsert AS dateinsert_5 , p0_ . publish AS publish_6 , p0_ . valid AS valid_7 FROM playlists p0_ WHERE p0_ . idplaylist = ?
SELECT p0_ . idplaylist AS idplaylist_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . url_clean AS url_clean_3 , p0_ . dateupdate AS dateupdate_4 , p0_ . dateinsert AS dateinsert_5 , p0_ . publish AS publish_6 , p0_ . valid AS valid_7 FROM playlists p0_ WHERE p0_ . idplaylist = '851' ;
Copy
163
0.48 ms
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . persons j1 , theatreok_dev . playlists j3
WHERE j1 . idperson = j3 . idperson
AND j3 . idplaylist = 851
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . persons j1 , theatreok_dev . playlists j3
WHERE j1 . idperson = j3 . idperson
AND j3 . idplaylist = 851 ;
Copy
164
0.39 ms
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . spectacles j1 , theatreok_dev . playlists j3
WHERE j1 . idspectacle = j3 . idspectacle
AND j3 . idplaylist = 851
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . spectacles j1 , theatreok_dev . playlists j3
WHERE j1 . idspectacle = j3 . idspectacle
AND j3 . idplaylist = 851 ;
Copy
165
0.22 ms
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . contacts j1 , theatreok_dev . playlists j3
WHERE j1 . idcontact = j3 . idcontact
AND j3 . idplaylist = 851
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . contacts j1 , theatreok_dev . playlists j3
WHERE j1 . idcontact = j3 . idcontact
AND j3 . idplaylist = 851 ;
Copy
166
0.32 ms
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . texts j1 , theatreok_dev . playlists j3
WHERE j1 . idtext = j3 . idtext
AND j3 . idplaylist = 851
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idplaylist FROM theatreok_dev . texts j1 , theatreok_dev . playlists j3
WHERE j1 . idtext = j3 . idtext
AND j3 . idplaylist = 851 ;
Copy
167
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 = 39013 ;
Copy
168
0.06 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 = 39013
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 = 39013
ORDER BY t . title ;
Copy
169
0.06 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 = 39001 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 = 39001 ORDER BY j2 . classement ASC ;
Copy
170
0.90 ms
SELECT j1 . idmultimedia , j1 . sujet_titre , j1 . url_clean , j1 . status , j1 . price , j3 . idplaylist FROM theatreok_dev . multimedias j1 , theatreok_dev . playlist_multimedia j2 , theatreok_dev . playlists j3
WHERE j3 . idplaylist = j2 . idplaylist
AND j1 . idmultimedia = j2 . idmultimedia
AND j3 . idplaylist = 851 ORDER BY j2 . `orderplaylist`
SELECT j1 . idmultimedia , j1 . sujet_titre , j1 . url_clean , j1 . status , j1 . price , j3 . idplaylist FROM theatreok_dev . multimedias j1 , theatreok_dev . playlist_multimedia j2 , theatreok_dev . playlists j3
WHERE j3 . idplaylist = j2 . idplaylist
AND j1 . idmultimedia = j2 . idmultimedia
AND j3 . idplaylist = 851 ORDER BY j2 . `orderplaylist` ;
Copy
171
0.33 ms
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idplaylist FROM theatreok_dev . classifications j1 , theatreok_dev . playlist_classification j2 , theatreok_dev . playlists j3
WHERE j3 . idplaylist = j2 . idplaylist
AND j1 . idclassification = j2 . idclassification
AND j3 . idplaylist = 851
SELECT j1 . idclassification , j1 . classification , j1 . type , j1 . idgroupclassification , j3 . idplaylist FROM theatreok_dev . classifications j1 , theatreok_dev . playlist_classification j2 , theatreok_dev . playlists j3
WHERE j3 . idplaylist = j2 . idplaylist
AND j1 . idclassification = j2 . idclassification
AND j3 . idplaylist = 851 ;
Copy
172
0.84 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 = 39013 ) 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 = 39013 ) AND T1 . publish = 1 AND T1 . publish = 1 AND T1 . valid = 1 ;
Copy
173
0.45 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 ;
Copy
174
0.59 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . idclassification IN (6 )));
Copy
175
0.20 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 ;
Copy
176
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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . idclassification IN (214 )));
Copy
177
0.17 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 ;
Copy
178
0.64 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . idclassification IN (7 )));
Copy
179
0.08 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 ;
Copy
180
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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . idclassification IN (8 )));
Copy
181
0.19 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 ;
Copy
182
0.35 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 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 = '39013'
AND oc . object = 'texts'
AND cl . idclassification = cc . idclassification AND c . publish = 1 AND ((cl . idclassification IN (125 )));
Copy
183
0.48 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 (39013 )
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 (39013 )
AND s . `publish` = 1 AND s . `valid` = 1 ;
Copy
184
1.12 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 :
[
"67c5bd33fe142287e07074c912d2cb32-7ccf "
0
"30e14937dcb4ec657d50a87cdf792a16 "
]
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 = '67c5bd33fe142287e07074c912d2cb32-7ccf' AND t0 . idcontent = 0 AND t0 . md5url = '30e14937dcb4ec657d50a87cdf792a16' ;
Copy
185
1.03 ms
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/textes/Ana-contre-la-mort-Gabriel-Calderon-39013/ "
"30e14937dcb4ec657d50a87cdf792a16 "
0
"texts "
39013
0
"fr "
"67c5bd33fe142287e07074c912d2cb32-7ccf "
"/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/Ana-contre-la-mort-Gabriel-Calderon-39013/' , '30e14937dcb4ec657d50a87cdf792a16' , 0 , 'texts' , 39013 , 0 , 'fr' , '67c5bd33fe142287e07074c912d2cb32-7ccf' , '/home/web/theatre-contemporain.net/dev/src/Controller/TextController.php:333' );
Copy
186
1.07 ms
SELECT * FROM bannieres
WHERE publish = 1
AND valid = 1
AND is_bottom = 1
AND date_start < = NOW()
AND date_end > = NOW()
ORDER BY bannieres . order ASC
LIMIT 0 , 10
SELECT * FROM bannieres
WHERE publish = 1
AND valid = 1
AND is_bottom = 1
AND date_start < = NOW()
AND date_end > = NOW()
ORDER BY bannieres . order ASC
LIMIT 0 , 10 ;
Copy