Symfony Profiler

Last 10 Latest Search
Settings
Query Metrics

318 Database Queries
256 Different statements
306.81 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='Theatre-du-Rond-Point-presentation-de-saison-2020-2021'
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=14323
                    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=14323
                    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=14323
                    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=14323
                    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=14323
                    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=14323
                    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=14323
                    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=14323
                    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`=14323 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 (14323) 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 (14323) 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=459
                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=14323 AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14323 AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14323 AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14323 AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=238
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=4236
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=75569
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=90183
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=17929
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=886
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=809
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=16
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=90250
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=36291
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=54162
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=84751
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1381
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1921
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=24171
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=68534
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=18977
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=47135
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=35588
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=256
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=21919
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=10951
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=456
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=21432
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=6350
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=20790
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1995
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=7808
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=5075
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=399
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=847
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=145
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=6443
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=8722
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=84620
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=69660
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=6071
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=5893
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=5254
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=12694
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=7746
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=18254
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=9894
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1717
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1879
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=27529
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=21031
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1659
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=24909
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=14709
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=30
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=27959
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1620
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=5349
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14323 AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14323 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=14323 ORDER BY object_multimedia.ordermultimedia
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=238
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=4236
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=75569
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=90183
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=17929
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=886
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=809
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=16
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=90250
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=36291
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=54162
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=84751
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1381
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1921
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=24171
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=68534
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=18977
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=47135
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=35588
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=256
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=21919
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=10951
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=456
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=21432
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=6350
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=20790
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1995
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=7808
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=5075
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=399
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=847
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=145
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=6443
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=8722
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=84620
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=69660
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=6071
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=5893
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=5254
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=12694
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=7746
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=18254
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=9894
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1717
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1879
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=27529
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=21031
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1659
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=24909
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=14709
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=30
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=27959
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=1620
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=5349
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14323 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=238
                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=4236
                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=75569
                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=90183
                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=17929
                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=886
                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=809
                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=16
                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=90250
                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=36291
                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=54162
                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=84751
                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=1381
                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=24171
                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=68534
                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=18977
                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=47135
                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=35588
                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=256
                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=21919
                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=10951
                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=456
                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=21432
                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=6350
                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=20790
                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=1995
                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=7808
                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=5075
                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=399
                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=847
                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=145
                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=6443
                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=8722
                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=84620
                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=69660
                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=6071
                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=5893
                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=5254
                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=12694
                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=7746
                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=18254
                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=9894
                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=1717
                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=1879
                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=27529
                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=21031
                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=1659
                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=24909
                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=14709
                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=30
                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=27959
                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=1620
                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=5349
                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=459
                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=238
                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=459
                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=4236
                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=75569
                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=90183
                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=17929
                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=886
                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=809
                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=16
                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=90250
                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=36291
                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=54162
                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=84751
                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=1381
                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=24171
                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=68534
                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=18977
                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=47135
                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=35588
                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=256
                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=21919
                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=10951
                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=456
                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=21432
                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=6350
                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=20790
                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=1995
                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=7808
                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=5075
                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=399
                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=847
                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=145
                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=6443
                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=8722
                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=84620
                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=69660
                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=6071
                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=5893
                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=5254
                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=12694
                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=7746
                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=18254
                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=9894
                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=1717
                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=1879
                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=27529
                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=21031
                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=1659
                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=24909
                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=14709
                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=30
                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=27959
                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=1620
                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=5349
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
SELECT * FROM multimedias
                WHERE idmultimedia IN (17657,8938,161,6779,2039,8152)
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=161
                    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=161
                    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=161
                    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=161
                    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=161
                    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=161
                    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=161
                    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=161
                    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`=161 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=2039
                    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=2039
                    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=2039
                    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=2039
                    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=2039
                    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=2039
                    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=2039
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=4236
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=4236
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=2039
                    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`=2039 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=6779
                    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=6779
                    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=6779
                    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=6779
                    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=6779
                    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=6779
                    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=6779
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=9793
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=9793
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=9214
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=9214
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=6779
                    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`=6779 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=8152
                    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=8152
                    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=8152
                    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=8152
                    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=8152
                    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=8152
                    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=8152
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=16202
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=16202
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=8152
                    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`=8152 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=8938
                    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=8938
                    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=8938
                    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=8938
                    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=8938
                    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=8938
                    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=8938
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=15273
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=15273
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=8938
                    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`=8938 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=17657
                    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=17657
                    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=17657
                    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=17657
                    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=17657
                    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=17657
                    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=17657
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=35588
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=35588
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=17657
                    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`=17657 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/Theatre-du-Rond-Point-presentation-de-saison-2020-2021?autostart=&path=video%2FTheatre-du-Rond-Point-presentation-de-saison-2020-2021

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
