162.89 ms (15.95%)
1
SELECT a . idannonce , a . dateinsert , a . sujet , c . url_clean , c . name , c . idcategorie
FROM ann_annonces a , ann_categories c
WHERE c . idcategorie = a . idcategorie AND a . online = 1 AND a . valid = 1 AND c . idcategorie IN (1 ) ORDER BY a . dateinsert DESC LIMIT 0 , 3
SELECT a . idannonce , a . dateinsert , a . sujet , c . url_clean , c . name , c . idcategorie
FROM ann_annonces a , ann_categories c
WHERE c . idcategorie = a . idcategorie AND a . online = 1 AND a . valid = 1 AND c . idcategorie IN (1 ) ORDER BY a . dateinsert DESC LIMIT 0 , 3 ;
Copy
162.84 ms (15.95%)
1
SELECT a . idannonce , a . dateinsert , a . sujet , c . url_clean , c . name , c . idcategorie
FROM ann_annonces a , ann_categories c
WHERE c . idcategorie = a . idcategorie AND a . online = 1 AND a . valid = 1 AND c . idcategorie IN (3 ) ORDER BY a . dateinsert DESC LIMIT 0 , 3
SELECT a . idannonce , a . dateinsert , a . sujet , c . url_clean , c . name , c . idcategorie
FROM ann_annonces a , ann_categories c
WHERE c . idcategorie = a . idcategorie AND a . online = 1 AND a . valid = 1 AND c . idcategorie IN (3 ) ORDER BY a . dateinsert DESC LIMIT 0 , 3 ;
Copy
101.92 ms (9.98%)
1
SELECT sc . `date` , YEAR (sc . `date` ) as annee
FROM `schedules` sc
JOIN `spectacles` s ON sc . `idspectacle` = s . `idspectacle`
JOIN `text_spectacle` ts ON ts . `idspectacle` = s . `idspectacle`
JOIN `playlists` p ON p . `idtext` = ts . `idtext`
JOIN `playlist_classification` pc ON pc . `idplaylist` = p . `idplaylist`
WHERE 1
AND s . `textfictif` = 0 AND s . `publish` = 1 AND s . `valid` = 1
AND p . `publish` = 1
AND pc . `idclassification` IN (144 )
AND sc . `date` > '1999-12-31'
ORDER BY sc . `date`
SELECT sc . `date` , YEAR (sc . `date` ) as annee
FROM `schedules` sc
JOIN `spectacles` s ON sc . `idspectacle` = s . `idspectacle`
JOIN `text_spectacle` ts ON ts . `idspectacle` = s . `idspectacle`
JOIN `playlists` p ON p . `idtext` = ts . `idtext`
JOIN `playlist_classification` pc ON pc . `idplaylist` = p . `idplaylist`
WHERE 1
AND s . `textfictif` = 0 AND s . `publish` = 1 AND s . `valid` = 1
AND p . `publish` = 1
AND pc . `idclassification` IN (144 )
AND sc . `date` > '1999-12-31'
ORDER BY sc . `date` ;
Copy
66.16 ms (6.48%)
27
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = ? AND s0_ . date > = ? GROUP BY s0_ . idcontact ORDER BY s0_ . date ASC LIMIT 1
Parameters :
[
26495
"2024-04-25 "
]
SELECT
MIN (s0_ . date ) AS sclr_0 ,
MAX (s0_ . date ) AS sclr_1 ,
s0_ . idschedule AS idschedule_2 ,
s0_ . date AS date_3 ,
s0_ . hour AS hour_4 ,
s0_ . is_creation AS is_creation_5 ,
s0_ . is_cancelled AS is_cancelled_6 ,
s0_ . idcontact_festival AS idcontact_festival_7 ,
s0_ . url_spectacle AS url_spectacle_8 ,
s0_ . url_booking AS url_booking_9 ,
s0_ . note AS note_10 ,
s0_ . dateupdate AS dateupdate_11 ,
s0_ . dateinsert AS dateinsert_12 ,
s0_ . publish AS publish_13 ,
s0_ . valid AS valid_14 ,
c1_ . idcontact AS idcontact_15 ,
c1_ . type AS type_16 ,
c1_ . organisation AS organisation_17 ,
c1_ . nom_suite AS nom_suite_18 ,
c1_ . lastname AS lastname_19 ,
c1_ . firstname AS firstname_20 ,
c1_ . idtypestructure AS idtypestructure_21 ,
c1_ . license AS license_22 ,
c1_ . comment AS comment_23 ,
c1_ . private_comment AS private_comment_24 ,
c1_ . address1 AS address1_25 ,
c1_ . address2 AS address2_26 ,
c1_ . zip AS zip_27 ,
c1_ . city AS city_28 ,
c1_ . phone1 AS phone1_29 ,
c1_ . phone2 AS phone2_30 ,
c1_ . fax AS fax_31 ,
c1_ . email1 AS email1_32 ,
c1_ . email1_online AS email1_online_33 ,
c1_ . email2_online AS email2_online_34 ,
c1_ . email2 AS email2_35 ,
c1_ . url AS url_36 ,
c1_ . url_ticket AS url_ticket_37 ,
c1_ . facebook AS facebook_38 ,
c1_ . twitter AS twitter_39 ,
c1_ . instagram AS instagram_40 ,
c1_ . mobile AS mobile_41 ,
c1_ . geocodable AS geocodable_42 ,
c1_ . x AS x_43 ,
c1_ . y AS y_44 ,
c1_ . idmultimedia AS idmultimedia_45 ,
c1_ . type_view AS type_view_46 ,
c1_ . stats_access AS stats_access_47 ,
c1_ . ga_tracking_id AS ga_tracking_id_48 ,
c1_ . is_festival AS is_festival_49 ,
c1_ . link_on_video AS link_on_video_50 ,
c1_ . is_partenaire AS is_partenaire_51 ,
c1_ . valid_version AS valid_version_52 ,
c1_ . other_versions AS other_versions_53 ,
c1_ . url_redirect AS url_redirect_54 ,
c1_ . url_clean AS url_clean_55 ,
c1_ . dateupdate AS dateupdate_56 ,
c1_ . dateinsert AS dateinsert_57 ,
c1_ . publish AS publish_58 ,
c1_ . valid AS valid_59 ,
s0_ . idspectacle AS idspectacle_60 ,
s0_ . idcontact AS idcontact_61 ,
s0_ . idextranetuser AS idextranetuser_62 ,
c1_ . country AS country_63 ,
c1_ . idextranetuser AS idextranetuser_64
FROM
schedules s0_
LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact
WHERE
s0_ . idspectacle = ?
AND s0_ . date > = ?
GROUP BY
s0_ . idcontact
ORDER BY
s0_ . date ASC
LIMIT
1
Copy
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , s0_ . idschedule AS idschedule_2 , s0_ . date AS date_3 , s0_ . hour AS hour_4 , s0_ . is_creation AS is_creation_5 , s0_ . is_cancelled AS is_cancelled_6 , s0_ . idcontact_festival AS idcontact_festival_7 , s0_ . url_spectacle AS url_spectacle_8 , s0_ . url_booking AS url_booking_9 , s0_ . note AS note_10 , s0_ . dateupdate AS dateupdate_11 , s0_ . dateinsert AS dateinsert_12 , s0_ . publish AS publish_13 , s0_ . valid AS valid_14 , c1_ . idcontact AS idcontact_15 , c1_ . type AS type_16 , c1_ . organisation AS organisation_17 , c1_ . nom_suite AS nom_suite_18 , c1_ . lastname AS lastname_19 , c1_ . firstname AS firstname_20 , c1_ . idtypestructure AS idtypestructure_21 , c1_ . license AS license_22 , c1_ . comment AS comment_23 , c1_ . private_comment AS private_comment_24 , c1_ . address1 AS address1_25 , c1_ . address2 AS address2_26 , c1_ . zip AS zip_27 , c1_ . city AS city_28 , c1_ . phone1 AS phone1_29 , c1_ . phone2 AS phone2_30 , c1_ . fax AS fax_31 , c1_ . email1 AS email1_32 , c1_ . email1_online AS email1_online_33 , c1_ . email2_online AS email2_online_34 , c1_ . email2 AS email2_35 , c1_ . url AS url_36 , c1_ . url_ticket AS url_ticket_37 , c1_ . facebook AS facebook_38 , c1_ . twitter AS twitter_39 , c1_ . instagram AS instagram_40 , c1_ . mobile AS mobile_41 , c1_ . geocodable AS geocodable_42 , c1_ . x AS x_43 , c1_ . y AS y_44 , c1_ . idmultimedia AS idmultimedia_45 , c1_ . type_view AS type_view_46 , c1_ . stats_access AS stats_access_47 , c1_ . ga_tracking_id AS ga_tracking_id_48 , c1_ . is_festival AS is_festival_49 , c1_ . link_on_video AS link_on_video_50 , c1_ . is_partenaire AS is_partenaire_51 , c1_ . valid_version AS valid_version_52 , c1_ . other_versions AS other_versions_53 , c1_ . url_redirect AS url_redirect_54 , c1_ . url_clean AS url_clean_55 , c1_ . dateupdate AS dateupdate_56 , c1_ . dateinsert AS dateinsert_57 , c1_ . publish AS publish_58 , c1_ . valid AS valid_59 , s0_ . idspectacle AS idspectacle_60 , s0_ . idcontact AS idcontact_61 , s0_ . idextranetuser AS idextranetuser_62 , c1_ . country AS country_63 , c1_ . idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = 26495 AND s0_ . date > = '2024-04-25' GROUP BY s0_ . idcontact ORDER BY s0_ . date ASC LIMIT 1 ;
Copy
29.01 ms (2.84%)
38
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 10517 ;
Copy
21.80 ms (2.14%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36259 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36259 ORDER BY p . `lastname` ;
Copy
18.60 ms (1.82%)
1
SELECT s . `idspectacle` FROM spectacles s
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 s . `publish` = 1 AND s . `valid` = 1
SELECT s . `idspectacle` FROM spectacles s
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 s . `publish` = 1 AND s . `valid` = 1 ;
Copy
17.84 ms (1.75%)
1
SELECT t . `idtext` FROM texts t
JOIN object_content oc ON oc . `idobject` = t . `idtext`
JOIN contents c ON c . `idcontent` = oc . `idcontent`
JOIN content_classification cc ON cc . `idcontent` = c . `idcontent`
WHERE c . publish = 1
AND oc . object = 'texts'
AND cc . idclassification = 207
AND t . `publish` = 1 AND t . `valid` = 1
SELECT t . `idtext` FROM texts t
JOIN object_content oc ON oc . `idobject` = t . `idtext`
JOIN contents c ON c . `idcontent` = oc . `idcontent`
JOIN content_classification cc ON cc . `idcontent` = c . `idcontent`
WHERE c . publish = 1
AND oc . object = 'texts'
AND cc . idclassification = 207
AND t . `publish` = 1 AND t . `valid` = 1 ;
Copy
17.70 ms (1.73%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33884 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33884 ORDER BY p . `lastname` ;
Copy
17.36 ms (1.70%)
2
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , DATEDIFF ('2024-04-25' , s0_ . date ) AS sclr_2 , ABS (DATEDIFF ('2024-04-25' , s0_ . date )) AS sclr_3 , s0_ . idschedule AS idschedule_4 , s0_ . date AS date_5 , s0_ . hour AS hour_6 , s0_ . is_creation AS is_creation_7 , s0_ . is_cancelled AS is_cancelled_8 , s0_ . idcontact_festival AS idcontact_festival_9 , s0_ . url_spectacle AS url_spectacle_10 , s0_ . url_booking AS url_booking_11 , s0_ . note AS note_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . valid AS valid_16 , c1_ . idcontact AS idcontact_17 , c1_ . type AS type_18 , c1_ . organisation AS organisation_19 , c1_ . nom_suite AS nom_suite_20 , c1_ . lastname AS lastname_21 , c1_ . firstname AS firstname_22 , c1_ . idtypestructure AS idtypestructure_23 , c1_ . license AS license_24 , c1_ . comment AS comment_25 , c1_ . private_comment AS private_comment_26 , c1_ . address1 AS address1_27 , c1_ . address2 AS address2_28 , c1_ . zip AS zip_29 , c1_ . city AS city_30 , c1_ . phone1 AS phone1_31 , c1_ . phone2 AS phone2_32 , c1_ . fax AS fax_33 , c1_ . email1 AS email1_34 , c1_ . email1_online AS email1_online_35 , c1_ . email2_online AS email2_online_36 , c1_ . email2 AS email2_37 , c1_ . url AS url_38 , c1_ . url_ticket AS url_ticket_39 , c1_ . facebook AS facebook_40 , c1_ . twitter AS twitter_41 , c1_ . instagram AS instagram_42 , c1_ . mobile AS mobile_43 , c1_ . geocodable AS geocodable_44 , c1_ . x AS x_45 , c1_ . y AS y_46 , c1_ . idmultimedia AS idmultimedia_47 , c1_ . type_view AS type_view_48 , c1_ . stats_access AS stats_access_49 , c1_ . ga_tracking_id AS ga_tracking_id_50 , c1_ . is_festival AS is_festival_51 , c1_ . link_on_video AS link_on_video_52 , c1_ . is_partenaire AS is_partenaire_53 , c1_ . valid_version AS valid_version_54 , c1_ . other_versions AS other_versions_55 , c1_ . url_redirect AS url_redirect_56 , c1_ . url_clean AS url_clean_57 , c1_ . dateupdate AS dateupdate_58 , c1_ . dateinsert AS dateinsert_59 , c1_ . publish AS publish_60 , c1_ . valid AS valid_61 , s0_ . idspectacle AS idspectacle_62 , s0_ . idcontact AS idcontact_63 , s0_ . idextranetuser AS idextranetuser_64 , c1_ . country AS country_65 , c1_ . idextranetuser AS idextranetuser_66 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = ? GROUP BY s0_ . idcontact ORDER BY sclr_2 ASC , sclr_3 ASC LIMIT 1
SELECT
MIN (s0_ . date ) AS sclr_0 ,
MAX (s0_ . date ) AS sclr_1 ,
DATEDIFF ('2024-04-25' , s0_ . date ) AS sclr_2 ,
ABS (
DATEDIFF ('2024-04-25' , s0_ . date )
) AS sclr_3 ,
s0_ . idschedule AS idschedule_4 ,
s0_ . date AS date_5 ,
s0_ . hour AS hour_6 ,
s0_ . is_creation AS is_creation_7 ,
s0_ . is_cancelled AS is_cancelled_8 ,
s0_ . idcontact_festival AS idcontact_festival_9 ,
s0_ . url_spectacle AS url_spectacle_10 ,
s0_ . url_booking AS url_booking_11 ,
s0_ . note AS note_12 ,
s0_ . dateupdate AS dateupdate_13 ,
s0_ . dateinsert AS dateinsert_14 ,
s0_ . publish AS publish_15 ,
s0_ . valid AS valid_16 ,
c1_ . idcontact AS idcontact_17 ,
c1_ . type AS type_18 ,
c1_ . organisation AS organisation_19 ,
c1_ . nom_suite AS nom_suite_20 ,
c1_ . lastname AS lastname_21 ,
c1_ . firstname AS firstname_22 ,
c1_ . idtypestructure AS idtypestructure_23 ,
c1_ . license AS license_24 ,
c1_ . comment AS comment_25 ,
c1_ . private_comment AS private_comment_26 ,
c1_ . address1 AS address1_27 ,
c1_ . address2 AS address2_28 ,
c1_ . zip AS zip_29 ,
c1_ . city AS city_30 ,
c1_ . phone1 AS phone1_31 ,
c1_ . phone2 AS phone2_32 ,
c1_ . fax AS fax_33 ,
c1_ . email1 AS email1_34 ,
c1_ . email1_online AS email1_online_35 ,
c1_ . email2_online AS email2_online_36 ,
c1_ . email2 AS email2_37 ,
c1_ . url AS url_38 ,
c1_ . url_ticket AS url_ticket_39 ,
c1_ . facebook AS facebook_40 ,
c1_ . twitter AS twitter_41 ,
c1_ . instagram AS instagram_42 ,
c1_ . mobile AS mobile_43 ,
c1_ . geocodable AS geocodable_44 ,
c1_ . x AS x_45 ,
c1_ . y AS y_46 ,
c1_ . idmultimedia AS idmultimedia_47 ,
c1_ . type_view AS type_view_48 ,
c1_ . stats_access AS stats_access_49 ,
c1_ . ga_tracking_id AS ga_tracking_id_50 ,
c1_ . is_festival AS is_festival_51 ,
c1_ . link_on_video AS link_on_video_52 ,
c1_ . is_partenaire AS is_partenaire_53 ,
c1_ . valid_version AS valid_version_54 ,
c1_ . other_versions AS other_versions_55 ,
c1_ . url_redirect AS url_redirect_56 ,
c1_ . url_clean AS url_clean_57 ,
c1_ . dateupdate AS dateupdate_58 ,
c1_ . dateinsert AS dateinsert_59 ,
c1_ . publish AS publish_60 ,
c1_ . valid AS valid_61 ,
s0_ . idspectacle AS idspectacle_62 ,
s0_ . idcontact AS idcontact_63 ,
s0_ . idextranetuser AS idextranetuser_64 ,
c1_ . country AS country_65 ,
c1_ . idextranetuser AS idextranetuser_66
FROM
schedules s0_
LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact
WHERE
s0_ . idspectacle = ?
GROUP BY
s0_ . idcontact
ORDER BY
sclr_2 ASC ,
sclr_3 ASC
LIMIT
1
Copy
SELECT MIN (s0_ . date ) AS sclr_0 , MAX (s0_ . date ) AS sclr_1 , DATEDIFF ('2024-04-25' , s0_ . date ) AS sclr_2 , ABS (DATEDIFF ('2024-04-25' , s0_ . date )) AS sclr_3 , s0_ . idschedule AS idschedule_4 , s0_ . date AS date_5 , s0_ . hour AS hour_6 , s0_ . is_creation AS is_creation_7 , s0_ . is_cancelled AS is_cancelled_8 , s0_ . idcontact_festival AS idcontact_festival_9 , s0_ . url_spectacle AS url_spectacle_10 , s0_ . url_booking AS url_booking_11 , s0_ . note AS note_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . valid AS valid_16 , c1_ . idcontact AS idcontact_17 , c1_ . type AS type_18 , c1_ . organisation AS organisation_19 , c1_ . nom_suite AS nom_suite_20 , c1_ . lastname AS lastname_21 , c1_ . firstname AS firstname_22 , c1_ . idtypestructure AS idtypestructure_23 , c1_ . license AS license_24 , c1_ . comment AS comment_25 , c1_ . private_comment AS private_comment_26 , c1_ . address1 AS address1_27 , c1_ . address2 AS address2_28 , c1_ . zip AS zip_29 , c1_ . city AS city_30 , c1_ . phone1 AS phone1_31 , c1_ . phone2 AS phone2_32 , c1_ . fax AS fax_33 , c1_ . email1 AS email1_34 , c1_ . email1_online AS email1_online_35 , c1_ . email2_online AS email2_online_36 , c1_ . email2 AS email2_37 , c1_ . url AS url_38 , c1_ . url_ticket AS url_ticket_39 , c1_ . facebook AS facebook_40 , c1_ . twitter AS twitter_41 , c1_ . instagram AS instagram_42 , c1_ . mobile AS mobile_43 , c1_ . geocodable AS geocodable_44 , c1_ . x AS x_45 , c1_ . y AS y_46 , c1_ . idmultimedia AS idmultimedia_47 , c1_ . type_view AS type_view_48 , c1_ . stats_access AS stats_access_49 , c1_ . ga_tracking_id AS ga_tracking_id_50 , c1_ . is_festival AS is_festival_51 , c1_ . link_on_video AS link_on_video_52 , c1_ . is_partenaire AS is_partenaire_53 , c1_ . valid_version AS valid_version_54 , c1_ . other_versions AS other_versions_55 , c1_ . url_redirect AS url_redirect_56 , c1_ . url_clean AS url_clean_57 , c1_ . dateupdate AS dateupdate_58 , c1_ . dateinsert AS dateinsert_59 , c1_ . publish AS publish_60 , c1_ . valid AS valid_61 , s0_ . idspectacle AS idspectacle_62 , s0_ . idcontact AS idcontact_63 , s0_ . idextranetuser AS idextranetuser_64 , c1_ . country AS country_65 , c1_ . idextranetuser AS idextranetuser_66 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact WHERE s0_ . idspectacle = 7418 GROUP BY s0_ . idcontact ORDER BY sclr_2 ASC , sclr_3 ASC LIMIT 1 ;
Copy
15.57 ms (1.53%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 492 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 492 AND cl . `idgroupclassification` = 10 ;
Copy
15.11 ms (1.48%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 247 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 247 AND cl . `idgroupclassification` = 10 ;
Copy
15.02 ms (1.47%)
1
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `multimedias`
WHERE 1 AND multimedias . `idmultimedia` IN (1302 , 14167 , 4883 , 4790 ) AND multimedias . `publish` = 1
GROUP BY multimedias . idmultimedia
ORDER BY FIELD (multimedias . `idmultimedia` , 1302 , 14167 , 4883 , 4790 )
LIMIT 0 , 4
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `multimedias`
WHERE 1 AND multimedias . `idmultimedia` IN (1302 , 14167 , 4883 , 4790 ) AND multimedias . `publish` = 1
GROUP BY multimedias . idmultimedia
ORDER BY FIELD (multimedias . `idmultimedia` , 1302 , 14167 , 4883 , 4790 )
LIMIT 0 , 4 ;
Copy
13.30 ms (1.30%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 16939 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 16939 AND cl . `idgroupclassification` = 10 ;
Copy
12.07 ms (1.18%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 28310 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 28310 ORDER BY p . `lastname` ;
Copy
11.49 ms (1.13%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 26682 AND cc . idclassification = 101 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 26682 AND cc . idclassification = 101 LIMIT 1 ;
Copy
10.53 ms (1.03%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '33112'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '33112'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
10.43 ms (1.02%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6173 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6173 AND cl . `idgroupclassification` = 10 ;
Copy
10.15 ms (0.99%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 522 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 522 AND cl . `idgroupclassification` = 10 ;
Copy
9.50 ms (0.93%)
1
SELECT idmultimedia , COUNT (idmultimedia ) as views
FROM statistiques . 20240425_days1 WHERE idmultimedia NOT IN (5126 , 6056 , 11808 , 11863 , 11868 , 11899 , 11895 , 11897 , 11901 , 2024 ) GROUP BY idmultimedia
ORDER BY COUNT (idmultimedia ) DESC
LIMIT 0 , 4
SELECT idmultimedia , COUNT (idmultimedia ) as views
FROM statistiques . 20240425_days1 WHERE idmultimedia NOT IN (5126 , 6056 , 11808 , 11863 , 11868 , 11899 , 11895 , 11897 , 11901 , 2024 ) GROUP BY idmultimedia
ORDER BY COUNT (idmultimedia ) DESC
LIMIT 0 , 4 ;
Copy
9.29 ms (0.91%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 7418 AND cc . idclassification = 6 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 7418 AND cc . idclassification = 6 LIMIT 1 ;
Copy
9.24 ms (0.90%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
9.23 ms (0.90%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6070 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6070 AND cl . `idgroupclassification` = 10 ;
Copy
8.70 ms (0.85%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1073 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1073 AND cl . `idgroupclassification` = 10 ;
Copy
8.28 ms (0.81%)
29
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (? ) LIMIT 1
SELECT t0 . idtypespectacle AS idtypespectacle_1 , t0 . typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0 . idtypespectacle IN (4 ) LIMIT 1 ;
Copy
7.88 ms (0.77%)
1
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcasts . `code_franceinter` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 )
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 1
SELECT DISTINCT (podcasts . idpodcast ), podcasts . *
FROM `podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcasts . `code_franceinter` IS NOT NULL AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 )
GROUP BY podcasts . idpodcast
ORDER BY podcasts . `date_podcast`
DESC
LIMIT 0 , 1 ;
Copy
6.76 ms (0.66%)
1
SELECT ct . idcontact , ct . url_clean , ct . link_on_video , ct . url , ct . organisation , ct . idtypestructure , f . file , tf . titre AS extension
FROM contacts ct , object_file of , files f , classifications cl , file_classification fc , typesfiles tf
WHERE 1
AND of . idobject = ct . idcontact
AND f . idfile = of . idfile
AND f . publish = 1
AND f . idtype = tf . idtype
AND f . idfile = fc . idfile
AND cl . idclassification = fc . idclassification
AND of . object = 'contacts' AND cl . classification = 'class_petit_bandeau' ORDER BY ct . idcontact
SELECT ct . idcontact , ct . url_clean , ct . link_on_video , ct . url , ct . organisation , ct . idtypestructure , f . file , tf . titre AS extension
FROM contacts ct , object_file of , files f , classifications cl , file_classification fc , typesfiles tf
WHERE 1
AND of . idobject = ct . idcontact
AND f . idfile = of . idfile
AND f . publish = 1
AND f . idtype = tf . idtype
AND f . idfile = fc . idfile
AND cl . idclassification = fc . idclassification
AND of . object = 'contacts' AND cl . classification = 'class_petit_bandeau' ORDER BY ct . idcontact ;
Copy
6.15 ms (0.60%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
5.38 ms (0.53%)
1
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 1302 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 1302 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
4.81 ms (0.47%)
8
SELECT m0_ . idmultimedia AS idmultimedia_0 , m0_ . idsupport AS idsupport_1 , m0_ . publish AS publish_2 , m0_ . status AS status_3 , m0_ . policy_access AS policy_access_4 , m0_ . support AS support_5 , m0_ . evenement AS evenement_6 , m0_ . sujet_titre AS sujet_titre_7 , m0_ . language AS language_8 , m0_ . markdown AS markdown_9 , m0_ . duree AS duree_10 , m0_ . date AS date_11 , m0_ . lieu AS lieu_12 , m0_ . particip_comed AS particip_comed_13 , m0_ . description AS description_14 , m0_ . use_cloud AS use_cloud_15 , m0_ . type_streaming AS type_streaming_16 , m0_ . mp3 AS mp3_17 , m0_ . hd2160 AS hd2160_18 , m0_ . hd1080 AS hd1080_19 , m0_ . upload AS upload_20 , m0_ . hd720 AS hd720_21 , m0_ . h264m AS h264m_22 , m0_ . h264 AS h264_23 , m0_ . flv AS flv_24 , m0_ . flv_width AS flv_width_25 , m0_ . flv_height AS flv_height_26 , m0_ . duree_site AS duree_site_27 , m0_ . duree_site_sec AS duree_site_sec_28 , m0_ . audio_video AS audio_video_29 , m0_ . filmeur AS filmeur_30 , m0_ . copyright AS copyright_31 , m0_ . etalab AS etalab_32 , m0_ . mots AS mots_33 , m0_ . tags AS tags_34 , m0_ . quality AS quality_35 , m0_ . url_clean AS url_clean_36 , m0_ . code AS code_37 , m0_ . fichier_local AS fichier_local_38 , m0_ . note_extranet AS note_extranet_39 , m0_ . note_extranetuser AS note_extranetuser_40 , m0_ . video_tete AS video_tete_41 , m0_ . avignondate AS avignondate_42 , m0_ . heywatch AS heywatch_43 , m0_ . is_coconut AS is_coconut_44 , m0_ . price AS price_45 , m0_ . count_view AS count_view_46 , m0_ . dateupdate AS dateupdate_47 , m0_ . dateinsert AS dateinsert_48 , m0_ . traite_comed AS traite_comed_49 , m0_ . traite_format AS traite_format_50 , m0_ . conversion_local AS conversion_local_51 , m0_ . idextranetuser_producteur AS idextranetuser_producteur_52 , m0_ . type AS type_53 , m0_ . idextranetuser AS idextranetuser_54 , m0_ . idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_ . idmultimedia = ?
SELECT
m0_ . idmultimedia AS idmultimedia_0 ,
m0_ . idsupport AS idsupport_1 ,
m0_ . publish AS publish_2 ,
m0_ . status AS status_3 ,
m0_ . policy_access AS policy_access_4 ,
m0_ . support AS support_5 ,
m0_ . evenement AS evenement_6 ,
m0_ . sujet_titre AS sujet_titre_7 ,
m0_ . language AS language_8 ,
m0_ . markdown AS markdown_9 ,
m0_ . duree AS duree_10 ,
m0_ . date AS date_11 ,
m0_ . lieu AS lieu_12 ,
m0_ . particip_comed AS particip_comed_13 ,
m0_ . description AS description_14 ,
m0_ . use_cloud AS use_cloud_15 ,
m0_ . type_streaming AS type_streaming_16 ,
m0_ . mp3 AS mp3_17 ,
m0_ . hd2160 AS hd2160_18 ,
m0_ . hd1080 AS hd1080_19 ,
m0_ . upload AS upload_20 ,
m0_ . hd720 AS hd720_21 ,
m0_ . h264m AS h264m_22 ,
m0_ . h264 AS h264_23 ,
m0_ . flv AS flv_24 ,
m0_ . flv_width AS flv_width_25 ,
m0_ . flv_height AS flv_height_26 ,
m0_ . duree_site AS duree_site_27 ,
m0_ . duree_site_sec AS duree_site_sec_28 ,
m0_ . audio_video AS audio_video_29 ,
m0_ . filmeur AS filmeur_30 ,
m0_ . copyright AS copyright_31 ,
m0_ . etalab AS etalab_32 ,
m0_ . mots AS mots_33 ,
m0_ . tags AS tags_34 ,
m0_ . quality AS quality_35 ,
m0_ . url_clean AS url_clean_36 ,
m0_ . code AS code_37 ,
m0_ . fichier_local AS fichier_local_38 ,
m0_ . note_extranet AS note_extranet_39 ,
m0_ . note_extranetuser AS note_extranetuser_40 ,
m0_ . video_tete AS video_tete_41 ,
m0_ . avignondate AS avignondate_42 ,
m0_ . heywatch AS heywatch_43 ,
m0_ . is_coconut AS is_coconut_44 ,
m0_ . price AS price_45 ,
m0_ . count_view AS count_view_46 ,
m0_ . dateupdate AS dateupdate_47 ,
m0_ . dateinsert AS dateinsert_48 ,
m0_ . traite_comed AS traite_comed_49 ,
m0_ . traite_format AS traite_format_50 ,
m0_ . conversion_local AS conversion_local_51 ,
m0_ . idextranetuser_producteur AS idextranetuser_producteur_52 ,
m0_ . type AS type_53 ,
m0_ . idextranetuser AS idextranetuser_54 ,
m0_ . idcontact_producteur AS idcontact_producteur_55
FROM
multimedias m0_
WHERE
m0_ . idmultimedia = ?
Copy
SELECT m0_ . idmultimedia AS idmultimedia_0 , m0_ . idsupport AS idsupport_1 , m0_ . publish AS publish_2 , m0_ . status AS status_3 , m0_ . policy_access AS policy_access_4 , m0_ . support AS support_5 , m0_ . evenement AS evenement_6 , m0_ . sujet_titre AS sujet_titre_7 , m0_ . language AS language_8 , m0_ . markdown AS markdown_9 , m0_ . duree AS duree_10 , m0_ . date AS date_11 , m0_ . lieu AS lieu_12 , m0_ . particip_comed AS particip_comed_13 , m0_ . description AS description_14 , m0_ . use_cloud AS use_cloud_15 , m0_ . type_streaming AS type_streaming_16 , m0_ . mp3 AS mp3_17 , m0_ . hd2160 AS hd2160_18 , m0_ . hd1080 AS hd1080_19 , m0_ . upload AS upload_20 , m0_ . hd720 AS hd720_21 , m0_ . h264m AS h264m_22 , m0_ . h264 AS h264_23 , m0_ . flv AS flv_24 , m0_ . flv_width AS flv_width_25 , m0_ . flv_height AS flv_height_26 , m0_ . duree_site AS duree_site_27 , m0_ . duree_site_sec AS duree_site_sec_28 , m0_ . audio_video AS audio_video_29 , m0_ . filmeur AS filmeur_30 , m0_ . copyright AS copyright_31 , m0_ . etalab AS etalab_32 , m0_ . mots AS mots_33 , m0_ . tags AS tags_34 , m0_ . quality AS quality_35 , m0_ . url_clean AS url_clean_36 , m0_ . code AS code_37 , m0_ . fichier_local AS fichier_local_38 , m0_ . note_extranet AS note_extranet_39 , m0_ . note_extranetuser AS note_extranetuser_40 , m0_ . video_tete AS video_tete_41 , m0_ . avignondate AS avignondate_42 , m0_ . heywatch AS heywatch_43 , m0_ . is_coconut AS is_coconut_44 , m0_ . price AS price_45 , m0_ . count_view AS count_view_46 , m0_ . dateupdate AS dateupdate_47 , m0_ . dateinsert AS dateinsert_48 , m0_ . traite_comed AS traite_comed_49 , m0_ . traite_format AS traite_format_50 , m0_ . conversion_local AS conversion_local_51 , m0_ . idextranetuser_producteur AS idextranetuser_producteur_52 , m0_ . type AS type_53 , m0_ . idextranetuser AS idextranetuser_54 , m0_ . idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_ . idmultimedia = '1302' ;
Copy
4.56 ms (0.45%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 41 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 41 AND cl . `idgroupclassification` = 10 ;
Copy
3.86 ms (0.38%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 20648 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 20648 AND cl . `idgroupclassification` = 10 ;
Copy
3.62 ms (0.35%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6439 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6439 AND cl . `idgroupclassification` = 10 ;
Copy
3.55 ms (0.35%)
2
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 7418 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 7418 ORDER BY p . `lastname` ;
Copy
3.35 ms (0.33%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 26682
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 26682
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
3.09 ms (0.30%)
2
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33112 ORDER BY p . `lastname` ;
Copy
2.92 ms (0.29%)
2
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 35903
ORDER BY t . title
SELECT t . idtext , t . title , t . type , t . language , t . date , t . url_clean
FROM texts t , text_traduction tt
WHERE t . idtext = tt . idtext
AND tt . idtexttraduction = 35903
ORDER BY t . title ;
Copy
2.81 ms (0.28%)
3
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 = 32842 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 = 32842 ORDER BY j2 . classement ASC ;
Copy
2.71 ms (0.27%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36787 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36787 ORDER BY p . `lastname` ;
Copy
2.66 ms (0.26%)
2
SELECT url_file FROM podcasts WHERE idpodcast = 5008
SELECT url_file FROM podcasts WHERE idpodcast = 5008 ;
Copy
2.65 ms (0.26%)
2
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 26495 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 26495 ORDER BY p . `lastname` ;
Copy
2.55 ms (0.25%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6260 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6260 AND cl . `idgroupclassification` = 10 ;
Copy
2.54 ms (0.25%)
1
SELECT idclassification , classification
FROM classifications
WHERE idgroupclassification = 10 ORDER BY `range`
SELECT idclassification , classification
FROM classifications
WHERE idgroupclassification = 10 ORDER BY `range` ;
Copy
2.39 ms (0.23%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 13952 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 13952 AND cl . `idgroupclassification` = 10 ;
Copy
2.34 ms (0.23%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 30450 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 30450 ORDER BY p . `lastname` ;
Copy
2.19 ms (0.21%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 18268 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 18268 AND cl . `idgroupclassification` = 10 ;
Copy
2.17 ms (0.21%)
2
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 = '25500'
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 = '25500'
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
1.89 ms (0.19%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14152 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14152 AND cl . `idgroupclassification` = 10 ;
Copy
1.82 ms (0.18%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 14676 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 14676 ORDER BY p . `lastname` ;
Copy
1.82 ms (0.18%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.62 ms (0.16%)
1
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 ('14555' ) AND c . `classification` IN ('class_texte_parauteur' , '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 ('14555' ) AND c . `classification` IN ('class_texte_parauteur' , 'class_texte_par_traducteur' );
Copy
1.61 ms (0.16%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 5008
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . persons j1 , theatreok_dev . podcast_person j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idperson = j2 . idperson
AND j3 . idpodcast = 5008 ;
Copy
1.54 ms (0.15%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 20628 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 20628 ORDER BY p . `lastname` ;
Copy
1.49 ms (0.15%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 35852 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 35852 ORDER BY p . `lastname` ;
Copy
1.48 ms (0.15%)
2
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 = 10517 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 = 10517 ORDER BY j2 . classement ASC ;
Copy
1.47 ms (0.14%)
2
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 26682 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 26682 ORDER BY p . `lastname` ;
Copy
1.45 ms (0.14%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.43 ms (0.14%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 30580 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 30580 ORDER BY p . `lastname` ;
Copy
1.41 ms (0.14%)
1
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 (14555 , 25500 , 7480 , 39184 , 45057 , 37597 , 31056 , 21041 , 42207 , 6692 , 21688 , 37819 , 18373 , 45055 , 29197 , 34343 , 32842 , 39940 , 34972 , 22100 , 32626 ) GROUP BY T1 . idtext ORDER BY FIELD (T1 . idtext , 14555 , 25500 , 7480 , 39184 , 45057 , 37597 , 31056 , 21041 , 42207 , 6692 , 21688 , 37819 , 18373 , 45055 , 29197 , 34343 , 32842 , 39940 , 34972 , 22100 , 32626 ) LIMIT 0 , 2
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 (
14555 , 25500 , 7480 , 39184 , 45057 , 37597 ,
31056 , 21041 , 42207 , 6692 , 21688 , 37819 ,
18373 , 45055 , 29197 , 34343 , 32842 ,
39940 , 34972 , 22100 , 32626
)
GROUP BY
T1 . idtext
ORDER BY
FIELD (
T1 . idtext , 14555 , 25500 , 7480 , 39184 ,
45057 , 37597 , 31056 , 21041 , 42207 ,
6692 , 21688 , 37819 , 18373 , 45055 , 29197 ,
34343 , 32842 , 39940 , 34972 , 22100 ,
32626
)
LIMIT
0 , 2
Copy
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 (14555 , 25500 , 7480 , 39184 , 45057 , 37597 , 31056 , 21041 , 42207 , 6692 , 21688 , 37819 , 18373 , 45055 , 29197 , 34343 , 32842 , 39940 , 34972 , 22100 , 32626 ) GROUP BY T1 . idtext ORDER BY FIELD (T1 . idtext , 14555 , 25500 , 7480 , 39184 , 45057 , 37597 , 31056 , 21041 , 42207 , 6692 , 21688 , 37819 , 18373 , 45055 , 29197 , 34343 , 32842 , 39940 , 34972 , 22100 , 32626 ) LIMIT 0 , 2 ;
Copy
1.40 ms (0.14%)
1
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` = 26682 AND d . code_franceinter IS NOT NULL
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` = 26682 AND d . code_franceinter IS NOT NULL ;
Copy
1.39 ms (0.14%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 15716 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 15716 AND cl . `idgroupclassification` = 10 ;
Copy
1.38 ms (0.14%)
6
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 = '225' ;
Copy
1.37 ms (0.13%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31576 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31576 ORDER BY p . `lastname` ;
Copy
1.37 ms (0.13%)
1
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
1.34 ms (0.13%)
2
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 33016 ORDER BY j2 . classement ASC
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 33016 ORDER BY j2 . classement ASC ;
Copy
1.26 ms (0.12%)
1
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 = 45055 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 = 45055 ORDER BY j2 . classement ASC ;
Copy
1.25 ms (0.12%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 16293 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 16293 AND cl . `idgroupclassification` = 10 ;
Copy
1.25 ms (0.12%)
2
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.23 ms (0.12%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 220 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 220 AND cl . `idgroupclassification` = 10 ;
Copy
1.23 ms (0.12%)
2
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `multimedias`
WHERE 1 AND multimedias . `idmultimedia` IN (10027 ) AND multimedias . `publish` = 1
GROUP BY multimedias . idmultimedia
ORDER BY FIELD (multimedias . `idmultimedia` , 10027 )
LIMIT 0 , 10
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `multimedias`
WHERE 1 AND multimedias . `idmultimedia` IN (10027 ) AND multimedias . `publish` = 1
GROUP BY multimedias . idmultimedia
ORDER BY FIELD (multimedias . `idmultimedia` , 10027 )
LIMIT 0 , 10 ;
Copy
1.22 ms (0.12%)
2
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.21 ms (0.12%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 28511 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 28511 ORDER BY p . `lastname` ;
Copy
1.18 ms (0.12%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 6 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 6 LIMIT 1 ;
Copy
1.18 ms (0.12%)
1
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 5008
SELECT j1 . idcontact , j1 . organisation , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . contacts j1 , theatreok_dev . podcast_contact j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idcontact = j2 . idcontact
AND j3 . idpodcast = 5008 ;
Copy
1.17 ms (0.11%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31555 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31555 ORDER BY p . `lastname` ;
Copy
1.16 ms (0.11%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.14 ms (0.11%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 28260 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 28260 ORDER BY p . `lastname` ;
Copy
1.13 ms (0.11%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33933 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33933 ORDER BY p . `lastname` ;
Copy
1.11 ms (0.11%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 25079 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 25079 ORDER BY p . `lastname` ;
Copy
1.09 ms (0.11%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 26682 AND cc . idclassification = 6 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 26682 AND cc . idclassification = 6 LIMIT 1 ;
Copy
1.09 ms (0.11%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31576 AND cc . idclassification = 6 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31576 AND cc . idclassification = 6 LIMIT 1 ;
Copy
1.09 ms (0.11%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '26682'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '26682'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
1.08 ms (0.11%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36925 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36925 ORDER BY p . `lastname` ;
Copy
1.07 ms (0.11%)
1
SELECT COUNT (* )
FROM information_schema . VIEWS
WHERE TABLE_SCHEMA = 'statistiques'
AND TABLE_NAME = '20240425_days1'
SELECT COUNT (* )
FROM information_schema . VIEWS
WHERE TABLE_SCHEMA = 'statistiques'
AND TABLE_NAME = '20240425_days1' ;
Copy
1.07 ms (0.10%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 274 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 274 AND cl . `idgroupclassification` = 10 ;
Copy
1.07 ms (0.10%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 26155 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 26155 ORDER BY p . `lastname` ;
Copy
1.06 ms (0.10%)
1
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 5008
SELECT j1 . idtext , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . texts j1 , theatreok_dev . podcast_text j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idtext = j2 . idtext
AND j3 . idpodcast = 5008 ;
Copy
1.05 ms (0.10%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 12760 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 12760 AND cl . `idgroupclassification` = 10 ;
Copy
1.05 ms (0.10%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36917 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36917 ORDER BY p . `lastname` ;
Copy
1.05 ms (0.10%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 5092 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 5092 ORDER BY p . `lastname` ;
Copy
1.02 ms (0.10%)
1
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` = 31576 AND d . code_franceinter IS NOT NULL
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` = 31576 AND d . code_franceinter IS NOT NULL ;
Copy
1.00 ms (0.10%)
2
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.00 ms (0.10%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 33112
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 33112
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
1.00 ms (0.10%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36677 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36677 ORDER BY p . `lastname` ;
Copy
0.98 ms (0.10%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36918 ORDER BY p . `lastname`
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 36918 ORDER BY p . `lastname` ;
Copy
0.98 ms (0.10%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.96 ms (0.09%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6266 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6266 AND cl . `idgroupclassification` = 10 ;
Copy
0.96 ms (0.09%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 125 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.95 ms (0.09%)
1
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 = 29197 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 = 29197 ORDER BY j2 . classement ASC ;
Copy
0.95 ms (0.09%)
3
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 = 225 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 = 225 ORDER BY j2 . `orderplaylist` ;
Copy
0.93 ms (0.09%)
1
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 = 39213 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 = 39213 ORDER BY j2 . classement ASC ;
Copy
0.93 ms (0.09%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6265 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6265 AND cl . `idgroupclassification` = 10 ;
Copy
0.92 ms (0.09%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 101 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 33112 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.92 ms (0.09%)
6
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 = 25500 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 = 25500 ORDER BY j2 . classement ASC ;
Copy
0.92 ms (0.09%)
2
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.90 ms (0.09%)
1
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 (32842 ) GROUP BY T1 . idtext ORDER BY FIELD (T1 . idtext , 32842 )
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 (32842 ) GROUP BY T1 . idtext ORDER BY FIELD (T1 . idtext , 32842 ) ;
Copy
0.89 ms (0.09%)
1
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 = 21688 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 = 21688 ORDER BY j2 . classement ASC ;
Copy
0.85 ms (0.08%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 26682 AND cc . idclassification = 125 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 26682 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.85 ms (0.08%)
5
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 = 14555 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 = 14555 ORDER BY j2 . classement ASC ;
Copy
0.85 ms (0.08%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.84 ms (0.08%)
1
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.84 ms (0.08%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1896 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1896 AND cl . `idgroupclassification` = 10 ;
Copy
0.84 ms (0.08%)
1
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = ?
SELECT p0_ . idpodcast AS idpodcast_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . title_program AS title_program_3 , p0_ . name_program AS name_program_4 , p0_ . date_podcast AS date_podcast_5 , p0_ . hour_podcast AS hour_podcast_6 , p0_ . code_franceinter AS code_franceinter_7 , p0_ . type_franceinter AS type_franceinter_8 , p0_ . integrate_player AS integrate_player_9 , p0_ . link AS link_10 , p0_ . duration AS duration_11 , p0_ . code_ft AS code_ft_12 , p0_ . is_integrale AS is_integrale_13 , p0_ . type_diffusion AS type_diffusion_14 , p0_ . fin_visionnage_ft AS fin_visionnage_ft_15 , p0_ . date_captation_ft AS date_captation_ft_16 , p0_ . debut_visionnage_ft AS debut_visionnage_ft_17 , p0_ . code_arte AS code_arte_18 , p0_ . code_soundcloud AS code_soundcloud_19 , p0_ . code_spotify AS code_spotify_20 , p0_ . url_file AS url_file_21 , p0_ . url_clean AS url_clean_22 , p0_ . dateupdate AS dateupdate_23 , p0_ . dateinsert AS dateinsert_24 , p0_ . publish AS publish_25 , p0_ . valid AS valid_26 , p0_ . idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_ . idpodcast = '5008' ;
Copy
0.84 ms (0.08%)
1
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 10413
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 10413 ;
Copy
0.83 ms (0.08%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 671 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 671 AND cl . `idgroupclassification` = 10 ;
Copy
0.82 ms (0.08%)
2
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 529 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 529 AND cl . `idgroupclassification` = 10 ;
Copy
0.81 ms (0.08%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 476 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 476 AND cl . `idgroupclassification` = 10 ;
Copy
0.81 ms (0.08%)
2
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 10027 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 10027 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.79 ms (0.08%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 702 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 702 AND cl . `idgroupclassification` = 10 ;
Copy
0.78 ms (0.08%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 230 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 230 AND cl . `idgroupclassification` = 10 ;
Copy
0.78 ms (0.08%)
1
SELECT DISTINCT p . idplaylist
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
WHERE pc . idclassification IN (144 ) AND p . idtext = 14555
GROUP BY p . idtext
SELECT DISTINCT p . idplaylist
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
WHERE pc . idclassification IN (144 ) AND p . idtext = 14555
GROUP BY p . idtext ;
Copy
0.78 ms (0.08%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 7418 AND cc . idclassification = 101 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 7418 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.77 ms (0.08%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.77 ms (0.08%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31576 AND cc . idclassification = 125 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31576 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.77 ms (0.08%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 17092 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 17092 AND cl . `idgroupclassification` = 10 ;
Copy
0.75 ms (0.07%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 212 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 212 AND cl . `idgroupclassification` = 10 ;
Copy
0.75 ms (0.07%)
1
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` = 33112 AND d . code_franceinter IS NOT NULL
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` = 33112 AND d . code_franceinter IS NOT NULL ;
Copy
0.74 ms (0.07%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 483 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 483 AND cl . `idgroupclassification` = 10 ;
Copy
0.74 ms (0.07%)
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` = 14555 AND c . `classification` IN ('class_texte_parauteur' , '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` = 14555 AND c . `classification` IN ('class_texte_parauteur' , 'class_texte_par_traducteur' ) LIMIT 0 , 1 ;
Copy
0.73 ms (0.07%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6138 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6138 AND cl . `idgroupclassification` = 10 ;
Copy
0.71 ms (0.07%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.71 ms (0.07%)
1
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 = 37819 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 = 37819 ORDER BY j2 . classement ASC ;
Copy
0.69 ms (0.07%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 3914 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 3914 AND cl . `idgroupclassification` = 10 ;
Copy
0.69 ms (0.07%)
2
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 8114 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 8114 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.69 ms (0.07%)
1
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 5008
SELECT j1 . idspectacle , j1 . title , j1 . url_clean , j3 . idpodcast FROM theatreok_dev . spectacles j1 , theatreok_dev . podcast_spectacle j2 , theatreok_dev . podcasts j3
WHERE j3 . idpodcast = j2 . idpodcast
AND j1 . idspectacle = j2 . idspectacle
AND j3 . idpodcast = 5008 ;
Copy
0.68 ms (0.07%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 410 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 410 AND cl . `idgroupclassification` = 10 ;
Copy
0.68 ms (0.07%)
2
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.67 ms (0.07%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 7418 AND cc . idclassification = 125 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 7418 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.67 ms (0.07%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1295 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1295 AND cl . `idgroupclassification` = 10 ;
Copy
0.66 ms (0.06%)
2
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.66 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 5613 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 5613 AND cl . `idgroupclassification` = 10 ;
Copy
0.65 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 261 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 261 AND cl . `idgroupclassification` = 10 ;
Copy
0.65 ms (0.06%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 7418
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 7418
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.65 ms (0.06%)
4
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND spectacles = 1 AND lagarce ! = 1 AND is_public IN (1 )
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND spectacles = 1 AND lagarce ! = 1 AND is_public IN (1 ) ;
Copy
0.64 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 305 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 305 AND cl . `idgroupclassification` = 10 ;
Copy
0.64 ms (0.06%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31576'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31576'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.64 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 233 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 233 AND cl . `idgroupclassification` = 10 ;
Copy
0.64 ms (0.06%)
1
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 = 34343 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 = 34343 ORDER BY j2 . classement ASC ;
Copy
0.63 ms (0.06%)
3
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 = 469 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 = 469 ORDER BY j2 . `orderplaylist` ;
Copy
0.63 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 655 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 655 AND cl . `idgroupclassification` = 10 ;
Copy
0.62 ms (0.06%)
3
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 = 225
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 = 225 ;
Copy
0.62 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 586 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 586 AND cl . `idgroupclassification` = 10 ;
Copy
0.62 ms (0.06%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31576 AND cc . idclassification = 101 LIMIT 1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 31576 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.62 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 523 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 523 AND cl . `idgroupclassification` = 10 ;
Copy
0.61 ms (0.06%)
2
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.61 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 495 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 495 AND cl . `idgroupclassification` = 10 ;
Copy
0.61 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1020 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1020 AND cl . `idgroupclassification` = 10 ;
Copy
0.60 ms (0.06%)
2
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.60 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 360 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 360 AND cl . `idgroupclassification` = 10 ;
Copy
0.59 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 18362 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 18362 AND cl . `idgroupclassification` = 10 ;
Copy
0.59 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 2007 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 2007 AND cl . `idgroupclassification` = 10 ;
Copy
0.58 ms (0.06%)
2
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.58 ms (0.06%)
3
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 = 469
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 = 469 ;
Copy
0.58 ms (0.06%)
3
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 = 225
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 = 225 ;
Copy
0.57 ms (0.06%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 484 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 484 AND cl . `idgroupclassification` = 10 ;
Copy
0.56 ms (0.06%)
1
SELECT p . idplaylist
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
WHERE pc . idclassification = 144 AND p . idtext = 14555
GROUP BY p . idtext
SELECT p . idplaylist
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
WHERE pc . idclassification = 144 AND p . idtext = 14555
GROUP BY p . idtext ;
Copy
0.56 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6264 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6264 AND cl . `idgroupclassification` = 10 ;
Copy
0.54 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 12653 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 12653 AND cl . `idgroupclassification` = 10 ;
Copy
0.54 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 2519 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 2519 AND cl . `idgroupclassification` = 10 ;
Copy
0.53 ms (0.05%)
2
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1607 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1607 AND cl . `idgroupclassification` = 10 ;
Copy
0.53 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 15468 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 15468 AND cl . `idgroupclassification` = 10 ;
Copy
0.52 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 384 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 384 AND cl . `idgroupclassification` = 10 ;
Copy
0.52 ms (0.05%)
3
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 = 225
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 = 225 ;
Copy
0.51 ms (0.05%)
1
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 = 22100 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 = 22100 ORDER BY j2 . classement ASC ;
Copy
0.51 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 2089 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 2089 AND cl . `idgroupclassification` = 10 ;
Copy
0.51 ms (0.05%)
2
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `multimedias`
WHERE 1 AND multimedias . `idmultimedia` IN (8114 ) AND multimedias . `publish` = 1
GROUP BY multimedias . idmultimedia
ORDER BY FIELD (multimedias . `idmultimedia` , 8114 )
LIMIT 0 , 10
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `multimedias`
WHERE 1 AND multimedias . `idmultimedia` IN (8114 ) AND multimedias . `publish` = 1
GROUP BY multimedias . idmultimedia
ORDER BY FIELD (multimedias . `idmultimedia` , 8114 )
LIMIT 0 , 10 ;
Copy
0.51 ms (0.05%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '7418'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '7418'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.49 ms (0.05%)
1
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
0.49 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14497 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14497 AND cl . `idgroupclassification` = 10 ;
Copy
0.48 ms (0.05%)
3
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 = 225
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 = 225 ;
Copy
0.48 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6355 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6355 AND cl . `idgroupclassification` = 10 ;
Copy
0.48 ms (0.05%)
2
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.48 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 19914 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 19914 AND cl . `idgroupclassification` = 10 ;
Copy
0.48 ms (0.05%)
3
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 = 469
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 = 469 ;
Copy
0.48 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14456 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14456 AND cl . `idgroupclassification` = 10 ;
Copy
0.48 ms (0.05%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31576
AND om . object = 'spectacles'
AND m . publish = 1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31576
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.48 ms (0.05%)
3
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 = 469
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 = 469 ;
Copy
0.48 ms (0.05%)
2
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.47 ms (0.05%)
2
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.47 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1294 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1294 AND cl . `idgroupclassification` = 10 ;
Copy
0.47 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 399 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 399 AND cl . `idgroupclassification` = 10 ;
Copy
0.47 ms (0.05%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1996 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1996 AND cl . `idgroupclassification` = 10 ;
Copy
0.47 ms (0.05%)
2
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.46 ms (0.05%)
2
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 = 39939 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 = 39939 ORDER BY j2 . classement ASC ;
Copy
0.46 ms (0.04%)
1
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 ('25500' ) AND c . `classification` IN ('class_texte_parauteur' , '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 ('25500' ) AND c . `classification` IN ('class_texte_parauteur' , 'class_texte_par_traducteur' );
Copy
0.46 ms (0.04%)
3
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 = 469
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 = 469 ;
Copy
0.45 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 263 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 263 AND cl . `idgroupclassification` = 10 ;
Copy
0.45 ms (0.04%)
1
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 = 32626 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 = 32626 ORDER BY j2 . classement ASC ;
Copy
0.44 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 591 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 591 AND cl . `idgroupclassification` = 10 ;
Copy
0.43 ms (0.04%)
1
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 = 42207 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 = 42207 ORDER BY j2 . classement ASC ;
Copy
0.43 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1287 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1287 AND cl . `idgroupclassification` = 10 ;
Copy
0.43 ms (0.04%)
3
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 = 225
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 = 225 ;
Copy
0.43 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1004 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1004 AND cl . `idgroupclassification` = 10 ;
Copy
0.43 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 465 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 465 AND cl . `idgroupclassification` = 10 ;
Copy
0.43 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 698 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 698 AND cl . `idgroupclassification` = 10 ;
Copy
0.42 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 971 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 971 AND cl . `idgroupclassification` = 10 ;
Copy
0.42 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14492 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14492 AND cl . `idgroupclassification` = 10 ;
Copy
0.42 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 3208 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 3208 AND cl . `idgroupclassification` = 10 ;
Copy
0.42 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 390 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 390 AND cl . `idgroupclassification` = 10 ;
Copy
0.42 ms (0.04%)
1
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 = 18373 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 = 18373 ORDER BY j2 . classement ASC ;
Copy
0.41 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6322 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 6322 AND cl . `idgroupclassification` = 10 ;
Copy
0.41 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 309 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 309 AND cl . `idgroupclassification` = 10 ;
Copy
0.41 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 16915 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 16915 AND cl . `idgroupclassification` = 10 ;
Copy
0.41 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1223 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1223 AND cl . `idgroupclassification` = 10 ;
Copy
0.41 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1413 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1413 AND cl . `idgroupclassification` = 10 ;
Copy
0.41 ms (0.04%)
2
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.40 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 942 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 942 AND cl . `idgroupclassification` = 10 ;
Copy
0.39 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 3506 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 3506 AND cl . `idgroupclassification` = 10 ;
Copy
0.39 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 453 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 453 AND cl . `idgroupclassification` = 10 ;
Copy
0.39 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 9837 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 9837 AND cl . `idgroupclassification` = 10 ;
Copy
0.39 ms (0.04%)
1
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 = 34972 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 = 34972 ORDER BY j2 . classement ASC ;
Copy
0.39 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 11947 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 11947 AND cl . `idgroupclassification` = 10 ;
Copy
0.38 ms (0.04%)
2
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 = 39940
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 = 39940
ORDER BY t . title ;
Copy
0.38 ms (0.04%)
2
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 8114
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.38 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1297 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1297 AND cl . `idgroupclassification` = 10 ;
Copy
0.38 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 5153 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 5153 AND cl . `idgroupclassification` = 10 ;
Copy
0.38 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1017 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1017 AND cl . `idgroupclassification` = 10 ;
Copy
0.38 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 3247 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 3247 AND cl . `idgroupclassification` = 10 ;
Copy
0.37 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 580 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 580 AND cl . `idgroupclassification` = 10 ;
Copy
0.37 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 4319 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 4319 AND cl . `idgroupclassification` = 10 ;
Copy
0.36 ms (0.04%)
1
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` = 7418 AND d . code_franceinter IS NOT NULL
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` = 7418 AND d . code_franceinter IS NOT NULL ;
Copy
0.36 ms (0.04%)
2
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 10027
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.36 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 726 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 726 AND cl . `idgroupclassification` = 10 ;
Copy
0.36 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 420 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 420 AND cl . `idgroupclassification` = 10 ;
Copy
0.36 ms (0.04%)
3
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 = 469
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 = 469 ;
Copy
0.36 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1779 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1779 AND cl . `idgroupclassification` = 10 ;
Copy
0.36 ms (0.04%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 472 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 472 AND cl . `idgroupclassification` = 10 ;
Copy
0.36 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 8882 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 8882 AND cl . `idgroupclassification` = 10 ;
Copy
0.35 ms (0.03%)
1
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 = 45057
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 = 45057
ORDER BY t . title ;
Copy
0.35 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 380 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 380 AND cl . `idgroupclassification` = 10 ;
Copy
0.34 ms (0.03%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.34 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14298 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 14298 AND cl . `idgroupclassification` = 10 ;
Copy
0.33 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 19416 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 19416 AND cl . `idgroupclassification` = 10 ;
Copy
0.33 ms (0.03%)
1
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 = 21041 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 = 21041 ORDER BY j2 . classement ASC ;
Copy
0.33 ms (0.03%)
1
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 = 6692 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 = 6692 ORDER BY j2 . classement ASC ;
Copy
0.33 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 875 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 875 AND cl . `idgroupclassification` = 10 ;
Copy
0.33 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 595 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 595 AND cl . `idgroupclassification` = 10 ;
Copy
0.33 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 336 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 336 AND cl . `idgroupclassification` = 10 ;
Copy
0.33 ms (0.03%)
1
SELECT DISTINCT p . idplaylist
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
WHERE pc . idclassification IN (144 ) AND p . idtext = 25500
GROUP BY p . idtext
SELECT DISTINCT p . idplaylist
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
WHERE pc . idclassification IN (144 ) AND p . idtext = 25500
GROUP BY p . idtext ;
Copy
0.33 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 411 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 411 AND cl . `idgroupclassification` = 10 ;
Copy
0.32 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1189 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 1189 AND cl . `idgroupclassification` = 10 ;
Copy
0.32 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 765 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 765 AND cl . `idgroupclassification` = 10 ;
Copy
0.32 ms (0.03%)
1
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 5119
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 5119 ;
Copy
0.32 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 19440 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 19440 AND cl . `idgroupclassification` = 10 ;
Copy
0.32 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 778 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 778 AND cl . `idgroupclassification` = 10 ;
Copy
0.32 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 886 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 886 AND cl . `idgroupclassification` = 10 ;
Copy
0.32 ms (0.03%)
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` = 25500 AND c . `classification` IN ('class_texte_parauteur' , '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` = 25500 AND c . `classification` IN ('class_texte_parauteur' , 'class_texte_par_traducteur' ) LIMIT 0 , 1 ;
Copy
0.31 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 11329 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 11329 AND cl . `idgroupclassification` = 10 ;
Copy
0.31 ms (0.03%)
1
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
0.31 ms (0.03%)
1
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 = 31056 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 = 31056 ORDER BY j2 . classement ASC ;
Copy
0.31 ms (0.03%)
1
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 = 8778 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 = 8778 ORDER BY j2 . classement ASC ;
Copy
0.31 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 624 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 624 AND cl . `idgroupclassification` = 10 ;
Copy
0.30 ms (0.03%)
1
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 = 7480 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 = 7480 ORDER BY j2 . classement ASC ;
Copy
0.30 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 638 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 638 AND cl . `idgroupclassification` = 10 ;
Copy
0.29 ms (0.03%)
1
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 877 AND cl . `idgroupclassification` = 10
SELECT cl . * FROM classifications cl
JOIN contact_classification oc ON oc . `idclassification` = cl . `idclassification`
WHERE oc . `idcontact` = 877 AND cl . `idgroupclassification` = 10 ;
Copy
0.28 ms (0.03%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.25 ms (0.02%)
1
SELECT p . idplaylist
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
WHERE pc . idclassification = 144 AND p . idtext = 25500
GROUP BY p . idtext
SELECT p . idplaylist
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
WHERE pc . idclassification = 144 AND p . idtext = 25500
GROUP BY p . idtext ;
Copy
0.19 ms (0.02%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.14 ms (0.01%)
2
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
0.09 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.09 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.08 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.08 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.07 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.07 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.07 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.07 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 4790 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 4790 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.06 ms (0.01%)
1
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 28
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 28 ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 14167 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 14167 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.06 ms (0.01%)
1
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 9007
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 9007 ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 4790
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 4883 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 4883 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.06 ms (0.01%)
1
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 5119
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 5119 ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title , spectacles . url_clean , spectacles . idtypespectacle
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 1302
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . url_clean , contacts . link_on_video
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 14167
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , texts . idtext , texts . title , texts . url_clean , texts . textfictif , texts . valid
FROM object_multimedia , texts
WHERE object_multimedia . idobject = texts . idtext
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 9007
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 9007 ;
Copy
0.06 ms (0.01%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 4883
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.06 ms (0.01%)
1
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 28
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 28 ;
Copy
0.06 ms (0.01%)
1
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 = 39184 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 = 39184 ORDER BY j2 . classement ASC ;
Copy