Symfony Profiler

Last 10 Latest Search
Settings
Query Metrics

279 Database Queries
223 Different statements
386.05 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts
Queries

Group similar statements

SELECT idmultimedia FROM multimedias WHERE url_clean='Conference-de-presse-de-presentation-du-76e-Festival-d-Avignon'
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 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=16354
                    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=16354
                    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=16354
                    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=16354
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 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=16354
                    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=16354
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 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=16354
                    AND object_multimedia.object='spectacles' 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=16354
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16354 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
SELECT  DISTINCT(dvds.iddvd), dvds.* 
FROM  `dvd_multimedia` ,
 `dvds`  
 WHERE 1  AND dvds.`publish`=1  AND dvd_multimedia.`idmultimedia` IN (16354) AND dvds.`iddvd`=dvd_multimedia.`iddvd` 
GROUP BY dvds.iddvd 
ORDER BY dvds.dateinsert 
DESC 
LIMIT 0,10
SELECT  DISTINCT(dvds.iddvd), dvds.* 
FROM  `dvd_multimedia` ,
 `dvds`  
 WHERE 1  AND dvds.`publish`=1  AND dvd_multimedia.`idmultimedia` IN (16354) AND dvds.`iddvd`=dvd_multimedia.`iddvd` 
GROUP BY dvds.iddvd 
ORDER BY dvds.dateinsert 
DESC 
LIMIT 0,10
SELECT COUNT(DISTINCT om.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND m.audio_video=2
                AND m.publish=1
                AND om.idobject=233
                AND om.object='contacts'
SELECT l.fr
                      FROM typesmultimedias tm,langterms l
                      WHERE tm.typemultimedia=l.id
                      AND tm.idtypemultimedia=0
SELECT fr FROM languages WHERE id='fr'
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=16354 AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=16354 AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=13655
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=30618
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=30916
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=44689
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=28382
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=23368
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=25932
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=101143
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=36625
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=62041
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=34754
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1636
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=14246
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=43432
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=42365
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=2226
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=2789
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=34985
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=81797
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=27926
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=90786
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=14593
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=73669
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=18242
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=80496
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=10502
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=18951
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=89481
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=68309
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=34902
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=54754
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=25669
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=90835
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=82828
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=24
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1921
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1252
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=413
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=101184
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=55469
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=12388
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=6304
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=2384
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=8253
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=16354 AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=16354 AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=24
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=59155
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=16354 AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=16354 AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
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 FROM contacts c0_ WHERE c0_.idcontact = ?
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=16354 ORDER BY object_multimedia.ordermultimedia
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=13655
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=24
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 FROM contacts c0_ WHERE c0_.idcontact = ?
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=59155
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=30618
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=30916
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=44689
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=28382
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=23368
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=25932
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=101143
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=36625
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=62041
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=34754
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1636
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=14246
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=43432
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=42365
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=2226
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=2789
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=34985
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=81797
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=27926
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=90786
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=14593
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=73669
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=18242
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=80496
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=10502
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=18951
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=89481
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=68309
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=34902
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=54754
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=25669
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=90835
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=82828
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=24
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1921
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1252
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=413
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=101184
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=55469
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=12388
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=6304
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=2384
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=8253
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=16354 AND object_multimedia.idrole IS NULL ORDER BY object_multimedia.ordermultimedia
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=13655
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=30618
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=30916
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=44689
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=28382
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=23368
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=25932
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=101143
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36625
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=62041
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=34754
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=1636
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=14246
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=43432
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=42365
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=2226
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=2789
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=34985
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=81797
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=27926
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=90786
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=14593
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=73669
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=18242
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=80496
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=10502
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=18951
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=89481
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=68309
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=34902
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=54754
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=25669
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=90835
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=82828
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=24
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=1921
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=1252
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=413
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=101184
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=55469
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=12388
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=6304
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=2384
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=8253
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=24
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=59155
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=233
                AND om.object='contacts'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=13655
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=24
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=233
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=59155
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=30618
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=30916
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=44689
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=28382
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=23368
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=25932
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=101143
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=36625
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=62041
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=34754
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=1636
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=14246
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=43432
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=42365
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=2226
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=2789
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=34985
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=81797
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=27926
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=90786
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=14593
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=73669
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=18242
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=80496
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=10502
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=18951
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=89481
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=68309
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=34902
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=54754
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=25669
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=90835
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=82828
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=1921
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=1252
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=413
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=101184
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=55469
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=12388
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=6304
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=2384
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=8253
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT * FROM multimedias
                WHERE idmultimedia IN (16672,8299,15353,7019,10484,5887)
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 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=5887
                    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=5887
                    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=5887
                    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=5887
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 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=5887
                    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=5887
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 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=5887
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=10150
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=10150
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=5887
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=5887 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
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 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=7019
                    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=7019
                    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=7019
                    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=7019
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 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=7019
                    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=7019
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 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=7019
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=14593
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=14593
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=7019
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=7019 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
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 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=8299
                    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=8299
                    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=8299
                    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=8299
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 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=8299
                    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=8299
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 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=8299
                    AND object_multimedia.object='spectacles' 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=8299
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=8299 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
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 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=10484
                    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=10484
                    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=10484
                    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=10484
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 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=10484
                    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=10484
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 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=10484
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=20749
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=20749
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=10484
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=10484 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
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 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=15353
                    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=15353
                    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=15353
                    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=15353
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 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=15353
                    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=15353
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 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=15353
                    AND object_multimedia.object='spectacles' 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=15353
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15353 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
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 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=16672
                    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=16672
                    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=16672
                    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=16672
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 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=16672
                    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=16672
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 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=16672
                    AND object_multimedia.object='spectacles' 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=16672
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16672 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
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
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

0 Hits
0 Misses
0 Puts
Entities Mapping

Class	Mapping errors
TheatreCore\Entity\Extranetusers	No errors.
TheatreCore\Entity\Multimedias	No errors.
TheatreCore\Entity\Typesmultimedias	No errors.
TheatreCore\Entity\Contacts	No errors.
TheatreCore\Entity\Dvds	No errors.
TheatreCore\Entity\Classifications	No errors.
TheatreCore\Entity\Keywords	No errors.
TheatreCore\Entity\Spectacles	No errors.
TheatreCore\Entity\Playlists	No errors.
TheatreCore\Entity\ObjectMultimedia	No errors.
TheatreCore\Entity\Persons	No errors.
TheatreCore\Entity\Contents	No errors.
TheatreCore\Entity\Texts	No errors.
TheatreCore\Entity\Abonnements	No errors.
TheatreCore\Entity\Bannieres	No errors.
Symfony Profiler

https://preprod.theatre-contemporain.net/video/Conference-de-presse-de-presentation-du-76e-Festival-d-Avignon?autostart=&path=video%2FConference-de-presse-de-presentation-du-76e-Festival-d-Avignon

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
