432.01 ms (47.37%)
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 ('1578' , '1846' , '4597' , '11041' , '11434' , '11708' , '13535' , '15017' , '18755' , '19657' , '22971' , '23809' , '26226' , '26757' , '27600' , '27676' , '27857' , '30366' , '30967' , '31201' , '31722' , '31814' , '31996' , '33265' , '33382' , '33618' , '34390' , '35418' , '35983' , '35995' , '36974' , '37177' , '98' , '3' , '1087' , '1448' , '963' , '1695' , '1736' , '1898' , '2825' , '1574' , '2103' , '2302' , '2303' , '2808' , '1797' , '3816' , '3908' , '3825' , '3156' , '4398' , '3966' , '4725' , '4741' , '4776' , '5145' , '4243' , '5246' , '5308' , '4602' , '5599' , '6644' , '6855' , '6807' , '4674' , '6908' , '7146' , '6968' , '7429' , '5080' , '10529' , '11506' , '11862' , '12318' , '13749' , '14036' , '15126' , '18413' , '16803' , '8878' , '8900' , '13936' , '9950' , '18013' , '10135' , '10555' , '12473' , '13295' , '18019' , '17110' , '12574' , '12274' , '18858' , '19712' , '17628' , '20134' , '11426' , '17271' , '6805' , '25144' , '21398' , '25924' , '24842' , '13743' , '21333' , '27693' , '25498' , '20402' , '27860' , '19591' , '26825' , '21342' , '21064' , '16599' , '21613' , '13030' , '28179' , '30253' , '21034' , '21679' , '23669' , '25123' , '20335' , '29783' , '29933' , '32402' , '20776' , '28235' , '19975' , '29551' , '29984' , '22560' , '27605' , '29215' , '29684' , '26917' , '34257' , '31548' , '27182' , '21349' , '31096' , '35328' , '32039' , '25189' , '28536' , '29587' , '34471' )
OR (
sc . `idcontact` = 656 OR sc . `idcontact_festival` = 656
)
)
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 (
'1578' ,
'1846' ,
'4597' ,
'11041' ,
'11434' ,
'11708' ,
'13535' ,
'15017' ,
'18755' ,
'19657' ,
'22971' ,
'23809' ,
'26226' ,
'26757' ,
'27600' ,
'27676' ,
'27857' ,
'30366' ,
'30967' ,
'31201' ,
'31722' ,
'31814' ,
'31996' ,
'33265' ,
'33382' ,
'33618' ,
'34390' ,
'35418' ,
'35983' ,
'35995' ,
'36974' ,
'37177' ,
'98' ,
'3' ,
'1087' ,
'1448' ,
'963' ,
'1695' ,
'1736' ,
'1898' ,
'2825' ,
'1574' ,
'2103' ,
'2302' ,
'2303' ,
'2808' ,
'1797' ,
'3816' ,
'3908' ,
'3825' ,
'3156' ,
'4398' ,
'3966' ,
'4725' ,
'4741' ,
'4776' ,
'5145' ,
'4243' ,
'5246' ,
'5308' ,
'4602' ,
'5599' ,
'6644' ,
'6855' ,
'6807' ,
'4674' ,
'6908' ,
'7146' ,
'6968' ,
'7429' ,
'5080' ,
'10529' ,
'11506' ,
'11862' ,
'12318' ,
'13749' ,
'14036' ,
'15126' ,
'18413' ,
'16803' ,
'8878' ,
'8900' ,
'13936' ,
'9950' ,
'18013' ,
'10135' ,
'10555' ,
'12473' ,
'13295' ,
'18019' ,
'17110' ,
'12574' ,
'12274' ,
'18858' ,
'19712' ,
'17628' ,
'20134' ,
'11426' ,
'17271' ,
'6805' ,
'25144' ,
'21398' ,
'25924' ,
'24842' ,
'13743' ,
'21333' ,
'27693' ,
'25498' ,
'20402' ,
'27860' ,
'19591' ,
'26825' ,
'21342' ,
'21064' ,
'16599' ,
'21613' ,
'13030' ,
'28179' ,
'30253' ,
'21034' ,
'21679' ,
'23669' ,
'25123' ,
'20335' ,
'29783' ,
'29933' ,
'32402' ,
'20776' ,
'28235' ,
'19975' ,
'29551' ,
'29984' ,
'22560' ,
'27605' ,
'29215' ,
'29684' ,
'26917' ,
'34257' ,
'31548' ,
'27182' ,
'21349' ,
'31096' ,
'35328' ,
'32039' ,
'25189' ,
'28536' ,
'29587' ,
'34471'
)
OR (
sc . `idcontact` = 656
OR sc . `idcontact_festival` = 656
)
)
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 ('1578' , '1846' , '4597' , '11041' , '11434' , '11708' , '13535' , '15017' , '18755' , '19657' , '22971' , '23809' , '26226' , '26757' , '27600' , '27676' , '27857' , '30366' , '30967' , '31201' , '31722' , '31814' , '31996' , '33265' , '33382' , '33618' , '34390' , '35418' , '35983' , '35995' , '36974' , '37177' , '98' , '3' , '1087' , '1448' , '963' , '1695' , '1736' , '1898' , '2825' , '1574' , '2103' , '2302' , '2303' , '2808' , '1797' , '3816' , '3908' , '3825' , '3156' , '4398' , '3966' , '4725' , '4741' , '4776' , '5145' , '4243' , '5246' , '5308' , '4602' , '5599' , '6644' , '6855' , '6807' , '4674' , '6908' , '7146' , '6968' , '7429' , '5080' , '10529' , '11506' , '11862' , '12318' , '13749' , '14036' , '15126' , '18413' , '16803' , '8878' , '8900' , '13936' , '9950' , '18013' , '10135' , '10555' , '12473' , '13295' , '18019' , '17110' , '12574' , '12274' , '18858' , '19712' , '17628' , '20134' , '11426' , '17271' , '6805' , '25144' , '21398' , '25924' , '24842' , '13743' , '21333' , '27693' , '25498' , '20402' , '27860' , '19591' , '26825' , '21342' , '21064' , '16599' , '21613' , '13030' , '28179' , '30253' , '21034' , '21679' , '23669' , '25123' , '20335' , '29783' , '29933' , '32402' , '20776' , '28235' , '19975' , '29551' , '29984' , '22560' , '27605' , '29215' , '29684' , '26917' , '34257' , '31548' , '27182' , '21349' , '31096' , '35328' , '32039' , '25189' , '28536' , '29587' , '34471' )
OR (
sc . `idcontact` = 656 OR sc . `idcontact_festival` = 656
)
);
Copy
103.49 ms (11.35%)
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` = 656 OR spectacles . `idcontact_production` = 656 ) 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` = 656 OR spectacles . `idcontact_production` = 656 ) AND spectacle_contact . `idrole` IN (17 , 18 , 19 );
Copy
47.98 ms (5.26%)
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 = 656 OR schedules . idcontact_festival = 656 )
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 = 656 OR schedules . idcontact_festival = 656 )
AND contents . `publish` = 1
AND contents . `valid` = 1
AND object_content . `object` = 'spectacles'
AND content_classification . `idclassification` IN (125 ) ;
Copy
32.18 ms (3.53%)
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-19' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 656 OR s0_ . idcontact_production = 656 )) 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-19' AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 656 OR s0_ . idcontact_production = 656 )) ORDER BY s1_ . date ASC ;
Copy
25.94 ms (2.84%)
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` = 656 OR sc . `idcontact_festival` = 656 )
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` = 656 OR sc . `idcontact_festival` = 656 )
ORDER BY sc . `date` ;
Copy
24.28 ms (2.66%)
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 = 656 AND (s4_ . publish = 1 AND s0_ . idcontact = 656 ) GROUP BY s4_ . idspectacle HAVING MAX (s0_ . date ) < '2024-04-19' 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 = 656
AND (
s4_ . publish = 1
AND s0_ . idcontact = 656
)
GROUP BY
s4_ . idspectacle
HAVING
MAX (s0_ . date ) < '2024-04-19'
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 = 656 AND (s4_ . publish = 1 AND s0_ . idcontact = 656 ) GROUP BY s4_ . idspectacle HAVING MAX (s0_ . date ) < '2024-04-19' ORDER BY s0_ . date DESC LIMIT 20 ;
Copy
17.47 ms (1.92%)
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 :
[
25189
"2024-04-19 "
656
]
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 = 25189 AND s0_ . date < '2024-04-19' AND s0_ . idcontact = 656 GROUP BY s0_ . idcontact ORDER BY s0_ . date DESC LIMIT 1 ;
Copy
17.16 ms (1.88%)
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 (98 , 3 , 1087 , 1448 , 963 , 1695 , 1736 , 1846 , 1898 , 2825 , 1578 , 1574 , 2103 , 2302 , 2303 , 2808 , 1797 , 3816 , 3908 , 3825 , 3156 , 4398 , 4597 , 3966 , 4725 , 4741 , 4776 , 5145 , 4243 , 5246 , 5308 , 4602 , 5599 , 6644 , 6855 , 6807 , 4674 , 6908 , 7146 , 6968 , 7429 , 5080 , 10529 , 11506 , 11862 , 12318 , 11041 , 13535 , 13749 , 14036 , 15126 , 18413 , 16803 , 8878 , 8900 , 13936 , 9950 , 18013 , 10135 , 10555 , 12473 , 13295 , 18019 , 17110 , 12574 , 12274 , 18858 , 19657 , 19712 , 17628 , 20134 , 11426 , 17271 , 6805 , 25144 , 21398 , 25924 , 24842 , 13743 , 26757 , 21333 , 27600 , 27676 , 27693 , 25498 , 20402 , 27860 , 19591 , 26825 , 21342 , 21064 , 16599 , 21613 , 13030 , 27857 , 28179 , 18755 , 30253 , 21034 , 21679 , 23669 , 25123 , 20335 , 31201 , 31996 , 29783 , 29933 , 32402 , 20776 , 28235 , 19975 , 29551 , 29984 , 22560 , 27605 , 30967 , 29215 , 29684 , 26917 , 30366 , 33265 , 31722 , 33382 , 34257 , 34390 , 33618 , 31548 , 27182 , 21349 , 31096 , 35328 , 32039 , 25189 , 28536 , 29587 , 34471 , 36974 , 1578 , 1846 , 4597 , 11041 , 11434 , 11708 , 13535 , 15017 , 18755 , 19657 , 22971 , 23809 , 26226 , 26757 , 27600 , 27676 , 27857 , 30366 , 30967 , 31201 , 31722 , 31814 , 31996 , 33265 , 33382 , 33618 , 34390 , 35418 , 35983 , 35995 , 36974 , 37177 )
) 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 = 656
)
)
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 (
98 ,
3 ,
1087 ,
1448 ,
963 ,
1695 ,
1736 ,
1846 ,
1898 ,
2825 ,
1578 ,
1574 ,
2103 ,
2302 ,
2303 ,
2808 ,
1797 ,
3816 ,
3908 ,
3825 ,
3156 ,
4398 ,
4597 ,
3966 ,
4725 ,
4741 ,
4776 ,
5145 ,
4243 ,
5246 ,
5308 ,
4602 ,
5599 ,
6644 ,
6855 ,
6807 ,
4674 ,
6908 ,
7146 ,
6968 ,
7429 ,
5080 ,
10529 ,
11506 ,
11862 ,
12318 ,
11041 ,
13535 ,
13749 ,
14036 ,
15126 ,
18413 ,
16803 ,
8878 ,
8900 ,
13936 ,
9950 ,
18013 ,
10135 ,
10555 ,
12473 ,
13295 ,
18019 ,
17110 ,
12574 ,
12274 ,
18858 ,
19657 ,
19712 ,
17628 ,
20134 ,
11426 ,
17271 ,
6805 ,
25144 ,
21398 ,
25924 ,
24842 ,
13743 ,
26757 ,
21333 ,
27600 ,
27676 ,
27693 ,
25498 ,
20402 ,
27860 ,
19591 ,
26825 ,
21342 ,
21064 ,
16599 ,
21613 ,
13030 ,
27857 ,
28179 ,
18755 ,
30253 ,
21034 ,
21679 ,
23669 ,
25123 ,
20335 ,
31201 ,
31996 ,
29783 ,
29933 ,
32402 ,
20776 ,
28235 ,
19975 ,
29551 ,
29984 ,
22560 ,
27605 ,
30967 ,
29215 ,
29684 ,
26917 ,
30366 ,
33265 ,
31722 ,
33382 ,
34257 ,
34390 ,
33618 ,
31548 ,
27182 ,
21349 ,
31096 ,
35328 ,
32039 ,
25189 ,
28536 ,
29587 ,
34471 ,
36974 ,
1578 ,
1846 ,
4597 ,
11041 ,
11434 ,
11708 ,
13535 ,
15017 ,
18755 ,
19657 ,
22971 ,
23809 ,
26226 ,
26757 ,
27600 ,
27676 ,
27857 ,
30366 ,
30967 ,
31201 ,
31722 ,
31814 ,
31996 ,
33265 ,
33382 ,
33618 ,
34390 ,
35418 ,
35983 ,
35995 ,
36974 ,
37177
)
)
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 = 656
)
)
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 (98 , 3 , 1087 , 1448 , 963 , 1695 , 1736 , 1846 , 1898 , 2825 , 1578 , 1574 , 2103 , 2302 , 2303 , 2808 , 1797 , 3816 , 3908 , 3825 , 3156 , 4398 , 4597 , 3966 , 4725 , 4741 , 4776 , 5145 , 4243 , 5246 , 5308 , 4602 , 5599 , 6644 , 6855 , 6807 , 4674 , 6908 , 7146 , 6968 , 7429 , 5080 , 10529 , 11506 , 11862 , 12318 , 11041 , 13535 , 13749 , 14036 , 15126 , 18413 , 16803 , 8878 , 8900 , 13936 , 9950 , 18013 , 10135 , 10555 , 12473 , 13295 , 18019 , 17110 , 12574 , 12274 , 18858 , 19657 , 19712 , 17628 , 20134 , 11426 , 17271 , 6805 , 25144 , 21398 , 25924 , 24842 , 13743 , 26757 , 21333 , 27600 , 27676 , 27693 , 25498 , 20402 , 27860 , 19591 , 26825 , 21342 , 21064 , 16599 , 21613 , 13030 , 27857 , 28179 , 18755 , 30253 , 21034 , 21679 , 23669 , 25123 , 20335 , 31201 , 31996 , 29783 , 29933 , 32402 , 20776 , 28235 , 19975 , 29551 , 29984 , 22560 , 27605 , 30967 , 29215 , 29684 , 26917 , 30366 , 33265 , 31722 , 33382 , 34257 , 34390 , 33618 , 31548 , 27182 , 21349 , 31096 , 35328 , 32039 , 25189 , 28536 , 29587 , 34471 , 36974 , 1578 , 1846 , 4597 , 11041 , 11434 , 11708 , 13535 , 15017 , 18755 , 19657 , 22971 , 23809 , 26226 , 26757 , 27600 , 27676 , 27857 , 30366 , 30967 , 31201 , 31722 , 31814 , 31996 , 33265 , 33382 , 33618 , 34390 , 35418 , 35983 , 35995 , 36974 , 37177 )
) 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 = 656
)
);
Copy
10.53 ms (1.15%)
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` = 656 OR spectacles . `idcontact_production` = 656 ) 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` = 656 OR spectacles . `idcontact_production` = 656 ) 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
10.13 ms (1.11%)
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 = 656 AND (s0_ . publish = 1 AND s1_ . idcontact = 656 ) 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 = 656 AND (s0_ . publish = 1 AND s1_ . idcontact = 656 ) ORDER BY s1_ . date DESC ;
Copy
6.80 ms (0.75%)
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 = 656 AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 656 OR s0_ . idcontact_production = 656 )) 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 = 656 AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND s8_ . idrole IN (17 , 18 , 19 ) AND (s8_ . idcontact = 656 OR s0_ . idcontact_production = 656 )) ORDER BY sclr_1 DESC ;
Copy
5.85 ms (0.64%)
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 = 656 AND (s2_ . publish = 1 AND s0_ . idcontact = 656 ) 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 = 656 AND (s2_ . publish = 1 AND s0_ . idcontact = 656 ) ORDER BY s0_ . date DESC ;
Copy
4.76 ms (0.52%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
4.31 ms (0.47%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
4.06 ms (0.45%)
21
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = ?
SELECT t0_ . type AS type_0 FROM texts t0_ WHERE t0_ . idtext = 31163 ;
Copy
3.99 ms (0.44%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
3.98 ms (0.44%)
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` = 656 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` = 656 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
;
Copy
3.94 ms (0.43%)
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
3.68 ms (0.40%)
2
INSERT INTO stats (type , module , url , md5url , idcontent , object , idobject , video , lng , remote_addr , source ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"article "
"thnet "
"/contacts/Theatre-de-Bourg-en-Bresse/videos/type/partenariat "
"cdb7d3b2a22482042d1764c0fd86dc06 "
0
"contacts "
656
0
"fr "
"86638e2233248e7f0d2f79299f620cc4-65d9 "
"/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/Theatre-de-Bourg-en-Bresse/videos/type/partenariat' , 'cdb7d3b2a22482042d1764c0fd86dc06' , 0 , 'contacts' , 656 , 0 , 'fr' , '86638e2233248e7f0d2f79299f620cc4-65d9' , '/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829' );
Copy
2.87 ms (0.32%)
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 = '17466' ;
Copy
2.80 ms (0.31%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
2.74 ms (0.30%)
1
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 656 OR schedules . idcontact_festival = 656 )
SELECT DISTINCT (spectacles . `idspectacle` ) FROM schedules , spectacles WHERE schedules . idspectacle = spectacles . idspectacle
AND spectacles . publish = 1
AND (schedules . idcontact = 656 OR schedules . idcontact_festival = 656 );
Copy
2.60 ms (0.29%)
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` = 656 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` = 656 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
LIMIT 0 , 20 ;
Copy
2.41 ms (0.26%)
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 = 656 AND s1_ . date > = '2024-04-19' AND (s0_ . publish = 1 AND s1_ . idcontact = 656 ) 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 = 656 AND s1_ . date > = '2024-04-19' AND (s0_ . publish = 1 AND s1_ . idcontact = 656 ) ORDER BY s1_ . date ASC ;
Copy
2.27 ms (0.25%)
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` = 656 OR spectacles . `idcontact_production` = 656 ) 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` = 656 OR spectacles . `idcontact_production` = 656 ) AND spectacle_contact . `idrole` = 77 ;
Copy
1.98 ms (0.22%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.88 ms (0.21%)
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.60 ms (0.18%)
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 = '656'
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 = '656'
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
1.59 ms (0.17%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 28536
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 = 28536
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
1.58 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 = 34471 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 = 34471 ORDER BY p . `lastname` ;
Copy
1.56 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 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 = 656 AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 656 )) 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 = 656 AND (s0_ . publish = 1 AND s8_ . idspectacle = s0_ . idspectacle AND (s8_ . idrole IN (77 ) AND s8_ . idcontact = 656 )) ORDER BY sclr_1 DESC ;
Copy
1.53 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 = 17466
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 = 17466
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.50 ms (0.16%)
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 (1578 , 1846 , 4597 , 11041 , 11434 , 11708 , 13535 , 15017 , 18755 , 19657 , 22971 , 23809 , 26226 , 26757 , 27600 , 27676 , 27857 , 30366 , 30967 , 31201 , 31722 , 31814 , 31996 , 33265 , 33382 , 33618 , 34390 , 35418 , 35983 , 35995 , 36974 , 37177 , 98 , 3 , 1087 , 1448 , 963 , 1695 , 1736 , 1898 , 2825 , 1574 , 2103 , 2302 , 2303 , 2808 , 1797 , 3816 , 3908 , 3825 , 3156 , 4398 , 3966 , 4725 , 4741 , 4776 , 5145 , 4243 , 5246 , 5308 , 4602 , 5599 , 6644 , 6855 , 6807 , 4674 , 6908 , 7146 , 6968 , 7429 , 5080 , 10529 , 11506 , 11862 , 12318 , 13749 , 14036 , 15126 , 18413 , 16803 , 8878 , 8900 , 13936 , 9950 , 18013 , 10135 , 10555 , 12473 , 13295 , 18019 , 17110 , 12574 , 12274 , 18858 , 19712 , 17628 , 20134 , 11426 , 17271 , 6805 , 25144 , 21398 , 25924 , 24842 , 13743 , 21333 , 27693 , 25498 , 20402 , 27860 , 19591 , 26825 , 21342 , 21064 , 16599 , 21613 , 13030 , 28179 , 30253 , 21034 , 21679 , 23669 , 25123 , 20335 , 29783 , 29933 , 32402 , 20776 , 28235 , 19975 , 29551 , 29984 , 22560 , 27605 , 29215 , 29684 , 26917 , 34257 , 31548 , 27182 , 21349 , 31096 , 35328 , 32039 , 25189 , 28536 , 29587 , 34471 ) 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 (
1578 ,
1846 ,
4597 ,
11041 ,
11434 ,
11708 ,
13535 ,
15017 ,
18755 ,
19657 ,
22971 ,
23809 ,
26226 ,
26757 ,
27600 ,
27676 ,
27857 ,
30366 ,
30967 ,
31201 ,
31722 ,
31814 ,
31996 ,
33265 ,
33382 ,
33618 ,
34390 ,
35418 ,
35983 ,
35995 ,
36974 ,
37177 ,
98 ,
3 ,
1087 ,
1448 ,
963 ,
1695 ,
1736 ,
1898 ,
2825 ,
1574 ,
2103 ,
2302 ,
2303 ,
2808 ,
1797 ,
3816 ,
3908 ,
3825 ,
3156 ,
4398 ,
3966 ,
4725 ,
4741 ,
4776 ,
5145 ,
4243 ,
5246 ,
5308 ,
4602 ,
5599 ,
6644 ,
6855 ,
6807 ,
4674 ,
6908 ,
7146 ,
6968 ,
7429 ,
5080 ,
10529 ,
11506 ,
11862 ,
12318 ,
13749 ,
14036 ,
15126 ,
18413 ,
16803 ,
8878 ,
8900 ,
13936 ,
9950 ,
18013 ,
10135 ,
10555 ,
12473 ,
13295 ,
18019 ,
17110 ,
12574 ,
12274 ,
18858 ,
19712 ,
17628 ,
20134 ,
11426 ,
17271 ,
6805 ,
25144 ,
21398 ,
25924 ,
24842 ,
13743 ,
21333 ,
27693 ,
25498 ,
20402 ,
27860 ,
19591 ,
26825 ,
21342 ,
21064 ,
16599 ,
21613 ,
13030 ,
28179 ,
30253 ,
21034 ,
21679 ,
23669 ,
25123 ,
20335 ,
29783 ,
29933 ,
32402 ,
20776 ,
28235 ,
19975 ,
29551 ,
29984 ,
22560 ,
27605 ,
29215 ,
29684 ,
26917 ,
34257 ,
31548 ,
27182 ,
21349 ,
31096 ,
35328 ,
32039 ,
25189 ,
28536 ,
29587 ,
34471
)
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 (1578 , 1846 , 4597 , 11041 , 11434 , 11708 , 13535 , 15017 , 18755 , 19657 , 22971 , 23809 , 26226 , 26757 , 27600 , 27676 , 27857 , 30366 , 30967 , 31201 , 31722 , 31814 , 31996 , 33265 , 33382 , 33618 , 34390 , 35418 , 35983 , 35995 , 36974 , 37177 , 98 , 3 , 1087 , 1448 , 963 , 1695 , 1736 , 1898 , 2825 , 1574 , 2103 , 2302 , 2303 , 2808 , 1797 , 3816 , 3908 , 3825 , 3156 , 4398 , 3966 , 4725 , 4741 , 4776 , 5145 , 4243 , 5246 , 5308 , 4602 , 5599 , 6644 , 6855 , 6807 , 4674 , 6908 , 7146 , 6968 , 7429 , 5080 , 10529 , 11506 , 11862 , 12318 , 13749 , 14036 , 15126 , 18413 , 16803 , 8878 , 8900 , 13936 , 9950 , 18013 , 10135 , 10555 , 12473 , 13295 , 18019 , 17110 , 12574 , 12274 , 18858 , 19712 , 17628 , 20134 , 11426 , 17271 , 6805 , 25144 , 21398 , 25924 , 24842 , 13743 , 21333 , 27693 , 25498 , 20402 , 27860 , 19591 , 26825 , 21342 , 21064 , 16599 , 21613 , 13030 , 28179 , 30253 , 21034 , 21679 , 23669 , 25123 , 20335 , 29783 , 29933 , 32402 , 20776 , 28235 , 19975 , 29551 , 29984 , 22560 , 27605 , 29215 , 29684 , 26917 , 34257 , 31548 , 27182 , 21349 , 31096 , 35328 , 32039 , 25189 , 28536 , 29587 , 34471 ) AND d . code_franceinter IS NOT NULL ;
Copy
1.49 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 = 28536 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 = 28536 ORDER BY p . `lastname` ;
Copy
1.44 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 = 29783 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 = 29783 ORDER BY p . `lastname` ;
Copy
1.41 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` = 656 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` = 656 AND multimedias . `idmultimedia` = object_multimedia . `idmultimedia`
GROUP BY multimedias . idmultimedia
ORDER BY multimedias . date
DESC
;
Copy
1.35 ms (0.15%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31201 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 = 31201 ORDER BY p . `lastname` ;
Copy
1.32 ms (0.14%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 656
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 = 656
AND om . object = 'contacts'
AND m . publish = 1 AND m . audio_video = 2 ;
Copy
1.32 ms (0.14%)
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 = '656'
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 = '656'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_presentation_structure' ))) ORDER BY c . `range` , c . idcontent ;
Copy
1.32 ms (0.14%)
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 = '656'
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 = '656'
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
1.27 ms (0.14%)
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 :
[
"86638e2233248e7f0d2f79299f620cc4-65d9 "
0
"cdb7d3b2a22482042d1764c0fd86dc06 "
]
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 = '86638e2233248e7f0d2f79299f620cc4-65d9' AND t0 . idcontent = 0 AND t0 . md5url = 'cdb7d3b2a22482042d1764c0fd86dc06' ;
Copy
1.26 ms (0.14%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 25189 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 = 25189 ORDER BY p . `lastname` ;
Copy
1.21 ms (0.13%)
1
SELECT t . idtext , t . title , t . type , t . url_clean , t . textfictif FROM texts t , text_spectacle ts
WHERE 1
AND ts . idspectacle = 24110
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 = 24110
AND t . idtext = ts . idtext ;
Copy
1.20 ms (0.13%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31996 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 = 31996 ORDER BY p . `lastname` ;
Copy
1.19 ms (0.13%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 13030 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 = 13030 ORDER BY p . `lastname` ;
Copy
1.17 ms (0.13%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 26917 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 = 26917 AND cc . idclassification = 6 LIMIT 1 ;
Copy
1.16 ms (0.13%)
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.16 ms (0.13%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 29587 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 = 29587 ORDER BY p . `lastname` ;
Copy
1.16 ms (0.13%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 20776 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 = 20776 ORDER BY p . `lastname` ;
Copy
1.12 ms (0.12%)
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 = 17466
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 = 17466
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
1.07 ms (0.12%)
2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 2 ;
Copy
1.07 ms (0.12%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 29215 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 = 29215 ORDER BY p . `lastname` ;
Copy
1.06 ms (0.12%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31722 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 = 31722 ORDER BY p . `lastname` ;
Copy
1.06 ms (0.12%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 29933 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 = 29933 ORDER BY p . `lastname` ;
Copy
1.06 ms (0.12%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 21349 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 = 21349 ORDER BY p . `lastname` ;
Copy
1.03 ms (0.11%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 27182 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 = 27182 ORDER BY p . `lastname` ;
Copy
1.02 ms (0.11%)
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 (656 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-04-19' AND '2026-04-09' )) 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 (656 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND ((s1_ . date BETWEEN '2024-04-19' AND '2026-04-09' )) ORDER BY s1_ . date ASC ;
Copy
1.00 ms (0.11%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 22560 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 = 22560 ORDER BY p . `lastname` ;
Copy
0.99 ms (0.11%)
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 = '656'
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 = '656'
AND oc . object = 'contacts'
AND cl . idclassification = cc . idclassification AND ((cl . classification IN ('class_article' ))) ORDER BY c . `range` , c . idcontent ;
Copy
0.95 ms (0.10%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 31548 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 = 31548 ORDER BY p . `lastname` ;
Copy
0.93 ms (0.10%)
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 (656 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-04-19' 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 (656 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) AND s1_ . date < '2024-04-19' ORDER BY s1_ . date DESC ;
Copy
0.91 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 = 25189 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 = 25189 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.90 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 = 656 ) 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 = 656 ) AND T1 . publish = 1 ;
Copy
0.90 ms (0.10%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 33618 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 = 33618 ORDER BY p . `lastname` ;
Copy
0.90 ms (0.10%)
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 (656 ) 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 (656 ) AND s1_ . idspectacle = s0_ . idspectacle AND (s1_ . idcontact = c7_ . idcontact OR s1_ . idcontact_festival = c7_ . idcontact ) ORDER BY s1_ . date ASC ;
Copy
0.87 ms (0.10%)
1
SELECT p . `idperson` as id , p . `idperson` as idperson , p . `lastname` , p . `firstname` , p . `url_clean` , p . `valid` ,
lt . `fr` ,
r . `idrole` , r . `role` , r . `type` ,
sp . `comment` , sp . `date_start` , sp . `date_end`
FROM persons p
JOIN spectacle_person sp ON sp . `idperson` = p . `idperson`
JOIN roles r ON r . `idrole` = sp . `idrole`
JOIN langterms lt ON r . `role` = lt . `id`
WHERE sp . idspectacle = 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.86 ms (0.09%)
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 = 26917 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 = 26917 ORDER BY p . `lastname` ;
Copy
0.79 ms (0.09%)
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 = 23669 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 = 23669 ORDER BY p . `lastname` ;
Copy
0.78 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 = 25189 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 = 25189 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.78 ms (0.09%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.77 ms (0.08%)
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 = 17466
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 = 17466
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.76 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 = 20776 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 = 20776 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
0.75 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 = 12676
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 = 12676
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.75 ms (0.08%)
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 = 17466
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 = 17466
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.74 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 = 31201 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 = 31201 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.71 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 = 31201 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 = 31201 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.70 ms (0.08%)
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 = 35258 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 = 35258 ORDER BY j2 . classement ASC ;
Copy
0.69 ms (0.08%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 22 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.69 ms (0.08%)
2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 3
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 3 ;
Copy
0.68 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 = '22560'
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 = '22560'
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.67 ms (0.07%)
1
SELECT COUNT (oc . idcontent )
FROM object_content oc , contents c , content_classification cc
WHERE oc . idcontent = c . idcontent
AND cc . idcontent = c . idcontent
AND c . publish = 1
AND oc . object = 'spectacles'
AND oc . idobject = 29933 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 = 29933 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.66 ms (0.07%)
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 = 17466
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 = 17466
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.66 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 = '21349'
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 = '21349'
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.66 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 = 34471 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 = 34471 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.65 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 = 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.65 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 = '26917'
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 = '26917'
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.64 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 = 29215 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 = 29215 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.63 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 = '25189'
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 = '25189'
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.59 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 = '29587'
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 = '29587'
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.59 ms (0.06%)
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 = '656'
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 = '656'
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.57 ms (0.06%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31996'
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 = '31996'
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.56 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 = 25189 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 = 25189 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.56 ms (0.06%)
2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 4
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 4 ;
Copy
0.56 ms (0.06%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '23669'
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 = '23669'
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.55 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 = 12676
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 = 12676
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.54 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 = 12676
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 = 12676
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.54 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 = 31201 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 = 31201 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.54 ms (0.06%)
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 = 28536 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 = 28536 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
0.53 ms (0.06%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 22560
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 = 22560
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.53 ms (0.06%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 25189
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 = 25189
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.53 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 = 17466
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 = 17466
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.53 ms (0.06%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '34471'
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 = '34471'
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.52 ms (0.06%)
2
SELECT COUNT (DISTINCT (dvds . iddvd )) as total
FROM `dvds` ,
`dvd_spectacle`
WHERE 1 AND dvds . `publish` = 1 AND dvd_spectacle . `idspectacle` IN (1578 , 1846 , 4597 , 11041 , 11434 , 11708 , 13535 , 15017 , 18755 , 19657 , 22971 , 23809 , 26226 , 26757 , 27600 , 27676 , 27857 , 30366 , 30967 , 31201 , 31722 , 31814 , 31996 , 33265 , 33382 , 33618 , 34390 , 35418 , 35983 , 35995 , 36974 , 37177 ) 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 (1578 , 1846 , 4597 , 11041 , 11434 , 11708 , 13535 , 15017 , 18755 , 19657 , 22971 , 23809 , 26226 , 26757 , 27600 , 27676 , 27857 , 30366 , 30967 , 31201 , 31722 , 31814 , 31996 , 33265 , 33382 , 33618 , 34390 , 35418 , 35983 , 35995 , 36974 , 37177 ) AND dvds . `iddvd` = dvd_spectacle . `iddvd`
;
Copy
0.51 ms (0.06%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '29215'
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 = '29215'
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.51 ms (0.06%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 23669
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 = 23669
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.51 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 = 27182 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 = 27182 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.51 ms (0.06%)
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 = 656 ;
Copy
0.51 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 = 17466
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 = 17466
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.50 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 = 21349 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 = 21349 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.50 ms (0.06%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31996
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 = 31996
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.50 ms (0.05%)
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 = 26917 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 = 26917 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
0.50 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 = 12676
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 = 12676
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.49 ms (0.05%)
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 = 656
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 = 656
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.49 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 = 42747 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 = 42747 ORDER BY j2 . classement ASC ;
Copy
0.49 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` = 656 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` = 656 AND aides . type_aide IN (1 ) ;
Copy
0.49 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 = 39799 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 = 39799 ORDER BY j2 . classement ASC ;
Copy
0.48 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` = 31201 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` = 31201 AND d . code_franceinter IS NOT NULL ;
Copy
0.48 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 = 29783 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 = 29783 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.47 ms (0.05%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 21349
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 = 21349
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.47 ms (0.05%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 26917
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 = 26917
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.47 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` = 31996 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` = 31996 AND d . code_franceinter IS NOT NULL ;
Copy
0.47 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 = 26917 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 = 26917 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.47 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 = 31722 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 = 31722 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.47 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 = 23669 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 = 23669 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.46 ms (0.05%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 29587
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 = 29587
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.46 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 = 26917 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 = 26917 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.46 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 = 37041 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 = 37041 ORDER BY j2 . classement ASC ;
Copy
0.46 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 = 29933 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 = 29933 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.46 ms (0.05%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31201'
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 = '31201'
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.46 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 = 31996 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 = 31996 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.45 ms (0.05%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '29933'
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 = '29933'
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.45 ms (0.05%)
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.45 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 = 20776 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 = 20776 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.45 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 = 36879 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 = 36879 ORDER BY j2 . classement ASC ;
Copy
0.45 ms (0.05%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '33618'
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 = '33618'
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.45 ms (0.05%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31548'
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 = '31548'
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.45 ms (0.05%)
2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 3
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 3 ;
Copy
0.44 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 = 31996 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 = 31996 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.44 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 = 17466
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 = 17466
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.44 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 = 29215 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 = 29215 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.43 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` = 33618 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` = 33618 AND d . code_franceinter IS NOT NULL ;
Copy
0.43 ms (0.05%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '28536'
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 = '28536'
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.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 = 29587 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 = 29587 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.43 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 = 27182 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 = 27182 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.42 ms (0.05%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 13030
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 = 13030
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.42 ms (0.05%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 29783
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 = 29783
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.42 ms (0.05%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31201
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 = 31201
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.42 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` = 656 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `debut_visionnage_ft` < = '2024-04-19' AND podcasts . `fin_visionnage_ft` > '2024-04-19' 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` = 656 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `debut_visionnage_ft` < = '2024-04-19' AND podcasts . `fin_visionnage_ft` > '2024-04-19' AND (`podcasts` . `type_diffusion` IS NULL OR `podcasts` . `type_diffusion` = 0 ) AND podcasts . `is_integrale` = 1 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
;
Copy
0.42 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 = 31722 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 = 31722 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.42 ms (0.05%)
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.41 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 = 20776 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 = 20776 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.41 ms (0.05%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '20776'
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 = '20776'
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.41 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 = 23669 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 = 23669 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.41 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` = 29587 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` = 29587 AND d . code_franceinter IS NOT NULL ;
Copy
0.41 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 = 8539 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 = 8539 ORDER BY j2 . classement ASC ;
Copy
0.41 ms (0.04%)
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 = '29783'
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 = '29783'
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.40 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 = 28536 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 = 28536 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.40 ms (0.04%)
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 = 17466
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 = 17466
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.40 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 = 29933 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 = 29933 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.40 ms (0.04%)
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 = 24110 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 = 24110 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
0.40 ms (0.04%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.40 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 = 16762 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 = 16762 ORDER BY j2 . classement ASC ;
Copy
0.40 ms (0.04%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 21 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.40 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 = 20776 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 = 20776 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.39 ms (0.04%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 29877 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 = 29877 ORDER BY j2 . classement ASC ;
Copy
0.39 ms (0.04%)
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.38 ms (0.04%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 33618
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 = 33618
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.38 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 = 29783 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 = 29783 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.38 ms (0.04%)
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 = '27182'
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 = '27182'
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.38 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 = 33473 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 = 33473 ORDER BY j2 . classement ASC ;
Copy
0.38 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` = 31548 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` = 31548 AND d . code_franceinter IS NOT NULL ;
Copy
0.37 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 = 29587 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 = 29587 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.37 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 = 29783 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 = 29783 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.37 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 = 29215 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 = 29215 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.37 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 = 29587 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 = 29587 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.37 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 = 33791 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 = 33791 ORDER BY j2 . classement ASC ;
Copy
0.36 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 = 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.36 ms (0.04%)
1
SELECT COUNT (DISTINCT (d . `idpodcast` )) as total
FROM podcasts d , podcast_spectacle do
WHERE d . `publish` = 1
AND do . `idpodcast` = d . `idpodcast` AND do . `idspectacle` = 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.36 ms (0.04%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31722
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 = 31722
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.36 ms (0.04%)
2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 1
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 1 ;
Copy
0.36 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 = 21349 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 = 21349 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.35 ms (0.04%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 20776
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 = 20776
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.35 ms (0.04%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 29215
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 = 29215
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.35 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 = 31163 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 = 31163 ORDER BY j2 . classement ASC ;
Copy
0.35 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 = 31996 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 = 31996 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.35 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` = 29783 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` = 29783 AND d . code_franceinter IS NOT NULL ;
Copy
0.35 ms (0.04%)
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 = '13030'
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 = '13030'
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.35 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 = 22560 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 = 22560 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.34 ms (0.04%)
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 = 17466
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 = 17466
AND object_multimedia . object = 'texts' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.34 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 = 23669 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 = 23669 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.34 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 = 24110 ;
Copy
0.34 ms (0.04%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 34471
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 = 34471
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.33 ms (0.04%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 29933
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 = 29933
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.33 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 = 31548 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 = 31548 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.33 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 = 34471 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 = 34471 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.33 ms (0.04%)
2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 1
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 1 ;
Copy
0.33 ms (0.04%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 31548
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 = 31548
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.33 ms (0.04%)
2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 2 ;
Copy
0.33 ms (0.04%)
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 = 27182 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 = 27182 AND r . type_creator = 1 ORDER BY sp . `classement` ;
Copy
0.33 ms (0.04%)
2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 1
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 1 ;
Copy
0.32 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` = 656 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` = 656 AND aides . type_aide IN (4 ) ;
Copy
0.32 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 = 26080 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 = 26080 ORDER BY j2 . classement ASC ;
Copy
0.32 ms (0.04%)
2
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24110
SELECT t . title FROM texts t , text_spectacle ts
WHERE t . idtext = ts . idtext AND ts . idspectacle = 24110 ;
Copy
0.32 ms (0.04%)
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 = 656 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 = 656 AND j2 . idoffice = 1 ;
Copy
0.32 ms (0.03%)
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 = 22560 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 = 22560 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.32 ms (0.03%)
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 = 656 ;
Copy
0.32 ms (0.03%)
2
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 656
SELECT COUNT (DISTINCT (idperson ))
FROM person_ecole WHERE 1 AND idcontact = 656 ;
Copy
0.31 ms (0.03%)
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 = 31722 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 = 31722 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.31 ms (0.03%)
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 = 28536 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 = 28536 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.31 ms (0.03%)
1
SELECT COUNT (DISTINCT (of . idfile )) as total
FROM object_file of ,
files f ,
file_classification fc ,
classifications cl , typesfiles tf
WHERE of . idfile = f . idfile
AND f . idfile = fc . idfile
AND of . idobject = '31722'
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 = '31722'
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.03%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 17466
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 = 17466
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 1 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.31 ms (0.03%)
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 = 22560 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 = 22560 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.30 ms (0.03%)
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 = 31548 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 = 31548 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.30 ms (0.03%)
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.30 ms (0.03%)
1
SELECT COUNT (DISTINCT (m . idmultimedia ))
FROM object_multimedia om , multimedias m
WHERE om . idmultimedia = m . idmultimedia
AND om . idobject = 27182
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 = 27182
AND om . object = 'spectacles'
AND m . publish = 1 ;
Copy
0.30 ms (0.03%)
1
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 17466 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` = 17466 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.30 ms (0.03%)
1
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 24110
SELECT idspectacle , title , url_clean , valid
FROM spectacles
WHERE idspectacle = 24110 ;
Copy
0.30 ms (0.03%)
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 = 13030 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 = 13030 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.30 ms (0.03%)
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 = 21349 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 = 21349 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.30 ms (0.03%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.29 ms (0.03%)
2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 2 ;
Copy
0.29 ms (0.03%)
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 = 12676
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 = 12676
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.29 ms (0.03%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 41886 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 = 41886 ORDER BY j2 . classement ASC ;
Copy
0.29 ms (0.03%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 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.29 ms (0.03%)
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 = 28536 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 = 28536 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.29 ms (0.03%)
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 = 34471 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 = 34471 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.29 ms (0.03%)
1
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 656 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` = 656 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `type_diffusion` = 2 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
;
Copy
0.29 ms (0.03%)
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 = 27182 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 = 27182 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.28 ms (0.03%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 36665 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 = 36665 ORDER BY j2 . classement ASC ;
Copy
0.28 ms (0.03%)
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 = 17466
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 = 17466
AND object_multimedia . object = 'contacts' AND object_multimedia . idrole = 23 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.28 ms (0.03%)
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` = 23669 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` = 23669 AND d . code_franceinter IS NOT NULL ;
Copy
0.28 ms (0.03%)
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` = 28536 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` = 28536 AND d . code_franceinter IS NOT NULL ;
Copy
0.28 ms (0.03%)
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` = 34471 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` = 34471 AND d . code_franceinter IS NOT NULL ;
Copy
0.27 ms (0.03%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 36162 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 = 36162 ORDER BY j2 . classement ASC ;
Copy
0.27 ms (0.03%)
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 = 13030 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 = 13030 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.27 ms (0.03%)
1
SELECT DISTINCT (keywords . idkeyword ), keywords . *
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords . `publish` = 1 AND multimedia_keyword . `idmultimedia` = 12676 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` = 12676 AND keywords . `idkeyword` = multimedia_keyword . `idkeyword`
GROUP BY keywords . idkeyword
ORDER BY keywords . dateinsert
DESC
LIMIT 0 , 10 ;
Copy
0.27 ms (0.03%)
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 = 33618 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 = 33618 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.27 ms (0.03%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 38779 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 = 38779 ORDER BY j2 . classement ASC ;
Copy
0.26 ms (0.03%)
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 = 33618 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 = 33618 AND cc . idclassification = 6 LIMIT 1 ;
Copy
0.26 ms (0.03%)
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` = 22560 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` = 22560 AND d . code_franceinter IS NOT NULL ;
Copy
0.26 ms (0.03%)
1
SELECT object_multimedia . object , object_multimedia . idobject , persons . idperson , persons . lastname , persons . firstname , persons . url_clean
FROM object_multimedia , persons
WHERE object_multimedia . idobject = persons . idperson
AND object_multimedia . idmultimedia = 17466
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 = 17466
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 5 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.25 ms (0.03%)
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 = 17466
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 = 17466
AND object_multimedia . object = 'persons' AND object_multimedia . idrole = 25 ORDER BY object_multimedia . ordermultimedia ;
Copy
0.25 ms (0.03%)
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` = 25189 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` = 25189 AND d . code_franceinter IS NOT NULL ;
Copy
0.25 ms (0.03%)
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` = 26917 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` = 26917 AND d . code_franceinter IS NOT NULL ;
Copy
0.25 ms (0.03%)
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` = 27182 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` = 27182 AND d . code_franceinter IS NOT NULL ;
Copy
0.25 ms (0.03%)
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 = 33618 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 = 33618 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.25 ms (0.03%)
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` = 29933 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` = 29933 AND d . code_franceinter IS NOT NULL ;
Copy
0.25 ms (0.03%)
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` = 656
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` = 656 ;
Copy
0.24 ms (0.03%)
2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 2 ;
Copy
0.24 ms (0.03%)
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` = 21349 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` = 21349 AND d . code_franceinter IS NOT NULL ;
Copy
0.24 ms (0.03%)
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 = 31548 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 = 31548 AND cc . idclassification = 101 LIMIT 1 ;
Copy
0.23 ms (0.03%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 29332 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 = 29332 ORDER BY j2 . classement ASC ;
Copy
0.23 ms (0.03%)
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` = 13030 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` = 13030 AND d . code_franceinter IS NOT NULL ;
Copy
0.23 ms (0.03%)
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` = 20776 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` = 20776 AND d . code_franceinter IS NOT NULL ;
Copy
0.23 ms (0.03%)
1
SELECT idcontact FROM contacts WHERE url_clean = 'Theatre-de-Bourg-en-Bresse'
SELECT idcontact FROM contacts WHERE url_clean = 'Theatre-de-Bourg-en-Bresse' ;
Copy
0.23 ms (0.03%)
1
SELECT j1 . idperson , j1 . lastname , j1 . firstname , j1 . url_clean , j1 . valid , j3 . idtext FROM theatreok_dev . persons j1 , theatreok_dev . text_author j2 , theatreok_dev . texts j3
WHERE j3 . idtext = j2 . idtext
AND j1 . idperson = j2 . idperson
AND j3 . idtext = 39371 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 = 39371 ORDER BY j2 . classement ASC ;
Copy
0.23 ms (0.02%)
1
SELECT COUNT (DISTINCT (podcasts . idpodcast )) as total , podcasts . *
FROM `podcast_contact` ,
`podcasts`
WHERE 1 AND podcasts . `publish` = 1 AND podcast_contact . `idcontact` = 656 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` = 656 AND podcasts . `code_ft` IS NOT NULL AND podcasts . `type_diffusion` = 1 AND podcasts . `idpodcast` = podcast_contact . `idpodcast`
;
Copy
0.23 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 = 28114 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 = 28114 ORDER BY j2 . classement ASC ;
Copy
0.22 ms (0.02%)
2
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 1
SELECT COUNT (contact_aide . `idaide` )
FROM aides
JOIN contact_aide ON contact_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 1 ;
Copy
0.22 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 = 26664 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 = 26664 ORDER BY j2 . classement ASC ;
Copy
0.22 ms (0.02%)
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 = 13030 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 = 13030 AND cc . idclassification = 125 LIMIT 1 ;
Copy
0.21 ms (0.02%)
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` = 656 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` = 656 AND aides . type_aide IN (2 , 3 ) ;
Copy
0.21 ms (0.02%)
2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 3
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 3 ;
Copy
0.21 ms (0.02%)
2
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 4
SELECT COUNT (spectacle_aide . `idaide` )
FROM aides
JOIN spectacle_aide ON spectacle_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 4 ;
Copy
0.21 ms (0.02%)
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 = 17466
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 = 17466
AND object_multimedia . object = 'spectacles' ORDER BY object_multimedia . ordermultimedia ;
Copy
0.20 ms (0.02%)
2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 3
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 3 ;
Copy
0.20 ms (0.02%)
2
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 4
SELECT COUNT (text_aide . `idaide` )
FROM aides
JOIN text_aide ON text_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 4 ;
Copy
0.20 ms (0.02%)
2
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 4
SELECT COUNT (person_aide . `idaide` )
FROM aides
JOIN person_aide ON person_aide . `idaide` = aides . `idaide`
WHERE aides . `idcontact` = 656
AND aides . `type_aide` = 4 ;
Copy
0.20 ms (0.02%)
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` = 31722 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` = 31722 AND d . code_franceinter IS NOT NULL ;
Copy
0.19 ms (0.02%)
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` = 29215 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` = 29215 AND d . code_franceinter IS NOT NULL ;
Copy
0.14 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.08 ms (0.01%)
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.07 ms (0.01%)
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.06 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.05 ms (0.01%)
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.05 ms (0.01%)
1
SELECT fr FROM countries WHERE id = 'FR'
SELECT fr FROM countries WHERE id = 'FR' ;
Copy
0.04 ms (0.00%)
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.03 ms (0.00%)
1
SELECT fr FROM languages WHERE id = 'fr'
SELECT fr FROM languages WHERE id = 'fr' ;
Copy