103.65 ms (26.94%)
1
SELECT COUNT (DISTINCT (ct . `idcontent` ))
FROM schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND cc . `idclassification` = 101 AND (
sc . `idspectacle` IN ('2454' , '4985' , '8665' , '9630' , '10277' , '11668' , '12388' , '12547' , '14518' , '15194' , '16042' , '16074' , '19389' , '19993' , '25563' , '26978' , '30019' , '30580' , '31049' , '31558' , '31835' , '32036' , '32965' , '33010' , '34551' , '34645' , '37165' , '805' , '868' , '924' , '1826' , '2417' , '2074' , '36' , '2972' , '3114' , '3287' , '4380' , '5216' , '4680' , '5295' , '5300' , '4673' , '5561' , '4563' , '3878' , '6721' , '7599' , '8658' , '7582' , '5667' , '5607' , '12259' , '11387' , '13905' , '15012' , '7437' , '13549' , '16021' , '18184' , '25551' , '18645' , '25623' , '29548' , '29669' , '26292' , '30394' , '31898' , '33055' , '30686' , '31096' , '36114' , '36410' , '33370' , '28114' , '37071' )
OR (
sc . `idcontact` = 408 OR sc . `idcontact_festival` = 408
)
)
SELECT
COUNT (
DISTINCT (ct . `idcontent` )
)
FROM
schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE
s . `publish` = 1
AND s . `valid` = 1
AND ct . `publish` = 1
AND ct . `valid` = 1
AND cc . `idclassification` = 101
AND (
sc . `idspectacle` IN (
'2454' , '4985' , '8665' , '9630' , '10277' ,
'11668' , '12388' , '12547' , '14518' ,
'15194' , '16042' , '16074' , '19389' ,
'19993' , '25563' , '26978' , '30019' ,
'30580' , '31049' , '31558' , '31835' ,
'32036' , '32965' , '33010' , '34551' ,
'34645' , '37165' , '805' , '868' , '924' ,
'1826' , '2417' , '2074' , '36' , '2972' ,
'3114' , '3287' , '4380' , '5216' , '4680' ,
'5295' , '5300' , '4673' , '5561' , '4563' ,
'3878' , '6721' , '7599' , '8658' , '7582' ,
'5667' , '5607' , '12259' , '11387' ,
'13905' , '15012' , '7437' , '13549' ,
'16021' , '18184' , '25551' , '18645' ,
'25623' , '29548' , '29669' , '26292' ,
'30394' , '31898' , '33055' , '30686' ,
'31096' , '36114' , '36410' , '33370' ,
'28114' , '37071'
)
OR (
sc . `idcontact` = 408
OR sc . `idcontact_festival` = 408
)
)
Copy
SELECT COUNT (DISTINCT (ct . `idcontent` ))
FROM schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND cc . `idclassification` = 101 AND (
sc . `idspectacle` IN ('2454' , '4985' , '8665' , '9630' , '10277' , '11668' , '12388' , '12547' , '14518' , '15194' , '16042' , '16074' , '19389' , '19993' , '25563' , '26978' , '30019' , '30580' , '31049' , '31558' , '31835' , '32036' , '32965' , '33010' , '34551' , '34645' , '37165' , '805' , '868' , '924' , '1826' , '2417' , '2074' , '36' , '2972' , '3114' , '3287' , '4380' , '5216' , '4680' , '5295' , '5300' , '4673' , '5561' , '4563' , '3878' , '6721' , '7599' , '8658' , '7582' , '5667' , '5607' , '12259' , '11387' , '13905' , '15012' , '7437' , '13549' , '16021' , '18184' , '25551' , '18645' , '25623' , '29548' , '29669' , '26292' , '30394' , '31898' , '33055' , '30686' , '31096' , '36114' , '36410' , '33370' , '28114' , '37071' )
OR (
sc . `idcontact` = 408 OR sc . `idcontact_festival` = 408
)
);
Copy
62.85 ms (16.34%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 408 OR spectacles . `idcontact_production` = 408 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 408 OR spectacles . `idcontact_production` = 408 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 );
Copy
19.30 ms (5.02%)
20
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 < ? AND s0_ . idcontact = ? GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1
Parameters :
[
36410
"2024-04-25 "
408
]
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 < ?
AND s0_ . idcontact = ?
GROUP BY
s0_ . idcontact
ORDER BY
s0_ . date DESC
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 = 36410 AND s0_ . date < '2024-04-25' AND s0_ . idcontact = 408 GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1 ;
Copy
16.06 ms (4.17%)
1
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ LEFT JOIN object_multimedia o9_ ON (s0_ . idspectacle = o9_ . idobject ) LEFT JOIN multimedias m10_ ON (m10_ . idmultimedia = o9_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND o9_ . object = 'spectacles' AND m10_ . publish = 1 AND s1_ . date > = '2024-04-25' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 408 OR s0_ . idcontact_production = 408 )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ LEFT JOIN object_multimedia o9_ ON (s0_ . idspectacle = o9_ . idobject ) LEFT JOIN multimedias m10_ ON (m10_ . idmultimedia = o9_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND o9_ . object = 'spectacles' AND m10_ . publish = 1 AND s1_ . date > = '2024-04-25' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 408 OR s0_ . idcontact_production = 408 )) ORDER BY s1_ . date ASC ;
Copy
12.95 ms (3.37%)
3
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (805 , 868 , 924 , 2454 , 1826 , 2417 , 2074 , 36 , 2972 , 3114 , 3287 , 4380 , 5216 , 4680 , 5295 , 5300 , 4673 , 5561 , 4563 , 3878 , 6721 , 7599 , 8658 , 7582 , 5667 , 5607 , 12259 , 11387 , 13905 , 15012 , 16042 , 7437 , 11668 , 13549 , 16021 , 18184 , 25551 , 18645 , 26978 , 25623 , 29548 , 29669 , 26292 , 30019 , 30394 , 30580 , 31835 , 31898 , 32965 , 33055 , 30686 , 34645 , 31096 , 36114 , 36410 , 33370 , 28114 , 37071 , 37165 , 2454 , 4985 , 8665 , 9630 , 10277 , 11668 , 12388 , 12547 , 14518 , 15194 , 16042 , 16074 , 19389 , 19993 , 25563 , 26978 , 30019 , 30580 , 31049 , 31558 , 31835 , 32036 , 32965 , 33010 , 34551 , 34645 , 37165 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 408
)
)
SELECT
COUNT (
DISTINCT (multimedias . idmultimedia )
)
FROM
multimedias
WHERE
multimedias . `publish` = 1
AND (
multimedias . `idmultimedia` IN (
SELECT
multimedias . `idmultimedia`
FROM
object_multimedia
JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (
805 , 868 , 924 , 2454 , 1826 , 2417 , 2074 ,
36 , 2972 , 3114 , 3287 , 4380 , 5216 , 4680 ,
5295 , 5300 , 4673 , 5561 , 4563 , 3878 ,
6721 , 7599 , 8658 , 7582 , 5667 , 5607 ,
12259 , 11387 , 13905 , 15012 , 16042 ,
7437 , 11668 , 13549 , 16021 , 18184 , 25551 ,
18645 , 26978 , 25623 , 29548 , 29669 ,
26292 , 30019 , 30394 , 30580 , 31835 ,
31898 , 32965 , 33055 , 30686 , 34645 ,
31096 , 36114 , 36410 , 33370 , 28114 ,
37071 , 37165 , 2454 , 4985 , 8665 , 9630 ,
10277 , 11668 , 12388 , 12547 , 14518 ,
15194 , 16042 , 16074 , 19389 , 19993 ,
25563 , 26978 , 30019 , 30580 , 31049 ,
31558 , 31835 , 32036 , 32965 , 33010 ,
34551 , 34645 , 37165
)
)
OR multimedias . `idmultimedia` IN (
SELECT
multimedias . idmultimedia
FROM
object_multimedia
JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 408
)
)
Copy
SELECT COUNT (DISTINCT (multimedias . idmultimedia ))
FROM multimedias
WHERE
multimedias . `publish` = 1
AND (multimedias . `idmultimedia` IN (
SELECT multimedias . `idmultimedia`
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . `object` IN ('contacts' , 'spectacles' )
AND object_multimedia . idobject IN (805 , 868 , 924 , 2454 , 1826 , 2417 , 2074 , 36 , 2972 , 3114 , 3287 , 4380 , 5216 , 4680 , 5295 , 5300 , 4673 , 5561 , 4563 , 3878 , 6721 , 7599 , 8658 , 7582 , 5667 , 5607 , 12259 , 11387 , 13905 , 15012 , 16042 , 7437 , 11668 , 13549 , 16021 , 18184 , 25551 , 18645 , 26978 , 25623 , 29548 , 29669 , 26292 , 30019 , 30394 , 30580 , 31835 , 31898 , 32965 , 33055 , 30686 , 34645 , 31096 , 36114 , 36410 , 33370 , 28114 , 37071 , 37165 , 2454 , 4985 , 8665 , 9630 , 10277 , 11668 , 12388 , 12547 , 14518 , 15194 , 16042 , 16074 , 19389 , 19993 , 25563 , 26978 , 30019 , 30580 , 31049 , 31558 , 31835 , 32036 , 32965 , 33010 , 34551 , 34645 , 37165 )
) OR multimedias . `idmultimedia` IN (
SELECT multimedias . idmultimedia
FROM object_multimedia JOIN multimedias ON object_multimedia . `idmultimedia` = multimedias . `idmultimedia`
AND object_multimedia . object IN ('contacts' )
AND object_multimedia . idobject = 408
)
);
Copy
9.55 ms (2.48%)
1
SELECT COUNT (DISTINCT (spectacles . `idspectacle` )) as total FROM schedules , spectacles JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 408 OR schedules . idcontact_festival = 408 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 )
SELECT COUNT (DISTINCT (spectacles . `idspectacle` )) as total FROM schedules , spectacles JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 408 OR schedules . idcontact_festival = 408 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 ) ;
Copy
9.42 ms (2.45%)
2
SELECT COUNT (DISTINCT (spectacles . `idspectacle` )) as total FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 408 OR spectacles . `idcontact_production` = 408 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 )
SELECT COUNT (DISTINCT (spectacles . `idspectacle` )) as total FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` JOIN object_content ON spectacle_contact . `idspectacle` = object_content . `idobject`
JOIN contents ON contents . `idcontent` = object_content . `idcontent`
JOIN content_classification ON contents . `idcontent` = content_classification . `idcontent` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 408 OR spectacles . `idcontact_production` = 408 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 ) ;
Copy
5.56 ms (1.44%)
1
SELECT DISTINCT MIN (s0_ . date ) AS sclr_0 , t1_ . url_clean AS url_clean_1 , c2_ . idcontact AS idcontact_2 , m3_ . idmultimedia AS idmultimedia_3 , s4_ . idspectacle AS idspectacle_4 , s4_ . title AS title_5 , s4_ . language AS language_6 , s4_ . creation_date AS creation_date_7 , s4_ . url_page AS url_page_8 , s4_ . infos AS infos_9 , s4_ . tag AS tag_10 , s4_ . id_rubrique AS id_rubrique_11 , s4_ . duration AS duration_12 , s4_ . interlude AS interlude_13 , s4_ . textfictif AS textfictif_14 , s4_ . url_redirect AS url_redirect_15 , s4_ . url_clean AS url_clean_16 , s4_ . dateupdate AS dateupdate_17 , s4_ . dateinsert AS dateinsert_18 , s4_ . publish AS publish_19 , s4_ . statut AS statut_20 , s4_ . valid AS valid_21 , t1_ . idtext AS idtext_22 , t1_ . type AS type_23 , t1_ . idtypetext AS idtypetext_24 , t1_ . special_text AS special_text_25 , t1_ . title AS title_26 , t1_ . subtitle AS subtitle_27 , t1_ . date AS date_28 , t1_ . language AS language_29 , t1_ . markdown AS markdown_30 , t1_ . abstract AS abstract_31 , t1_ . abstract_author AS abstract_author_32 , t1_ . abstract_date AS abstract_date_33 , t1_ . abstract_url AS abstract_url_34 , t1_ . publisher_url_text AS publisher_url_text_35 , t1_ . publication_year AS publication_year_36 , t1_ . publication_month AS publication_month_37 , t1_ . isbn AS isbn_38 , t1_ . ean AS ean_39 , t1_ . publishinfos AS publishinfos_40 , t1_ . urltextaccess AS urltextaccess_41 , t1_ . emailtextaccess AS emailtextaccess_42 , t1_ . idfiletextaccess AS idfiletextaccess_43 , t1_ . filetextaccesssave AS filetextaccesssave_44 , t1_ . textaccessmore AS textaccessmore_45 , t1_ . request_translation_text AS request_translation_text_46 , t1_ . request_performing_text AS request_performing_text_47 , t1_ . help_translation AS help_translation_48 , t1_ . help_publishing AS help_publishing_49 , t1_ . help_other AS help_other_50 , t1_ . moreinfo AS moreinfo_51 , t1_ . nmale AS nmale_52 , t1_ . nfemale AS nfemale_53 , t1_ . npeople AS npeople_54 , t1_ . textorder AS textorder_55 , t1_ . nbpages AS nbpages_56 , t1_ . price AS price_57 , t1_ . selection_aneth AS selection_aneth_58 , t1_ . idtext_aneth AS idtext_aneth_59 , t1_ . aide_creation AS aide_creation_60 , t1_ . comments AS comments_61 , t1_ . url_clean AS url_clean_62 , t1_ . textfictif AS textfictif_63 , t1_ . valid_opendata AS valid_opendata_64 , t1_ . dateupdate AS dateupdate_65 , t1_ . dateinsert AS dateinsert_66 , t1_ . publish AS publish_67 , t1_ . statut AS statut_68 , t1_ . valid AS valid_69 , t5_ . idtypespectacle AS idtypespectacle_70 FROM spectacles s4_ LEFT JOIN text_spectacle t6_ ON s4_ . idspectacle = t6_ . idspectacle LEFT JOIN texts t1_ ON t1_ . idtext = t6_ . idtext LEFT JOIN typesspectacles t5_ ON s4_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s0_ ON s4_ . idspectacle = s0_ . idspectacle LEFT JOIN spectacle_person s8_ ON s4_ . idspectacle = s8_ . idspectacle LEFT JOIN persons p7_ ON p7_ . idperson = s8_ . idperson INNER JOIN contacts c2_ ON s0_ . idcontact = c2_ . idcontact LEFT JOIN object_multimedia o9_ ON (s4_ . idspectacle = o9_ . idobject ) LEFT JOIN multimedias m3_ ON (m3_ . idmultimedia = o9_ . idmultimedia ) WHERE s0_ . idspectacle = s4_ . idspectacle AND (s0_ . idcontact = c2_ . idcontact OR s0_ . idcontact_festival = c2_ . idcontact ) AND o9_ . object = 'spectacles' AND m3_ . publish = 1 AND s0_ . idcontact = 408 AND (s4_ . publish = 1 AND s0_ . idcontact = 408 ) GROUP BY s4_ . idspectacle HAVING MAX (s0_ . date ) < '2024-04-25' ORDER BY s0_ . date DESC LIMIT 20
SELECT
DISTINCT MIN (s0_ . date ) AS sclr_0 ,
t1_ . url_clean AS url_clean_1 ,
c2_ . idcontact AS idcontact_2 ,
m3_ . idmultimedia AS idmultimedia_3 ,
s4_ . idspectacle AS idspectacle_4 ,
s4_ . title AS title_5 ,
s4_ . language AS language_6 ,
s4_ . creation_date AS creation_date_7 ,
s4_ . url_page AS url_page_8 ,
s4_ . infos AS infos_9 ,
s4_ . tag AS tag_10 ,
s4_ . id_rubrique AS id_rubrique_11 ,
s4_ . duration AS duration_12 ,
s4_ . interlude AS interlude_13 ,
s4_ . textfictif AS textfictif_14 ,
s4_ . url_redirect AS url_redirect_15 ,
s4_ . url_clean AS url_clean_16 ,
s4_ . dateupdate AS dateupdate_17 ,
s4_ . dateinsert AS dateinsert_18 ,
s4_ . publish AS publish_19 ,
s4_ . statut AS statut_20 ,
s4_ . valid AS valid_21 ,
t1_ . idtext AS idtext_22 ,
t1_ . type AS type_23 ,
t1_ . idtypetext AS idtypetext_24 ,
t1_ . special_text AS special_text_25 ,
t1_ . title AS title_26 ,
t1_ . subtitle AS subtitle_27 ,
t1_ . date AS date_28 ,
t1_ . language AS language_29 ,
t1_ . markdown AS markdown_30 ,
t1_ . abstract AS abstract_31 ,
t1_ . abstract_author AS abstract_author_32 ,
t1_ . abstract_date AS abstract_date_33 ,
t1_ . abstract_url AS abstract_url_34 ,
t1_ . publisher_url_text AS publisher_url_text_35 ,
t1_ . publication_year AS publication_year_36 ,
t1_ . publication_month AS publication_month_37 ,
t1_ . isbn AS isbn_38 ,
t1_ . ean AS ean_39 ,
t1_ . publishinfos AS publishinfos_40 ,
t1_ . urltextaccess AS urltextaccess_41 ,
t1_ . emailtextaccess AS emailtextaccess_42 ,
t1_ . idfiletextaccess AS idfiletextaccess_43 ,
t1_ . filetextaccesssave AS filetextaccesssave_44 ,
t1_ . textaccessmore AS textaccessmore_45 ,
t1_ . request_translation_text AS request_translation_text_46 ,
t1_ . request_performing_text AS request_performing_text_47 ,
t1_ . help_translation AS help_translation_48 ,
t1_ . help_publishing AS help_publishing_49 ,
t1_ . help_other AS help_other_50 ,
t1_ . moreinfo AS moreinfo_51 ,
t1_ . nmale AS nmale_52 ,
t1_ . nfemale AS nfemale_53 ,
t1_ . npeople AS npeople_54 ,
t1_ . textorder AS textorder_55 ,
t1_ . nbpages AS nbpages_56 ,
t1_ . price AS price_57 ,
t1_ . selection_aneth AS selection_aneth_58 ,
t1_ . idtext_aneth AS idtext_aneth_59 ,
t1_ . aide_creation AS aide_creation_60 ,
t1_ . comments AS comments_61 ,
t1_ . url_clean AS url_clean_62 ,
t1_ . textfictif AS textfictif_63 ,
t1_ . valid_opendata AS valid_opendata_64 ,
t1_ . dateupdate AS dateupdate_65 ,
t1_ . dateinsert AS dateinsert_66 ,
t1_ . publish AS publish_67 ,
t1_ . statut AS statut_68 ,
t1_ . valid AS valid_69 ,
t5_ . idtypespectacle AS idtypespectacle_70
FROM
spectacles s4_
LEFT JOIN text_spectacle t6_ ON s4_ . idspectacle = t6_ . idspectacle
LEFT JOIN texts t1_ ON t1_ . idtext = t6_ . idtext
LEFT JOIN typesspectacles t5_ ON s4_ . idtypespectacle = t5_ . idtypespectacle
LEFT JOIN schedules s0_ ON s4_ . idspectacle = s0_ . idspectacle
LEFT JOIN spectacle_person s8_ ON s4_ . idspectacle = s8_ . idspectacle
LEFT JOIN persons p7_ ON p7_ . idperson = s8_ . idperson
INNER JOIN contacts c2_ ON s0_ . idcontact = c2_ . idcontact
LEFT JOIN object_multimedia o9_ ON (s4_ . idspectacle = o9_ . idobject )
LEFT JOIN multimedias m3_ ON (
m3_ . idmultimedia = o9_ . idmultimedia
)
WHERE
s0_ . idspectacle = s4_ . idspectacle
AND (
s0_ . idcontact = c2_ . idcontact
OR s0_ . idcontact_festival = c2_ . idcontact
)
AND o9_ . object = 'spectacles'
AND m3_ . publish = 1
AND s0_ . idcontact = 408
AND (
s4_ . publish = 1
AND s0_ . idcontact = 408
)
GROUP BY
s4_ . idspectacle
HAVING
MAX (s0_ . date ) < '2024-04-25'
ORDER BY
s0_ . date DESC
LIMIT
20
Copy
SELECT DISTINCT MIN (s0_ . date ) AS sclr_0 , t1_ . url_clean AS url_clean_1 , c2_ . idcontact AS idcontact_2 , m3_ . idmultimedia AS idmultimedia_3 , s4_ . idspectacle AS idspectacle_4 , s4_ . title AS title_5 , s4_ . language AS language_6 , s4_ . creation_date AS creation_date_7 , s4_ . url_page AS url_page_8 , s4_ . infos AS infos_9 , s4_ . tag AS tag_10 , s4_ . id_rubrique AS id_rubrique_11 , s4_ . duration AS duration_12 , s4_ . interlude AS interlude_13 , s4_ . textfictif AS textfictif_14 , s4_ . url_redirect AS url_redirect_15 , s4_ . url_clean AS url_clean_16 , s4_ . dateupdate AS dateupdate_17 , s4_ . dateinsert AS dateinsert_18 , s4_ . publish AS publish_19 , s4_ . statut AS statut_20 , s4_ . valid AS valid_21 , t1_ . idtext AS idtext_22 , t1_ . type AS type_23 , t1_ . idtypetext AS idtypetext_24 , t1_ . special_text AS special_text_25 , t1_ . title AS title_26 , t1_ . subtitle AS subtitle_27 , t1_ . date AS date_28 , t1_ . language AS language_29 , t1_ . markdown AS markdown_30 , t1_ . abstract AS abstract_31 , t1_ . abstract_author AS abstract_author_32 , t1_ . abstract_date AS abstract_date_33 , t1_ . abstract_url AS abstract_url_34 , t1_ . publisher_url_text AS publisher_url_text_35 , t1_ . publication_year AS publication_year_36 , t1_ . publication_month AS publication_month_37 , t1_ . isbn AS isbn_38 , t1_ . ean AS ean_39 , t1_ . publishinfos AS publishinfos_40 , t1_ . urltextaccess AS urltextaccess_41 , t1_ . emailtextaccess AS emailtextaccess_42 , t1_ . idfiletextaccess AS idfiletextaccess_43 , t1_ . filetextaccesssave AS filetextaccesssave_44 , t1_ . textaccessmore AS textaccessmore_45 , t1_ . request_translation_text AS request_translation_text_46 , t1_ . request_performing_text AS request_performing_text_47 , t1_ . help_translation AS help_translation_48 , t1_ . help_publishing AS help_publishing_49 , t1_ . help_other AS help_other_50 , t1_ . moreinfo AS moreinfo_51 , t1_ . nmale AS nmale_52 , t1_ . nfemale AS nfemale_53 , t1_ . npeople AS npeople_54 , t1_ . textorder AS textorder_55 , t1_ . nbpages AS nbpages_56 , t1_ . price AS price_57 , t1_ . selection_aneth AS selection_aneth_58 , t1_ . idtext_aneth AS idtext_aneth_59 , t1_ . aide_creation AS aide_creation_60 , t1_ . comments AS comments_61 , t1_ . url_clean AS url_clean_62 , t1_ . textfictif AS textfictif_63 , t1_ . valid_opendata AS valid_opendata_64 , t1_ . dateupdate AS dateupdate_65 , t1_ . dateinsert AS dateinsert_66 , t1_ . publish AS publish_67 , t1_ . statut AS statut_68 , t1_ . valid AS valid_69 , t5_ . idtypespectacle AS idtypespectacle_70 FROM spectacles s4_ LEFT JOIN text_spectacle t6_ ON s4_ . idspectacle = t6_ . idspectacle LEFT JOIN texts t1_ ON t1_ . idtext = t6_ . idtext LEFT JOIN typesspectacles t5_ ON s4_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s0_ ON s4_ . idspectacle = s0_ . idspectacle LEFT JOIN spectacle_person s8_ ON s4_ . idspectacle = s8_ . idspectacle LEFT JOIN persons p7_ ON p7_ . idperson = s8_ . idperson INNER JOIN contacts c2_ ON s0_ . idcontact = c2_ . idcontact LEFT JOIN object_multimedia o9_ ON (s4_ . idspectacle = o9_ . idobject ) LEFT JOIN multimedias m3_ ON (m3_ . idmultimedia = o9_ . idmultimedia ) WHERE s0_ . idspectacle = s4_ . idspectacle AND (s0_ . idcontact = c2_ . idcontact OR s0_ . idcontact_festival = c2_ . idcontact ) AND o9_ . object = 'spectacles' AND m3_ . publish = 1 AND s0_ . idcontact = 408 AND (s4_ . publish = 1 AND s0_ . idcontact = 408 ) GROUP BY s4_ . idspectacle HAVING MAX (s0_ . date ) < '2024-04-25' ORDER BY s0_ . date DESC LIMIT 20 ;
Copy
5.52 ms (1.44%)
1
SELECT sc . `date` , YEAR (sc . `date` ) as annee
FROM schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND (sc . `idcontact` = 408 OR sc . `idcontact_festival` = 408 )
ORDER BY sc . `date`
SELECT sc . `date` , YEAR (sc . `date` ) as annee
FROM schedules sc
JOIN spectacles s ON s . `idspectacle` = sc . `idspectacle`
JOIN object_content oc ON s . `idspectacle` = oc . `idobject`
JOIN contents ct ON oc . `idcontent` = ct . `idcontent`
JOIN content_classification cc ON ct . `idcontent` = cc . `idcontent`
WHERE s . `publish` = 1 AND s . `valid` = 1
AND ct . `publish` = 1 AND ct . `valid` = 1
AND (sc . `idcontact` = 408 OR sc . `idcontact_festival` = 408 )
ORDER BY sc . `date` ;
Copy
4.17 ms (1.08%)
1
SELECT COUNT (DISTINCT (s0_ . idschedule )) AS sclr_0 , MIN (s0_ . date ) AS sclr_1 , c1_ . idcontact AS idcontact_2 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s2_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s0_ ON s2_ . idspectacle = s0_ . idspectacle LEFT JOIN spectacle_person s7_ ON s2_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact LEFT JOIN object_multimedia o8_ ON (s2_ . idspectacle = o8_ . idobject ) LEFT JOIN multimedias m9_ ON (m9_ . idmultimedia = o8_ . idmultimedia ) WHERE s0_ . idspectacle = s2_ . idspectacle AND (s0_ . idcontact = c1_ . idcontact OR s0_ . idcontact_festival = c1_ . idcontact ) AND o8_ . object = 'spectacles' AND m9_ . publish = 1 AND s0_ . idcontact = 408 AND (s2_ . publish = 1 AND s0_ . idcontact = 408 ) ORDER BY s0_ . date DESC
SELECT COUNT (DISTINCT (s0_ . idschedule )) AS sclr_0 , MIN (s0_ . date ) AS sclr_1 , c1_ . idcontact AS idcontact_2 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s2_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s0_ ON s2_ . idspectacle = s0_ . idspectacle LEFT JOIN spectacle_person s7_ ON s2_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c1_ ON s0_ . idcontact = c1_ . idcontact LEFT JOIN object_multimedia o8_ ON (s2_ . idspectacle = o8_ . idobject ) LEFT JOIN multimedias m9_ ON (m9_ . idmultimedia = o8_ . idmultimedia ) WHERE s0_ . idspectacle = s2_ . idspectacle AND (s0_ . idcontact = c1_ . idcontact OR s0_ . idcontact_festival = c1_ . idcontact ) AND o8_ . object = 'spectacles' AND m9_ . publish = 1 AND s0_ . idcontact = 408 AND (s2_ . publish = 1 AND s0_ . idcontact = 408 ) ORDER BY s0_ . date DESC ;
Copy
3.66 ms (0.95%)
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 = 12555
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 = 12555
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
3.36 ms (0.87%)
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 = 12555
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 = 12555
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
3.20 ms (0.83%)
20
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 44683 ;
Copy
2.58 ms (0.67%)
1
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 12555
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 12555
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
2.36 ms (0.61%)
2
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND multimedias . `audio_video` = 2 AND multimedias . `publish` = 1 AND object_multimedia . `object` IN ('contacts' ) AND object_multimedia . `idobject` = 408 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND multimedias . `audio_video` = 2 AND multimedias . `publish` = 1 AND object_multimedia . `object` IN ('contacts' ) AND object_multimedia . `idobject` = 408 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
;
Copy
2.27 ms (0.59%)
2
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/contacts/Centre-Culturel-Boris-Vian-Les-Ulis/videos/type/partenariat "
"200e4b67568ea8491944c759682547d4 "
0
"contacts "
408
0
"fr "
"c1da03f161d358e675fcc180cd506856-dad4 "
"/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829 "
]
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES ('article' , 'thnet' , '/contacts/Centre-Culturel-Boris-Vian-Les-Ulis/videos/type/partenariat' , '200e4b67568ea8491944c759682547d4' , 0 , 'contacts' , 408 , 0 , 'fr' , 'c1da03f161d358e675fcc180cd506856-dad4' , '/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829' );
Copy
2.22 ms (0.58%)
1
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 = '408'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (100 ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '408'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND f . publish = 1 AND ((cl . idclassification IN (100 ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
2.13 ms (0.55%)
1
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 = '408'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND ((cl . classification IN ('class_pp' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile
SELECT *
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '408'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND ((cl . classification IN ('class_pp' ))) AND f . idtype = tf . idtype ORDER BY f . `range` , f . idfile ;
Copy
2.10 ms (0.55%)
4
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 = '15712' ;
Copy
1.96 ms (0.51%)
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 = 12555
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 = 12555
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.95 ms (0.51%)
1
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c2_ ON s1_ . idcontact = c2_ . idcontact LEFT JOIN object_multimedia o8_ ON (s0_ . idspectacle = o8_ . idobject ) LEFT JOIN multimedias m9_ ON (m9_ . idmultimedia = o8_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND o8_ . object = 'spectacles' AND m9_ . publish = 1 AND s1_ . idcontact = 408 AND (s0_ . publish = 1 AND s1_ . idcontact = 408 ) ORDER BY s1_ . date DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 , c2_ . idcontact AS idcontact_2 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_ . idspectacle = t4_ . idspectacle LEFT JOIN texts t3_ ON t3_ . idtext = t4_ . idtext LEFT JOIN typesspectacles t5_ ON s0_ . idtypespectacle = t5_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s7_ ON s0_ . idspectacle = s7_ . idspectacle LEFT JOIN persons p6_ ON p6_ . idperson = s7_ . idperson INNER JOIN contacts c2_ ON s1_ . idcontact = c2_ . idcontact LEFT JOIN object_multimedia o8_ ON (s0_ . idspectacle = o8_ . idobject ) LEFT JOIN multimedias m9_ ON (m9_ . idmultimedia = o8_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c2_ . idcontact OR s1_ . idcontact_festival = c2_ . idcontact ) AND o8_ . object = 'spectacles' AND m9_ . publish = 1 AND s1_ . idcontact = 408 AND (s0_ . publish = 1 AND s1_ . idcontact = 408 ) ORDER BY s1_ . date DESC ;
Copy
1.89 ms (0.49%)
1
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND multimedias . `audio_video` = 2 AND multimedias . `publish` = 1 AND object_multimedia . `object` IN ('contacts' ) AND object_multimedia . `idobject` = 408 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
LIMIT 0 , 20
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . *
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND multimedias . `audio_video` = 2 AND multimedias . `publish` = 1 AND object_multimedia . `object` IN ('contacts' ) AND object_multimedia . `idobject` = 408 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
LIMIT 0 , 20 ;
Copy
1.80 ms (0.47%)
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 = 18184 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 = 18184 ORDER BY p . `lastname` ;
Copy
1.79 ms (0.46%)
20
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
1.77 ms (0.46%)
2
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.71 ms (0.44%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 408 OR schedules . idcontact_festival = 408 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 408 OR schedules . idcontact_festival = 408 );
Copy
1.64 ms (0.43%)
1
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ LEFT JOIN object_multimedia o9_ ON (s0_ . idspectacle = o9_ . idobject ) LEFT JOIN multimedias m10_ ON (m10_ . idmultimedia = o9_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND o9_ . object = 'spectacles' AND m10_ . publish = 1 AND s1_ . idcontact = 408 AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 408 OR s0_ . idcontact_production = 408 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ LEFT JOIN object_multimedia o9_ ON (s0_ . idspectacle = o9_ . idobject ) LEFT JOIN multimedias m10_ ON (m10_ . idmultimedia = o9_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND o9_ . object = 'spectacles' AND m10_ . publish = 1 AND s1_ . idcontact = 408 AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 408 OR s0_ . idcontact_production = 408 )) ORDER BY sclr_1 DESC ;
Copy
1.52 ms (0.39%)
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 = 18645 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 = 18645 ORDER BY p . `lastname` ;
Copy
1.49 ms (0.39%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 408 OR spectacles . `idcontact_production` = 408 ) AND spectacle_contact . `idrole` = 77
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact . `idspectacle` = spectacles . `idspectacle` WHERE spectacles . `publish` = 1 AND (spectacle_contact . `idcontact` = 408 OR spectacles . `idcontact_production` = 408 ) AND spectacle_contact . `idrole` = 77 ;
Copy
1.46 ms (0.38%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 12555
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
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 12555
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.41 ms (0.37%)
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 = 26292 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 = 26292 ORDER BY p . `lastname` ;
Copy
1.27 ms (0.33%)
22
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
1.26 ms (0.33%)
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 = 13549 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 = 13549 ORDER BY p . `lastname` ;
Copy
1.20 ms (0.31%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 30019
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 = 30019
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
1.15 ms (0.30%)
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 = 25623 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 = 25623 ORDER BY p . `lastname` ;
Copy
1.11 ms (0.29%)
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 = 15712
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 = 15712
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.08 ms (0.28%)
1
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (408 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-04-25' AND '2026-04-15' )) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (408 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-04-25' AND '2026-04-15' )) ORDER BY s1_ . date ASC ;
Copy
1.05 ms (0.27%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 26978
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 = 26978
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
1.03 ms (0.27%)
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 = '18184'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '18184'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
1.01 ms (0.26%)
2
SELECT t0 . idstat AS idstat_1 , t0 . type AS type_2 , t0 . module AS module_3 , t0 . url AS url_4 , t0 . idcontent AS idcontent_5 , t0 . object AS object_6 , t0 . idobject AS idobject_7 , t0 . video AS video_8 , t0 . remote_addr AS remote_addr_9 , t0 . lng AS lng_10 , t0 . source AS source_11 , t0 . md5url AS md5url_12 , t0 . dateinsert AS dateinsert_13 FROM stats t0 WHERE t0 . remote_addr = ? AND t0 . idcontent = ? AND t0 . md5url = ?
Parameters :
[
"c1da03f161d358e675fcc180cd506856-dad4 "
0
"200e4b67568ea8491944c759682547d4 "
]
SELECT t0 . idstat AS idstat_1 , t0 . type AS type_2 , t0 . module AS module_3 , t0 . url AS url_4 , t0 . idcontent AS idcontent_5 , t0 . object AS object_6 , t0 . idobject AS idobject_7 , t0 . video AS video_8 , t0 . remote_addr AS remote_addr_9 , t0 . lng AS lng_10 , t0 . source AS source_11 , t0 . md5url AS md5url_12 , t0 . dateinsert AS dateinsert_13 FROM stats t0 WHERE t0 . remote_addr = 'c1da03f161d358e675fcc180cd506856-dad4' AND t0 . idcontent = 0 AND t0 . md5url = '200e4b67568ea8491944c759682547d4' ;
Copy
1.00 ms (0.26%)
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 = '30019'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '30019'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.98 ms (0.26%)
1
SELECT c0_ . idcontact AS idcontact_0 , c0_ . type AS type_1 , c0_ . organisation AS organisation_2 , c0_ . nom_suite AS nom_suite_3 , c0_ . lastname AS lastname_4 , c0_ . firstname AS firstname_5 , c0_ . idtypestructure AS idtypestructure_6 , c0_ . license AS license_7 , c0_ . comment AS comment_8 , c0_ . private_comment AS private_comment_9 , c0_ . address1 AS address1_10 , c0_ . address2 AS address2_11 , c0_ . zip AS zip_12 , c0_ . city AS city_13 , c0_ . phone1 AS phone1_14 , c0_ . phone2 AS phone2_15 , c0_ . fax AS fax_16 , c0_ . email1 AS email1_17 , c0_ . email1_online AS email1_online_18 , c0_ . email2_online AS email2_online_19 , c0_ . email2 AS email2_20 , c0_ . url AS url_21 , c0_ . url_ticket AS url_ticket_22 , c0_ . facebook AS facebook_23 , c0_ . twitter AS twitter_24 , c0_ . instagram AS instagram_25 , c0_ . mobile AS mobile_26 , c0_ . geocodable AS geocodable_27 , c0_ . x AS x_28 , c0_ . y AS y_29 , c0_ . idmultimedia AS idmultimedia_30 , c0_ . type_view AS type_view_31 , c0_ . stats_access AS stats_access_32 , c0_ . ga_tracking_id AS ga_tracking_id_33 , c0_ . is_festival AS is_festival_34 , c0_ . link_on_video AS link_on_video_35 , c0_ . is_partenaire AS is_partenaire_36 , c0_ . valid_version AS valid_version_37 , c0_ . other_versions AS other_versions_38 , c0_ . url_redirect AS url_redirect_39 , c0_ . url_clean AS url_clean_40 , c0_ . dateupdate AS dateupdate_41 , c0_ . dateinsert AS dateinsert_42 , c0_ . publish AS publish_43 , c0_ . valid AS valid_44 , c1_ . id AS id_45 , c1_ . fr AS fr_46 , c1_ . en AS en_47 , c1_ . es AS es_48 , c1_ . pt AS pt_49 , c1_ . de AS de_50 , c1_ . ru AS ru_51 , c1_ . orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_ . country = c1_ . id WHERE c0_ . idcontact = ?
SELECT
c0_ . idcontact AS idcontact_0 ,
c0_ . type AS type_1 ,
c0_ . organisation AS organisation_2 ,
c0_ . nom_suite AS nom_suite_3 ,
c0_ . lastname AS lastname_4 ,
c0_ . firstname AS firstname_5 ,
c0_ . idtypestructure AS idtypestructure_6 ,
c0_ . license AS license_7 ,
c0_ . comment AS comment_8 ,
c0_ . private_comment AS private_comment_9 ,
c0_ . address1 AS address1_10 ,
c0_ . address2 AS address2_11 ,
c0_ . zip AS zip_12 ,
c0_ . city AS city_13 ,
c0_ . phone1 AS phone1_14 ,
c0_ . phone2 AS phone2_15 ,
c0_ . fax AS fax_16 ,
c0_ . email1 AS email1_17 ,
c0_ . email1_online AS email1_online_18 ,
c0_ . email2_online AS email2_online_19 ,
c0_ . email2 AS email2_20 ,
c0_ . url AS url_21 ,
c0_ . url_ticket AS url_ticket_22 ,
c0_ . facebook AS facebook_23 ,
c0_ . twitter AS twitter_24 ,
c0_ . instagram AS instagram_25 ,
c0_ . mobile AS mobile_26 ,
c0_ . geocodable AS geocodable_27 ,
c0_ . x AS x_28 ,
c0_ . y AS y_29 ,
c0_ . idmultimedia AS idmultimedia_30 ,
c0_ . type_view AS type_view_31 ,
c0_ . stats_access AS stats_access_32 ,
c0_ . ga_tracking_id AS ga_tracking_id_33 ,
c0_ . is_festival AS is_festival_34 ,
c0_ . link_on_video AS link_on_video_35 ,
c0_ . is_partenaire AS is_partenaire_36 ,
c0_ . valid_version AS valid_version_37 ,
c0_ . other_versions AS other_versions_38 ,
c0_ . url_redirect AS url_redirect_39 ,
c0_ . url_clean AS url_clean_40 ,
c0_ . dateupdate AS dateupdate_41 ,
c0_ . dateinsert AS dateinsert_42 ,
c0_ . publish AS publish_43 ,
c0_ . valid AS valid_44 ,
c1_ . id AS id_45 ,
c1_ . fr AS fr_46 ,
c1_ . en AS en_47 ,
c1_ . es AS es_48 ,
c1_ . pt AS pt_49 ,
c1_ . de AS de_50 ,
c1_ . ru AS ru_51 ,
c1_ . orderby AS orderby_52
FROM
contacts c0_
LEFT JOIN countries c1_ ON c0_ . country = c1_ . id
WHERE
c0_ . idcontact = ?
Copy
SELECT c0_ . idcontact AS idcontact_0 , c0_ . type AS type_1 , c0_ . organisation AS organisation_2 , c0_ . nom_suite AS nom_suite_3 , c0_ . lastname AS lastname_4 , c0_ . firstname AS firstname_5 , c0_ . idtypestructure AS idtypestructure_6 , c0_ . license AS license_7 , c0_ . comment AS comment_8 , c0_ . private_comment AS private_comment_9 , c0_ . address1 AS address1_10 , c0_ . address2 AS address2_11 , c0_ . zip AS zip_12 , c0_ . city AS city_13 , c0_ . phone1 AS phone1_14 , c0_ . phone2 AS phone2_15 , c0_ . fax AS fax_16 , c0_ . email1 AS email1_17 , c0_ . email1_online AS email1_online_18 , c0_ . email2_online AS email2_online_19 , c0_ . email2 AS email2_20 , c0_ . url AS url_21 , c0_ . url_ticket AS url_ticket_22 , c0_ . facebook AS facebook_23 , c0_ . twitter AS twitter_24 , c0_ . instagram AS instagram_25 , c0_ . mobile AS mobile_26 , c0_ . geocodable AS geocodable_27 , c0_ . x AS x_28 , c0_ . y AS y_29 , c0_ . idmultimedia AS idmultimedia_30 , c0_ . type_view AS type_view_31 , c0_ . stats_access AS stats_access_32 , c0_ . ga_tracking_id AS ga_tracking_id_33 , c0_ . is_festival AS is_festival_34 , c0_ . link_on_video AS link_on_video_35 , c0_ . is_partenaire AS is_partenaire_36 , c0_ . valid_version AS valid_version_37 , c0_ . other_versions AS other_versions_38 , c0_ . url_redirect AS url_redirect_39 , c0_ . url_clean AS url_clean_40 , c0_ . dateupdate AS dateupdate_41 , c0_ . dateinsert AS dateinsert_42 , c0_ . publish AS publish_43 , c0_ . valid AS valid_44 , c1_ . id AS id_45 , c1_ . fr AS fr_46 , c1_ . en AS en_47 , c1_ . es AS es_48 , c1_ . pt AS pt_49 , c1_ . de AS de_50 , c1_ . ru AS ru_51 , c1_ . orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_ . country = c1_ . id WHERE c0_ . idcontact = 408 ;
Copy
0.96 ms (0.25%)
2
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '408'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_presentation_structure' ))) ORDER BY c . `range` , c . idcontent
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '408'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_presentation_structure' ))) ORDER BY c . `range` , c . idcontent ;
Copy
0.94 ms (0.25%)
1
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ LEFT JOIN object_multimedia o9_ ON (s0_ . idspectacle = o9_ . idobject ) LEFT JOIN multimedias m10_ ON (m10_ . idmultimedia = o9_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND o9_ . object = 'spectacles' AND m10_ . publish = 1 AND s1_ . idcontact = 408 AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 408 )) ORDER BY sclr_1 DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact INNER JOIN spectacle_contact s8_ LEFT JOIN object_multimedia o9_ ON (s0_ . idspectacle = o9_ . idobject ) LEFT JOIN multimedias m10_ ON (m10_ . idmultimedia = o9_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND o9_ . object = 'spectacles' AND m10_ . publish = 1 AND s1_ . idcontact = 408 AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 408 )) ORDER BY sclr_1 DESC ;
Copy
0.90 ms (0.23%)
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` = 30019 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` = 30019 AND d . code_franceinter IS NOT NULL ;
Copy
0.90 ms (0.23%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 18184
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 = 18184
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.88 ms (0.23%)
1
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN object_multimedia o8_ ON (s0_ . idspectacle = o8_ . idobject ) LEFT JOIN multimedias m9_ ON (m9_ . idmultimedia = o8_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND o8_ . object = 'spectacles' AND m9_ . publish = 1 AND s1_ . idcontact = 408 AND s1_ . date > = '2024-04-25' AND (s0_ . publish = 1 AND s1_ . idcontact = 408 ) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN object_multimedia o8_ ON (s0_ . idspectacle = o8_ . idobject ) LEFT JOIN multimedias m9_ ON (m9_ . idmultimedia = o8_ . idmultimedia ) WHERE s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND o8_ . object = 'spectacles' AND m9_ . publish = 1 AND s1_ . idcontact = 408 AND s1_ . date > = '2024-04-25' AND (s0_ . publish = 1 AND s1_ . idcontact = 408 ) ORDER BY s1_ . date ASC ;
Copy
0.87 ms (0.23%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 7437
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 = 7437
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.87 ms (0.23%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 11387
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 = 11387
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.86 ms (0.22%)
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 = 30019 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 = 30019 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.86 ms (0.22%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 26292
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 = 26292
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.85 ms (0.22%)
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 = 18184 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 = 18184 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.85 ms (0.22%)
2
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` IN (2454 , 4985 , 8665 , 9630 , 10277 , 11668 , 12388 , 12547 , 14518 , 15194 , 16042 , 16074 , 19389 , 19993 , 25563 , 26978 , 30019 , 30580 , 31049 , 31558 , 31835 , 32036 , 32965 , 33010 , 34551 , 34645 , 37165 , 805 , 868 , 924 , 1826 , 2417 , 2074 , 36 , 2972 , 3114 , 3287 , 4380 , 5216 , 4680 , 5295 , 5300 , 4673 , 5561 , 4563 , 3878 , 6721 , 7599 , 8658 , 7582 , 5667 , 5607 , 12259 , 11387 , 13905 , 15012 , 7437 , 13549 , 16021 , 18184 , 25551 , 18645 , 25623 , 29548 , 29669 , 26292 , 30394 , 31898 , 33055 , 30686 , 31096 , 36114 , 36410 , 33370 , 28114 , 37071 ) AND d . code_franceinter IS NOT NULL
SELECT
COUNT (
DISTINCT (d . `idpodcast` )
) as total
FROM
podcasts d ,
podcast_spectacle do
WHERE
d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast`
AND do . `idspectacle` IN (
2454 , 4985 , 8665 , 9630 , 10277 , 11668 ,
12388 , 12547 , 14518 , 15194 , 16042 ,
16074 , 19389 , 19993 , 25563 , 26978 ,
30019 , 30580 , 31049 , 31558 , 31835 ,
32036 , 32965 , 33010 , 34551 , 34645 ,
37165 , 805 , 868 , 924 , 1826 , 2417 , 2074 ,
36 , 2972 , 3114 , 3287 , 4380 , 5216 , 4680 ,
5295 , 5300 , 4673 , 5561 , 4563 , 3878 ,
6721 , 7599 , 8658 , 7582 , 5667 , 5607 ,
12259 , 11387 , 13905 , 15012 , 7437 , 13549 ,
16021 , 18184 , 25551 , 18645 , 25623 ,
29548 , 29669 , 26292 , 30394 , 31898 ,
33055 , 30686 , 31096 , 36114 , 36410 ,
33370 , 28114 , 37071
)
AND d . code_franceinter IS NOT NULL
Copy
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` IN (2454 , 4985 , 8665 , 9630 , 10277 , 11668 , 12388 , 12547 , 14518 , 15194 , 16042 , 16074 , 19389 , 19993 , 25563 , 26978 , 30019 , 30580 , 31049 , 31558 , 31835 , 32036 , 32965 , 33010 , 34551 , 34645 , 37165 , 805 , 868 , 924 , 1826 , 2417 , 2074 , 36 , 2972 , 3114 , 3287 , 4380 , 5216 , 4680 , 5295 , 5300 , 4673 , 5561 , 4563 , 3878 , 6721 , 7599 , 8658 , 7582 , 5667 , 5607 , 12259 , 11387 , 13905 , 15012 , 7437 , 13549 , 16021 , 18184 , 25551 , 18645 , 25623 , 29548 , 29669 , 26292 , 30394 , 31898 , 33055 , 30686 , 31096 , 36114 , 36410 , 33370 , 28114 , 37071 ) AND d . code_franceinter IS NOT NULL ;
Copy
0.85 ms (0.22%)
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 = 18184 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 = 18184 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.84 ms (0.22%)
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 = '26978'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '26978'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.83 ms (0.22%)
2
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '408'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent
SELECT *
FROM object_content oc ,
contents c ,
content_classification cc ,
classifications cl
WHERE oc . idcontent = c . idcontent
AND c . idcontent = cc . idcontent
AND oc . idobject = '408'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent ;
Copy
0.82 ms (0.21%)
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 = '11387'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '11387'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.82 ms (0.21%)
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 = '7437'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '7437'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.82 ms (0.21%)
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 = 18184 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 = 18184 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.80 ms (0.21%)
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 = 11387 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 = 11387 ORDER BY p . `lastname` ;
Copy
0.79 ms (0.20%)
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 = 30019 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 = 30019 ORDER BY p . `lastname` ;
Copy
0.77 ms (0.20%)
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 = 36410 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 = 36410 ORDER BY p . `lastname` ;
Copy
0.77 ms (0.20%)
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 = 7437 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 = 7437 ORDER BY p . `lastname` ;
Copy
0.77 ms (0.20%)
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 = 7437 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 = 7437 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.76 ms (0.20%)
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 = 11387 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 = 11387 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.74 ms (0.19%)
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 = 11387 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 = 11387 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.74 ms (0.19%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 36410
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 = 36410
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.73 ms (0.19%)
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 = 7437 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 = 7437 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.73 ms (0.19%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 408
AND om . object = 'contacts'
AND m . publish = 1 AND m . audio_video = 2
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 408
AND om . object = 'contacts'
AND m . publish = 1 AND m . audio_video = 2 ;
Copy
0.72 ms (0.19%)
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 = 33055 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 = 33055 ORDER BY p . `lastname` ;
Copy
0.71 ms (0.18%)
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 = 7437 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 = 7437 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.71 ms (0.18%)
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 = 11387 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 = 11387 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.71 ms (0.18%)
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` = 18184 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` = 18184 AND d . code_franceinter IS NOT NULL ;
Copy
0.70 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 = 26978 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 = 26978 ORDER BY p . `lastname` ;
Copy
0.69 ms (0.18%)
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 = 13549 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 = 13549 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.69 ms (0.18%)
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 = 30019 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 = 30019 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.69 ms (0.18%)
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 = 26978 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 = 26978 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.68 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 = 31898 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 = 31898 ORDER BY p . `lastname` ;
Copy
0.67 ms (0.17%)
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 = 33370 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 = 33370 ORDER BY p . `lastname` ;
Copy
0.66 ms (0.17%)
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 = 26978 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 = 26978 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.65 ms (0.17%)
1
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (408 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-04-25' ORDER BY s1_ . date DESC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (408 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-04-25' ORDER BY s1_ . date DESC ;
Copy
0.65 ms (0.17%)
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 = 23211 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 = 23211 ORDER BY j2 . classement ASC ;
Copy
0.64 ms (0.17%)
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 = 30394 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 = 30394 ORDER BY p . `lastname` ;
Copy
0.64 ms (0.17%)
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 = 12555
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 = 12555
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.63 ms (0.16%)
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 = 30686 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 = 30686 ORDER BY p . `lastname` ;
Copy
0.63 ms (0.16%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j2 . idoffice , j2 . date_start , j2 . date_end , j3 . idcontact FROM theatreok_dev . persons j1 , theatreok_dev . contact_person j2 , theatreok_dev . contacts j3
WHERE j3 . idcontact = j2 . idcontact
AND j1 . idperson = j2 . idperson
AND j3 . idcontact = 408 AND j2 . idoffice = 1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j2 . idoffice , j2 . date_start , j2 . date_end , j3 . idcontact FROM theatreok_dev . persons j1 , theatreok_dev . contact_person j2 , theatreok_dev . contacts j3
WHERE j3 . idcontact = j2 . idcontact
AND j1 . idperson = j2 . idperson
AND j3 . idcontact = 408 AND j2 . idoffice = 1 ;
Copy
0.57 ms (0.15%)
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 = 30019 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 = 30019 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.57 ms (0.15%)
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 = 15712
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 = 15712
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.57 ms (0.15%)
1
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . `date` , YEAR (multimedias . `date` ) as annee
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND multimedias . `audio_video` = 2 AND multimedias . `publish` = 1 AND object_multimedia . `object` IN ('contacts' ) AND object_multimedia . `idobject` = 408 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
SELECT DISTINCT (multimedias . idmultimedia ), multimedias . `date` , YEAR (multimedias . `date` ) as annee
FROM `object_multimedia` ,
`multimedias`
WHERE 1 AND multimedias . `audio_video` = 2 AND multimedias . `publish` = 1 AND object_multimedia . `object` IN ('contacts' ) AND object_multimedia . `idobject` = 408 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
;
Copy
0.57 ms (0.15%)
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 = '13549'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '13549'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.57 ms (0.15%)
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 = 15712
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 = 15712
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.56 ms (0.15%)
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 = 26978 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 = 26978 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.56 ms (0.14%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 13549
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 = 13549
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.55 ms (0.14%)
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 = '26292'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '26292'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.54 ms (0.14%)
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 = '18645'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '18645'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.53 ms (0.14%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 18645
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 = 18645
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.52 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` = 26978 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` = 26978 AND d . code_franceinter IS NOT NULL ;
Copy
0.49 ms (0.13%)
1
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (408 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC
SELECT COUNT (DISTINCT (s0_ . idspectacle )) AS sclr_0 , MIN (s1_ . date ) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_ . idspectacle = t3_ . idspectacle LEFT JOIN texts t2_ ON t2_ . idtext = t3_ . idtext LEFT JOIN typesspectacles t4_ ON s0_ . idtypespectacle = t4_ . idtypespectacle LEFT JOIN schedules s1_ ON s0_ . idspectacle = s1_ . idspectacle LEFT JOIN spectacle_person s6_ ON s0_ . idspectacle = s6_ . idspectacle LEFT JOIN persons p5_ ON p5_ . idperson = s6_ . idperson INNER JOIN contacts c7_ ON s1_ . idcontact = c7_ . idcontact LEFT JOIN text_aide t8_ ON t2_ . idtext = t8_ . idtext INNER JOIN aides a9_ ON t8_ . idaide = a9_ . idaide WHERE s0_ . textfictif = 0 AND a9_ . idcontact IN (408 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC ;
Copy
0.48 ms (0.13%)
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` = 7437 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` = 7437 AND d . code_franceinter IS NOT NULL ;
Copy
0.48 ms (0.13%)
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` = 11387 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` = 11387 AND d . code_franceinter IS NOT NULL ;
Copy
0.48 ms (0.12%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . lastname , contacts . firstname
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 12555
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 . lastname , contacts . firstname
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 12555
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.48 ms (0.12%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . lastname , contacts . firstname
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 15712
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 . lastname , contacts . firstname
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 15712
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.48 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 = 13549 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 = 13549 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.47 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 = 13549 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 = 13549 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.46 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 = 32780 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 = 32780 ORDER BY j2 . classement ASC ;
Copy
0.46 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 = 18645 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 = 18645 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.45 ms (0.12%)
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 = '25623'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '25623'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.44 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 = 31871 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 = 31871 ORDER BY j2 . classement ASC ;
Copy
0.44 ms (0.11%)
1
SELECT idcontact FROM contacts WHERE url_clean = 'Centre-Culturel-Boris-Vian-Les-Ulis'
SELECT idcontact FROM contacts WHERE url_clean = 'Centre-Culturel-Boris-Vian-Les-Ulis' ;
Copy
0.44 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 = 18645 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 = 18645 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.44 ms (0.11%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 25623
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 = 25623
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.43 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 = 26292 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 = 26292 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.43 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 = '16021'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '16021'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.43 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 = 18645 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 = 18645 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.41 ms (0.11%)
1
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 15712 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` = 15712 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.40 ms (0.10%)
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 = 26292 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 = 26292 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.40 ms (0.10%)
2
SELECT COUNT (DISTINCT (T1 . idnew )) as total FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 408 ) AND T1 . publish = 1
SELECT COUNT (DISTINCT (T1 . idnew )) as total FROM news T1 INNER JOIN newschedules T3
ON T3 . idnew = T1 . idnew
INNER JOIN extranetusers T2 ON T2 . idextranetuser = T1 . idextranetuser
LEFT JOIN contacts T4 ON T4 . idcontact = T3 . idcontact LEFT JOIN new_contact T5 ON T5 . idnew = T1 . idnew WHERE 1 AND (T5 . idcontact = 408 ) AND T1 . publish = 1 ;
Copy
0.39 ms (0.10%)
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 = 26292 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 = 26292 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.38 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 = 15712
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 = 15712
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.38 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 = 15712
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 = 15712
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.38 ms (0.10%)
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 = 17344 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 = 17344 ORDER BY j2 . classement ASC ;
Copy
0.38 ms (0.10%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 408
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 408 ;
Copy
0.37 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 = 15712
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 = 15712
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.36 ms (0.09%)
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 = 15712
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 = 15712
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.36 ms (0.09%)
2
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 = '408'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (112 , 168 , 33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '408'
AND of . object = 'contacts'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (112 , 168 , 33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.34 ms (0.09%)
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 = 15712
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 = 15712
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.34 ms (0.09%)
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` = 26292 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` = 26292 AND d . code_franceinter IS NOT NULL ;
Copy
0.34 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 = 25623 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 = 25623 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.34 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 = 25623 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 = 25623 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.33 ms (0.09%)
2
SELECT COUNT (p . idplaylist )
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
LEFT JOIN aides a ON a . idcontact = 408
LEFT JOIN text_aide ta ON a . `idaide` = ta . `idaide`
WHERE 1 AND a . `publish` = 1 AND a . `type_aide` IN (2 , 3 ) AND pc . idclassification = 144 AND p . idtext = ta . idtext
GROUP BY p . idtext
SELECT COUNT (p . idplaylist )
FROM playlists p
LEFT JOIN playlist_classification pc ON p . idplaylist = pc . idplaylist
LEFT JOIN aides a ON a . idcontact = 408
LEFT JOIN text_aide ta ON a . `idaide` = ta . `idaide`
WHERE 1 AND a . `publish` = 1 AND a . `type_aide` IN (2 , 3 ) AND pc . idclassification = 144 AND p . idtext = ta . idtext
GROUP BY p . idtext ;
Copy
0.31 ms (0.08%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 33055
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 = 33055
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.31 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 = 16021 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 = 16021 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.31 ms (0.08%)
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 = '33055'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '33055'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.31 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 = 25623 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 = 25623 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.31 ms (0.08%)
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 = '31898'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31898'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.31 ms (0.08%)
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` = 13549 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` = 13549 AND d . code_franceinter IS NOT NULL ;
Copy
0.31 ms (0.08%)
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 = 33055 AND r . type_creator = 1 ORDER BY sp . `classement`
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 = 33055 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
0.31 ms (0.08%)
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 = '30686'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '30686'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.31 ms (0.08%)
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 = '30580'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '30580'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.31 ms (0.08%)
2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 4
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 4 ;
Copy
0.30 ms (0.08%)
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 = '33370'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '33370'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.30 ms (0.08%)
2
SELECT COUNT (DISTINCT (dvds . iddvd )) as total
FROM `dvds` ,
`dvd_spectacle`
WHERE 1 AND dvds . `publish` = 1 AND dvd_spectacle . `idspectacle` IN (2454 , 4985 , 8665 , 9630 , 10277 , 11668 , 12388 , 12547 , 14518 , 15194 , 16042 , 16074 , 19389 , 19993 , 25563 , 26978 , 30019 , 30580 , 31049 , 31558 , 31835 , 32036 , 32965 , 33010 , 34551 , 34645 , 37165 ) AND dvds . `iddvd` = dvd_spectacle . `iddvd`
SELECT COUNT (DISTINCT (dvds . iddvd )) as total
FROM `dvds` ,
`dvd_spectacle`
WHERE 1 AND dvds . `publish` = 1 AND dvd_spectacle . `idspectacle` IN (2454 , 4985 , 8665 , 9630 , 10277 , 11668 , 12388 , 12547 , 14518 , 15194 , 16042 , 16074 , 19389 , 19993 , 25563 , 26978 , 30019 , 30580 , 31049 , 31558 , 31835 , 32036 , 32965 , 33010 , 34551 , 34645 , 37165 ) AND dvds . `iddvd` = dvd_spectacle . `iddvd`
;
Copy
0.29 ms (0.08%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 30580
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 = 30580
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.29 ms (0.08%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 15712
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
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 15712
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.29 ms (0.08%)
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 = '36410'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '36410'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.29 ms (0.08%)
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` = 33370 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` = 33370 AND d . code_franceinter IS NOT NULL ;
Copy
0.29 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 = 12555
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 = 12555
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.29 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` = 18645 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` = 18645 AND d . code_franceinter IS NOT NULL ;
Copy
0.28 ms (0.07%)
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 = 21372 AND r . type_creator = 1 ORDER BY sp . `classement`
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 = 21372 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
0.28 ms (0.07%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 33370
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 = 33370
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.28 ms (0.07%)
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 = '30394'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '30394'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.28 ms (0.07%)
2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 3
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 3 ;
Copy
0.28 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 = 31898 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 = 31898 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.28 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` = 25623 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` = 25623 AND d . code_franceinter IS NOT NULL ;
Copy
0.27 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 = 13973 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 = 13973 ORDER BY j2 . classement ASC ;
Copy
0.27 ms (0.07%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31898
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 = 31898
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.27 ms (0.07%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 16021
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 = 16021
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.27 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 = 16021 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 = 16021 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.27 ms (0.07%)
1
SELECT DISTINCT (p . `idperson` ), p . `lastname` , p . `firstname` , p . `url_clean`
FROM persons p
JOIN text_author ta ON ta . `idperson` = p . `idperson`
JOIN text_spectacle ts ON ts . `idtext` = ta . `idtext`
WHERE ts . `idspectacle` = 26978
SELECT DISTINCT (p . `idperson` ), p . `lastname` , p . `firstname` , p . `url_clean`
FROM persons p
JOIN text_author ta ON ta . `idperson` = p . `idperson`
JOIN text_spectacle ts ON ts . `idtext` = ta . `idtext`
WHERE ts . `idspectacle` = 26978 ;
Copy
0.27 ms (0.07%)
1
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 408 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `debut_visionnage_ft` < = '2024-04-25' AND podcasts . `fin_visionnage_ft` > '2024-04-25' AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `is_integrale` = 1 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 408 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `debut_visionnage_ft` < = '2024-04-25' AND podcasts . `fin_visionnage_ft` > '2024-04-25' AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `is_integrale` = 1 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
;
Copy
0.27 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 = 30686 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 = 30686 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.27 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 = 30686 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 = 30686 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.26 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` = 16021 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` = 16021 AND d . code_franceinter IS NOT NULL ;
Copy
0.26 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 = 16021 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 = 16021 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.25 ms (0.07%)
2
SELECT count (p0_ . idpodcast ) AS sclr_0 FROM podcasts p0_ INNER JOIN podcast_contact p2_ ON p0_ . idpodcast = p2_ . idpodcast INNER JOIN contacts c1_ ON c1_ . idcontact = p2_ . idcontact WHERE c1_ . idcontact = ?
SELECT count (p0_ . idpodcast ) AS sclr_0 FROM podcasts p0_ INNER JOIN podcast_contact p2_ ON p0_ . idpodcast = p2_ . idpodcast INNER JOIN contacts c1_ ON c1_ . idcontact = p2_ . idcontact WHERE c1_ . idcontact = 408 ;
Copy
0.25 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 = 33370 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 = 33370 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.25 ms (0.06%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . lastname , contacts . firstname
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 12555
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 . lastname , contacts . firstname
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 12555
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.24 ms (0.06%)
1
SELECT t0 . idcontact AS idcontact_1 , t0 . type AS type_2 , t0 . organisation AS organisation_3 , t0 . nom_suite AS nom_suite_4 , t0 . lastname AS lastname_5 , t0 . firstname AS firstname_6 , t0 . idtypestructure AS idtypestructure_7 , t0 . license AS license_8 , t0 . comment AS comment_9 , t0 . private_comment AS private_comment_10 , t0 . address1 AS address1_11 , t0 . address2 AS address2_12 , t0 . zip AS zip_13 , t0 . city AS city_14 , t0 . phone1 AS phone1_15 , t0 . phone2 AS phone2_16 , t0 . fax AS fax_17 , t0 . email1 AS email1_18 , t0 . email1_online AS email1_online_19 , t0 . email2_online AS email2_online_20 , t0 . email2 AS email2_21 , t0 . url AS url_22 , t0 . url_ticket AS url_ticket_23 , t0 . facebook AS facebook_24 , t0 . twitter AS twitter_25 , t0 . instagram AS instagram_26 , t0 . mobile AS mobile_27 , t0 . geocodable AS geocodable_28 , t0 . x AS x_29 , t0 . y AS y_30 , t0 . idmultimedia AS idmultimedia_31 , t0 . type_view AS type_view_32 , t0 . stats_access AS stats_access_33 , t0 . ga_tracking_id AS ga_tracking_id_34 , t0 . is_festival AS is_festival_35 , t0 . link_on_video AS link_on_video_36 , t0 . is_partenaire AS is_partenaire_37 , t0 . valid_version AS valid_version_38 , t0 . other_versions AS other_versions_39 , t0 . url_redirect AS url_redirect_40 , t0 . url_clean AS url_clean_41 , t0 . dateupdate AS dateupdate_42 , t0 . dateinsert AS dateinsert_43 , t0 . publish AS publish_44 , t0 . valid AS valid_45 , t0 . country AS country_46 , t0 . idextranetuser AS idextranetuser_47 FROM contacts t0 WHERE t0 . idcontact = ?
SELECT
t0 . idcontact AS idcontact_1 ,
t0 . type AS type_2 ,
t0 . organisation AS organisation_3 ,
t0 . nom_suite AS nom_suite_4 ,
t0 . lastname AS lastname_5 ,
t0 . firstname AS firstname_6 ,
t0 . idtypestructure AS idtypestructure_7 ,
t0 . license AS license_8 ,
t0 . comment AS comment_9 ,
t0 . private_comment AS private_comment_10 ,
t0 . address1 AS address1_11 ,
t0 . address2 AS address2_12 ,
t0 . zip AS zip_13 ,
t0 . city AS city_14 ,
t0 . phone1 AS phone1_15 ,
t0 . phone2 AS phone2_16 ,
t0 . fax AS fax_17 ,
t0 . email1 AS email1_18 ,
t0 . email1_online AS email1_online_19 ,
t0 . email2_online AS email2_online_20 ,
t0 . email2 AS email2_21 ,
t0 . url AS url_22 ,
t0 . url_ticket AS url_ticket_23 ,
t0 . facebook AS facebook_24 ,
t0 . twitter AS twitter_25 ,
t0 . instagram AS instagram_26 ,
t0 . mobile AS mobile_27 ,
t0 . geocodable AS geocodable_28 ,
t0 . x AS x_29 ,
t0 . y AS y_30 ,
t0 . idmultimedia AS idmultimedia_31 ,
t0 . type_view AS type_view_32 ,
t0 . stats_access AS stats_access_33 ,
t0 . ga_tracking_id AS ga_tracking_id_34 ,
t0 . is_festival AS is_festival_35 ,
t0 . link_on_video AS link_on_video_36 ,
t0 . is_partenaire AS is_partenaire_37 ,
t0 . valid_version AS valid_version_38 ,
t0 . other_versions AS other_versions_39 ,
t0 . url_redirect AS url_redirect_40 ,
t0 . url_clean AS url_clean_41 ,
t0 . dateupdate AS dateupdate_42 ,
t0 . dateinsert AS dateinsert_43 ,
t0 . publish AS publish_44 ,
t0 . valid AS valid_45 ,
t0 . country AS country_46 ,
t0 . idextranetuser AS idextranetuser_47
FROM
contacts t0
WHERE
t0 . idcontact = ?
Copy
SELECT t0 . idcontact AS idcontact_1 , t0 . type AS type_2 , t0 . organisation AS organisation_3 , t0 . nom_suite AS nom_suite_4 , t0 . lastname AS lastname_5 , t0 . firstname AS firstname_6 , t0 . idtypestructure AS idtypestructure_7 , t0 . license AS license_8 , t0 . comment AS comment_9 , t0 . private_comment AS private_comment_10 , t0 . address1 AS address1_11 , t0 . address2 AS address2_12 , t0 . zip AS zip_13 , t0 . city AS city_14 , t0 . phone1 AS phone1_15 , t0 . phone2 AS phone2_16 , t0 . fax AS fax_17 , t0 . email1 AS email1_18 , t0 . email1_online AS email1_online_19 , t0 . email2_online AS email2_online_20 , t0 . email2 AS email2_21 , t0 . url AS url_22 , t0 . url_ticket AS url_ticket_23 , t0 . facebook AS facebook_24 , t0 . twitter AS twitter_25 , t0 . instagram AS instagram_26 , t0 . mobile AS mobile_27 , t0 . geocodable AS geocodable_28 , t0 . x AS x_29 , t0 . y AS y_30 , t0 . idmultimedia AS idmultimedia_31 , t0 . type_view AS type_view_32 , t0 . stats_access AS stats_access_33 , t0 . ga_tracking_id AS ga_tracking_id_34 , t0 . is_festival AS is_festival_35 , t0 . link_on_video AS link_on_video_36 , t0 . is_partenaire AS is_partenaire_37 , t0 . valid_version AS valid_version_38 , t0 . other_versions AS other_versions_39 , t0 . url_redirect AS url_redirect_40 , t0 . url_clean AS url_clean_41 , t0 . dateupdate AS dateupdate_42 , t0 . dateinsert AS dateinsert_43 , t0 . publish AS publish_44 , t0 . valid AS valid_45 , t0 . country AS country_46 , t0 . idextranetuser AS idextranetuser_47 FROM contacts t0 WHERE t0 . idcontact = 778 ;
Copy
0.24 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 = 33055 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 = 33055 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.24 ms (0.06%)
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 = 12555
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 = 12555
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.24 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 = 30580 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 = 30580 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.24 ms (0.06%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 12555
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
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 12555
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.24 ms (0.06%)
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` = 30580 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` = 30580 AND d . code_franceinter IS NOT NULL ;
Copy
0.23 ms (0.06%)
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` = 31898 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` = 31898 AND d . code_franceinter IS NOT NULL ;
Copy
0.23 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 = 36410 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 = 36410 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.23 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 = 41648 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 = 41648 ORDER BY j2 . classement ASC ;
Copy
0.23 ms (0.06%)
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 = 12555
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 = 12555
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.23 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 = 44683 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 = 44683 ORDER BY j2 . classement ASC ;
Copy
0.23 ms (0.06%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 30394
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 = 30394
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.23 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 = 33370 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 = 33370 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.23 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 = 33055 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 = 33055 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.23 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 = 33055 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 = 33055 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.22 ms (0.06%)
2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 2 ;
Copy
0.22 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 = 31898 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 = 31898 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.22 ms (0.06%)
1
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 408 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `type_diffusion` = 1 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 408 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `type_diffusion` = 1 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
;
Copy
0.22 ms (0.06%)
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 = 12555
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 = 12555
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.22 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 = 36410 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 = 36410 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.22 ms (0.06%)
2
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 21372
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 21372 ;
Copy
0.21 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 = 30686 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 = 30686 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.21 ms (0.06%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 15712
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
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 15712
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.21 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 = 41199 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 = 41199 ORDER BY j2 . classement ASC ;
Copy
0.21 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 = 30394 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 = 30394 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.21 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 = 32125 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 = 32125 ORDER BY j2 . classement ASC ;
Copy
0.21 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 = 10550 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 = 10550 ORDER BY j2 . classement ASC ;
Copy
0.21 ms (0.05%)
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 = 33370 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 = 33370 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.21 ms (0.05%)
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 = 30580 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 = 30580 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.21 ms (0.05%)
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 = 36410 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 = 36410 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.20 ms (0.05%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 408 AND aides . type_aide IN (2 , 3 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 408 AND aides . type_aide IN (2 , 3 ) ;
Copy
0.19 ms (0.05%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 15712
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
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 15712
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.19 ms (0.05%)
1
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 12555 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` = 12555 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.19 ms (0.05%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 15712
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
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 15712
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.19 ms (0.05%)
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` = 33055 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` = 33055 AND d . code_franceinter IS NOT NULL ;
Copy
0.19 ms (0.05%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 408 AND aides . type_aide IN (1 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 408 AND aides . type_aide IN (1 ) ;
Copy
0.19 ms (0.05%)
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 = 30580 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 = 30580 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.19 ms (0.05%)
1
SELECT object_multimedia . object , object_multimedia . idobject , contacts . idcontact , contacts . type , contacts . organisation , contacts . lastname , contacts . firstname
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 15712
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 . lastname , contacts . firstname
FROM object_multimedia , contacts
WHERE object_multimedia . idobject = contacts . idcontact
AND object_multimedia . idmultimedia = 15712
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.18 ms (0.05%)
1
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 408 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `type_diffusion` = 2 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 408 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `type_diffusion` = 2 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
;
Copy
0.18 ms (0.05%)
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` = 36410 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` = 36410 AND d . code_franceinter IS NOT NULL ;
Copy
0.18 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 = 24673 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 = 24673 ORDER BY j2 . classement ASC ;
Copy
0.18 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 = 20611 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 = 20611 ORDER BY j2 . classement ASC ;
Copy
0.18 ms (0.05%)
2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 2 ;
Copy
0.18 ms (0.05%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 12555
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
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 12555
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.18 ms (0.05%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 12555
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
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 12555
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.17 ms (0.05%)
2
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 408
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 408 ;
Copy
0.17 ms (0.04%)
2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 1 ;
Copy
0.17 ms (0.04%)
1
SELECT s0_ . idspectacle AS idspectacle_0 , s0_ . title AS title_1 , s0_ . language AS language_2 , s0_ . creation_date AS creation_date_3 , s0_ . url_page AS url_page_4 , s0_ . infos AS infos_5 , s0_ . tag AS tag_6 , s0_ . id_rubrique AS id_rubrique_7 , s0_ . duration AS duration_8 , s0_ . interlude AS interlude_9 , s0_ . textfictif AS textfictif_10 , s0_ . url_redirect AS url_redirect_11 , s0_ . url_clean AS url_clean_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . statut AS statut_16 , s0_ . valid AS valid_17 , s0_ . idtypespectacle AS idtypespectacle_18 , s0_ . idcontact_creation AS idcontact_creation_19 , s0_ . idcontact_production AS idcontact_production_20 , s0_ . idspectaclegenre AS idspectaclegenre_21 , s0_ . idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_ . idspectacle = ?
SELECT s0_ . idspectacle AS idspectacle_0 , s0_ . title AS title_1 , s0_ . language AS language_2 , s0_ . creation_date AS creation_date_3 , s0_ . url_page AS url_page_4 , s0_ . infos AS infos_5 , s0_ . tag AS tag_6 , s0_ . id_rubrique AS id_rubrique_7 , s0_ . duration AS duration_8 , s0_ . interlude AS interlude_9 , s0_ . textfictif AS textfictif_10 , s0_ . url_redirect AS url_redirect_11 , s0_ . url_clean AS url_clean_12 , s0_ . dateupdate AS dateupdate_13 , s0_ . dateinsert AS dateinsert_14 , s0_ . publish AS publish_15 , s0_ . statut AS statut_16 , s0_ . valid AS valid_17 , s0_ . idtypespectacle AS idtypespectacle_18 , s0_ . idcontact_creation AS idcontact_creation_19 , s0_ . idcontact_production AS idcontact_production_20 , s0_ . idspectaclegenre AS idspectaclegenre_21 , s0_ . idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_ . idspectacle = 21372 ;
Copy
0.17 ms (0.04%)
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 = 30394 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 = 30394 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.17 ms (0.04%)
2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 3
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 3 ;
Copy
0.17 ms (0.04%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 408 AND aides . type_aide IN (4 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide . `idspectacle` = spectacles . `idspectacle`
INNER JOIN aides ON aides . `idaide` = spectacle_aide . `idaide` WHERE spectacles . `publish` = 1 AND aides . `idcontact` = 408 AND aides . type_aide IN (4 ) ;
Copy
0.17 ms (0.04%)
2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 3
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 3 ;
Copy
0.17 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 = 21349 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 = 21349 ORDER BY j2 . classement ASC ;
Copy
0.17 ms (0.04%)
2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 1 ;
Copy
0.16 ms (0.04%)
2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 2 ;
Copy
0.16 ms (0.04%)
2
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_presentation_structure' ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_presentation_structure' ))) AND contacts = 1 ;
Copy
0.16 ms (0.04%)
2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 1 ;
Copy
0.16 ms (0.04%)
2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 4
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 4 ;
Copy
0.16 ms (0.04%)
2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 2 ;
Copy
0.16 ms (0.04%)
2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 4
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 4 ;
Copy
0.16 ms (0.04%)
2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 3
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 3 ;
Copy
0.16 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` = 30394 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` = 30394 AND d . code_franceinter IS NOT NULL ;
Copy
0.16 ms (0.04%)
1
SELECT t . idtext , t . title , t . type , t . url_clean , t . textfictif FROM texts t , text_spectacle ts
WHERE 1
AND ts . idspectacle = 21372
AND t . idtext = ts . idtext
SELECT t . idtext , t . title , t . type , t . url_clean , t . textfictif FROM texts t , text_spectacle ts
WHERE 1
AND ts . idspectacle = 21372
AND t . idtext = ts . idtext ;
Copy
0.15 ms (0.04%)
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 = 30394 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 = 30394 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.15 ms (0.04%)
2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 1 ;
Copy
0.15 ms (0.04%)
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 = 31898 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 = 31898 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.15 ms (0.04%)
2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 4
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 408
AND aides . `type_aide` = 4 ;
Copy
0.15 ms (0.04%)
1
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15712
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia
SELECT object_multimedia . object , object_multimedia . idobject , spectacles . idspectacle , spectacles . title
FROM object_multimedia , spectacles
WHERE object_multimedia . idobject = spectacles . idspectacle
AND object_multimedia . idmultimedia = 15712
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.11 ms (0.03%)
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 = 16021 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 = 16021 ORDER BY p . `lastname` ;
Copy
0.11 ms (0.03%)
1
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 21372
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 21372 ;
Copy
0.09 ms (0.02%)
1
SELECT t0_ . idtypestructure AS idtypestructure_0 , t0_ . typestructure_pluriel AS typestructure_pluriel_1 , t0_ . typestructure AS typestructure_2 , t0_ . public_view AS public_view_3 , t0_ . order_view AS order_view_4 FROM typesstructures t0_ WHERE t0_ . idtypestructure = ?
SELECT t0_ . idtypestructure AS idtypestructure_0 , t0_ . typestructure_pluriel AS typestructure_pluriel_1 , t0_ . typestructure AS typestructure_2 , t0_ . public_view AS public_view_3 , t0_ . order_view AS order_view_4 FROM typesstructures t0_ WHERE t0_ . idtypestructure = 'SC' ;
Copy
0.09 ms (0.02%)
2
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND contacts = 1 AND lagarce ! = 1 AND is_public IN (1 )
SELECT idclassification , classification , public_name FROM classifications WHERE 1 AND type = "files" AND contacts = 1 AND lagarce ! = 1 AND is_public IN (1 ) ;
Copy
0.09 ms (0.02%)
2
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_article' ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_article' ))) AND contacts = 1 ;
Copy
0.09 ms (0.02%)
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 = 22834 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 = 22834 ORDER BY j2 . classement ASC ;
Copy
0.08 ms (0.02%)
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 = 20262 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 = 20262 ORDER BY j2 . classement ASC ;
Copy
0.07 ms (0.02%)
1
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
0.07 ms (0.02%)
1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_pp' ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . classification IN ('class_pp' ))) AND contacts = 1 ;
Copy
0.07 ms (0.02%)
1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . idclassification IN (100 ))) AND contacts = 1
SELECT DISTINCT (cl . type ) FROM classifications cl WHERE ((cl . idclassification IN (100 ))) AND contacts = 1 ;
Copy
0.06 ms (0.02%)
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 = 38167 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 = 38167 ORDER BY j2 . classement ASC ;
Copy
0.05 ms (0.01%)
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 = 28114 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 = 28114 ORDER BY p . `lastname` ;
Copy
0.05 ms (0.01%)
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 = 31835 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 = 31835 ORDER BY p . `lastname` ;
Copy
0.04 ms (0.01%)
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
0.04 ms (0.01%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31835
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 = 31835
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.04 ms (0.01%)
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 = 31096 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 = 31096 ORDER BY p . `lastname` ;
Copy
0.04 ms (0.01%)
1
SELECT fr FROM countries WHERE id = 'CH'
SELECT fr FROM countries WHERE id = 'CH' ;
Copy
0.04 ms (0.01%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 28114
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 = 28114
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.04 ms (0.01%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 30686
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 = 30686
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.04 ms (0.01%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31096
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 = 31096
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.04 ms (0.01%)
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 = 31096 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 = 31096 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.04 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 = 31269 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 = 31269 ORDER BY j2 . classement ASC ;
Copy
0.03 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 = 38653 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 = 38653 ORDER BY j2 . classement ASC ;
Copy
0.03 ms (0.01%)
1
SELECT lt . fr
FROM typesspectacles e , langterms lt
WHERE typespectacle = lt . id
AND idtypespectacle = 4
SELECT lt . fr
FROM typesspectacles e , langterms lt
WHERE typespectacle = lt . id
AND idtypespectacle = 4 ;
Copy
0.03 ms (0.01%)
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 = '31835'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31835'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.03 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 = 34806 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 = 34806 ORDER BY j2 . classement ASC ;
Copy
0.03 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 = 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.03 ms (0.01%)
1
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy
0.03 ms (0.01%)
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` = 31835 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` = 31835 AND d . code_franceinter IS NOT NULL ;
Copy
0.03 ms (0.01%)
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 = 31835 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 = 31835 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.03 ms (0.01%)
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 = 31835 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 = 31835 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.03 ms (0.01%)
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 = 31835 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 = 31835 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.03 ms (0.01%)
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 = '31096'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31096'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.03 ms (0.01%)
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` = 31096 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` = 31096 AND d . code_franceinter IS NOT NULL ;
Copy
0.03 ms (0.01%)
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 = '28114'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '28114'
AND of . object = 'spectacles'
AND cl . idclassification = fc . idclassification AND ((cl . idclassification IN (33 , 126 , 163 , 164 , 166 , 171 , 172 , 175 ))) AND f . valid = 1 AND f . publish = 1 AND f . idtype = tf . idtype ;
Copy
0.03 ms (0.01%)
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` = 30686 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` = 30686 AND d . code_franceinter IS NOT NULL ;
Copy
0.03 ms (0.01%)
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` = 28114 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` = 28114 AND d . code_franceinter IS NOT NULL ;
Copy
0.02 ms (0.01%)
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 = 28114 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 = 28114 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.02 ms (0.01%)
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 = 31096 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 = 31096 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.02 ms (0.01%)
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 = 31096 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 = 31096 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.02 ms (0.01%)
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 = 28114 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 = 28114 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.02 ms (0.01%)
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 = 28114 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 = 28114 AND cc . idclassification = 125 LIMIT 1 ;
Copy