Symfony Profiler

SELECT
  idspectacle
FROM
  spectacles
WHERE
  url_clean = 'Le-verso-des-images'

SELECT idspectacle FROM spectacles WHERE url_clean='Le-verso-des-images' ;

SELECT
  s0_.idspectacle AS idspectacle_0,
  s0_.title AS title_1,
  s0_.language AS language_2,
  s0_.creation_date AS creation_date_3,
  s0_.url_page AS url_page_4,
  s0_.infos AS infos_5,
  s0_.tag AS tag_6,
  s0_.id_rubrique AS id_rubrique_7,
  s0_.duration AS duration_8,
  s0_.interlude AS interlude_9,
  s0_.textfictif AS textfictif_10,
  s0_.url_redirect AS url_redirect_11,
  s0_.url_clean AS url_clean_12,
  s0_.dateupdate AS dateupdate_13,
  s0_.dateinsert AS dateinsert_14,
  s0_.publish AS publish_15,
  s0_.statut AS statut_16,
  s0_.valid AS valid_17,
  t1_.idtypespectacle AS idtypespectacle_18,
  c2_.idcontact AS idcontact_19,
  c2_.type AS type_20,
  c2_.organisation AS organisation_21,
  c2_.nom_suite AS nom_suite_22,
  c2_.lastname AS lastname_23,
  c2_.firstname AS firstname_24,
  c2_.idtypestructure AS idtypestructure_25,
  c2_.license AS license_26,
  c2_.comment AS comment_27,
  c2_.private_comment AS private_comment_28,
  c2_.address1 AS address1_29,
  c2_.address2 AS address2_30,
  c2_.zip AS zip_31,
  c2_.city AS city_32,
  c2_.phone1 AS phone1_33,
  c2_.phone2 AS phone2_34,
  c2_.fax AS fax_35,
  c2_.email1 AS email1_36,
  c2_.email1_online AS email1_online_37,
  c2_.email2_online AS email2_online_38,
  c2_.email2 AS email2_39,
  c2_.url AS url_40,
  c2_.url_ticket AS url_ticket_41,
  c2_.facebook AS facebook_42,
  c2_.twitter AS twitter_43,
  c2_.instagram AS instagram_44,
  c2_.mobile AS mobile_45,
  c2_.geocodable AS geocodable_46,
  c2_.x AS x_47,
  c2_.y AS y_48,
  c2_.idmultimedia AS idmultimedia_49,
  c2_.type_view AS type_view_50,
  c2_.stats_access AS stats_access_51,
  c2_.ga_tracking_id AS ga_tracking_id_52,
  c2_.is_festival AS is_festival_53,
  c2_.link_on_video AS link_on_video_54,
  c2_.is_partenaire AS is_partenaire_55,
  c2_.valid_version AS valid_version_56,
  c2_.other_versions AS other_versions_57,
  c2_.url_redirect AS url_redirect_58,
  c2_.url_clean AS url_clean_59,
  c2_.dateupdate AS dateupdate_60,
  c2_.dateinsert AS dateinsert_61,
  c2_.publish AS publish_62,
  c2_.valid AS valid_63,
  c3_.idcontact AS idcontact_64,
  c3_.type AS type_65,
  c3_.organisation AS organisation_66,
  c3_.nom_suite AS nom_suite_67,
  c3_.lastname AS lastname_68,
  c3_.firstname AS firstname_69,
  c3_.idtypestructure AS idtypestructure_70,
  c3_.license AS license_71,
  c3_.comment AS comment_72,
  c3_.private_comment AS private_comment_73,
  c3_.address1 AS address1_74,
  c3_.address2 AS address2_75,
  c3_.zip AS zip_76,
  c3_.city AS city_77,
  c3_.phone1 AS phone1_78,
  c3_.phone2 AS phone2_79,
  c3_.fax AS fax_80,
  c3_.email1 AS email1_81,
  c3_.email1_online AS email1_online_82,
  c3_.email2_online AS email2_online_83,
  c3_.email2 AS email2_84,
  c3_.url AS url_85,
  c3_.url_ticket AS url_ticket_86,
  c3_.facebook AS facebook_87,
  c3_.twitter AS twitter_88,
  c3_.instagram AS instagram_89,
  c3_.mobile AS mobile_90,
  c3_.geocodable AS geocodable_91,
  c3_.x AS x_92,
  c3_.y AS y_93,
  c3_.idmultimedia AS idmultimedia_94,
  c3_.type_view AS type_view_95,
  c3_.stats_access AS stats_access_96,
  c3_.ga_tracking_id AS ga_tracking_id_97,
  c3_.is_festival AS is_festival_98,
  c3_.link_on_video AS link_on_video_99,
  c3_.is_partenaire AS is_partenaire_100,
  c3_.valid_version AS valid_version_101,
  c3_.other_versions AS other_versions_102,
  c3_.url_redirect AS url_redirect_103,
  c3_.url_clean AS url_clean_104,
  c3_.dateupdate AS dateupdate_105,
  c3_.dateinsert AS dateinsert_106,
  c3_.publish AS publish_107,
  c3_.valid AS valid_108,
  e4_.idextranetuser AS idextranetuser_109
FROM
  spectacles s0_
  LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle
  LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact
  LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact
  LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser
WHERE
  s0_.idspectacle = ?

SELECT s0_.idspectacle AS idspectacle_0, s0_.title AS title_1, s0_.language AS language_2, s0_.creation_date AS creation_date_3, s0_.url_page AS url_page_4, s0_.infos AS infos_5, s0_.tag AS tag_6, s0_.id_rubrique AS id_rubrique_7, s0_.duration AS duration_8, s0_.interlude AS interlude_9, s0_.textfictif AS textfictif_10, s0_.url_redirect AS url_redirect_11, s0_.url_clean AS url_clean_12, s0_.dateupdate AS dateupdate_13, s0_.dateinsert AS dateinsert_14, s0_.publish AS publish_15, s0_.statut AS statut_16, s0_.valid AS valid_17, t1_.idtypespectacle AS idtypespectacle_18, c2_.idcontact AS idcontact_19, c2_.type AS type_20, c2_.organisation AS organisation_21, c2_.nom_suite AS nom_suite_22, c2_.lastname AS lastname_23, c2_.firstname AS firstname_24, c2_.idtypestructure AS idtypestructure_25, c2_.license AS license_26, c2_.comment AS comment_27, c2_.private_comment AS private_comment_28, c2_.address1 AS address1_29, c2_.address2 AS address2_30, c2_.zip AS zip_31, c2_.city AS city_32, c2_.phone1 AS phone1_33, c2_.phone2 AS phone2_34, c2_.fax AS fax_35, c2_.email1 AS email1_36, c2_.email1_online AS email1_online_37, c2_.email2_online AS email2_online_38, c2_.email2 AS email2_39, c2_.url AS url_40, c2_.url_ticket AS url_ticket_41, c2_.facebook AS facebook_42, c2_.twitter AS twitter_43, c2_.instagram AS instagram_44, c2_.mobile AS mobile_45, c2_.geocodable AS geocodable_46, c2_.x AS x_47, c2_.y AS y_48, c2_.idmultimedia AS idmultimedia_49, c2_.type_view AS type_view_50, c2_.stats_access AS stats_access_51, c2_.ga_tracking_id AS ga_tracking_id_52, c2_.is_festival AS is_festival_53, c2_.link_on_video AS link_on_video_54, c2_.is_partenaire AS is_partenaire_55, c2_.valid_version AS valid_version_56, c2_.other_versions AS other_versions_57, c2_.url_redirect AS url_redirect_58, c2_.url_clean AS url_clean_59, c2_.dateupdate AS dateupdate_60, c2_.dateinsert AS dateinsert_61, c2_.publish AS publish_62, c2_.valid AS valid_63, c3_.idcontact AS idcontact_64, c3_.type AS type_65, c3_.organisation AS organisation_66, c3_.nom_suite AS nom_suite_67, c3_.lastname AS lastname_68, c3_.firstname AS firstname_69, c3_.idtypestructure AS idtypestructure_70, c3_.license AS license_71, c3_.comment AS comment_72, c3_.private_comment AS private_comment_73, c3_.address1 AS address1_74, c3_.address2 AS address2_75, c3_.zip AS zip_76, c3_.city AS city_77, c3_.phone1 AS phone1_78, c3_.phone2 AS phone2_79, c3_.fax AS fax_80, c3_.email1 AS email1_81, c3_.email1_online AS email1_online_82, c3_.email2_online AS email2_online_83, c3_.email2 AS email2_84, c3_.url AS url_85, c3_.url_ticket AS url_ticket_86, c3_.facebook AS facebook_87, c3_.twitter AS twitter_88, c3_.instagram AS instagram_89, c3_.mobile AS mobile_90, c3_.geocodable AS geocodable_91, c3_.x AS x_92, c3_.y AS y_93, c3_.idmultimedia AS idmultimedia_94, c3_.type_view AS type_view_95, c3_.stats_access AS stats_access_96, c3_.ga_tracking_id AS ga_tracking_id_97, c3_.is_festival AS is_festival_98, c3_.link_on_video AS link_on_video_99, c3_.is_partenaire AS is_partenaire_100, c3_.valid_version AS valid_version_101, c3_.other_versions AS other_versions_102, c3_.url_redirect AS url_redirect_103, c3_.url_clean AS url_clean_104, c3_.dateupdate AS dateupdate_105, c3_.dateinsert AS dateinsert_106, c3_.publish AS publish_107, c3_.valid AS valid_108, e4_.idextranetuser AS idextranetuser_109 FROM spectacles s0_ LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser WHERE s0_.idspectacle = '33684';

SELECT
  t.title
FROM
  texts t,
  text_spectacle ts
WHERE
  t.idtext = ts.idtext
  AND ts.idspectacle = 33684

SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=33684;

SELECT
  lt.fr
FROM
  typesspectacles e,
  langterms lt
WHERE
  typespectacle = lt.id
  AND idtypespectacle = 4

SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4;

SELECT
  p.`idperson` as id,
  p.`idperson` as idperson,
  p.`lastname`,
  p.`firstname`,
  p.`url_clean`,
  p.`valid`,
  lt.`fr`,
  r.`idrole`,
  r.`role`,
  r.`type`,
  sp.`comment`,
  sp.`date_start`,
  sp.`date_end`
FROM
  persons p
  JOIN spectacle_person sp ON sp.`idperson` = p.`idperson`
  JOIN roles r ON r.`idrole` = sp.`idrole`
  JOIN langterms lt ON r.`role` = lt.`id`
WHERE
  sp.idspectacle = 33684
  AND r.type_creator = 1
ORDER BY
  sp.`classement`

SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
                        lt.`fr`,
                        r.`idrole`, r.`role`, r.`type`,
                        sp.`comment`,sp.`date_start`,sp.`date_end`
                        FROM persons p
                            JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
                            JOIN roles r ON r.`idrole`=sp.`idrole`
                            JOIN langterms lt ON r.`role`=lt.`id`
                        WHERE sp.idspectacle=33684  AND r.type_creator=1 ORDER BY sp.`classement` ;

SELECT
  p.`idperson` as id,
  p.`idperson` as idperson,
  p.`lastname`,
  p.`firstname`,
  p.`url_clean`,
  p.`valid`,
  lt.`fr`,
  r.`idrole`,
  r.`role`,
  r.`type`,
  sp.`comment`,
  sp.`date_start`,
  sp.`date_end`
FROM
  persons p
  JOIN spectacle_person sp ON sp.`idperson` = p.`idperson`
  JOIN roles r ON r.`idrole` = sp.`idrole`
  JOIN langterms lt ON r.`role` = lt.`id`
WHERE
  sp.idspectacle = 33684
  AND r.type_creator = 1
ORDER BY
  sp.`classement`

SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
                        lt.`fr`,
                        r.`idrole`, r.`role`, r.`type`,
                        sp.`comment`,sp.`date_start`,sp.`date_end`
                        FROM persons p
                            JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
                            JOIN roles r ON r.`idrole`=sp.`idrole`
                            JOIN langterms lt ON r.`role`=lt.`id`
                        WHERE sp.idspectacle=33684  AND r.type_creator=1 ORDER BY sp.`classement` ;

SELECT
  t.idtext,
  t.title,
  t.type,
  t.url_clean,
  t.textfictif
FROM
  texts t,
  text_spectacle ts
WHERE
  1
  AND ts.idspectacle = 33684
  AND t.idtext = ts.idtext

SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=33684
                AND t.idtext=ts.idtext;

SELECT
  DISTINCT(cl.type)
FROM
  classifications cl
WHERE
  (
    (
      cl.classification IN ('class_affiche_spec')
    )
  )
  AND spectacles = 1

SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_affiche_spec'))) AND spectacles=1;

SELECT
  *
FROM
  object_file of,
  files f,
  file_classification fc,
  classifications cl,
  typesfiles tf
WHERE
  of.idfile = f.idfile
  AND f.idfile = fc.idfile
  AND of.idobject = '33684'
  AND of.object = 'spectacles'
  AND cl.idclassification = fc.idclassification
  AND (
    (
      cl.classification IN ('class_affiche_spec')
    )
  )
  AND f.idtype = tf.idtype
ORDER BY
  f.`range`,
  f.idfile

SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='33684'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_affiche_spec'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  DISTINCT(multimedias.idmultimedia),
  multimedias.*
FROM
  `object_multimedia`,
  `multimedias`
WHERE
  1
  AND multimedias.`publish` = 1
  AND object_multimedia.`object` = 'spectacles'
  AND object_multimedia.`idobject` = 33684
  AND multimedias.`idmultimedia` = object_multimedia.`idmultimedia`
GROUP BY
  multimedias.idmultimedia
ORDER BY
  multimedias.dateinsert DESC
LIMIT
  0, 1000

SELECT  DISTINCT(multimedias.idmultimedia), multimedias.* 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1  AND multimedias.`publish`=1  AND object_multimedia.`object`='spectacles'  AND object_multimedia.`idobject`=33684 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.dateinsert 
DESC 
LIMIT 0,1000;

SELECT
  COUNT(*)
FROM
  information_schema.VIEWS
WHERE
  TABLE_SCHEMA = 'statistiques'
  AND TABLE_NAME = '20240427_days1'

SELECT COUNT(*)
                FROM information_schema.VIEWS 
                WHERE TABLE_SCHEMA = 'statistiques' 
                AND TABLE_NAME = '20240427_days1' ;

SELECT
  idmultimedia,
  COUNT(idmultimedia) as views
FROM
  statistiques.20240427_days1
WHERE
  idmultimedia NOT IN (
    5126, 6056, 11808, 11863, 11868, 11899,
    11895, 11897, 11901, 2024
  )
GROUP BY
  idmultimedia
ORDER BY
  COUNT(idmultimedia) DESC
LIMIT
  0, 4

SELECT idmultimedia, COUNT(idmultimedia) as views
                FROM statistiques.20240427_days1 WHERE idmultimedia NOT IN (5126,6056,11808,11863,11868,11899,11895,11897,11901,2024) GROUP BY idmultimedia
                ORDER BY COUNT(idmultimedia) DESC
                LIMIT 0,4;

SELECT
  DISTINCT(multimedias.idmultimedia),
  multimedias.*
FROM
  `multimedias`
WHERE
  1
  AND multimedias.`idmultimedia` IN (9930, 7116, 11914, 17972)
  AND multimedias.`publish` = 1
GROUP BY
  multimedias.idmultimedia
ORDER BY
  FIELD(
    multimedias.`idmultimedia`, 9930,
    7116, 11914, 17972
  )
LIMIT
  0, 4

SELECT  DISTINCT(multimedias.idmultimedia), multimedias.* 
FROM  `multimedias`  
 WHERE 1  AND multimedias.`idmultimedia` IN (9930,7116,11914,17972)  AND multimedias.`publish`=1 
GROUP BY multimedias.idmultimedia 
ORDER BY FIELD(multimedias.`idmultimedia`,9930,7116,11914,17972) 
  
LIMIT 0,4;

SELECT
  m0_.idmultimedia AS idmultimedia_0,
  m0_.idsupport AS idsupport_1,
  m0_.publish AS publish_2,
  m0_.status AS status_3,
  m0_.policy_access AS policy_access_4,
  m0_.support AS support_5,
  m0_.evenement AS evenement_6,
  m0_.sujet_titre AS sujet_titre_7,
  m0_.language AS language_8,
  m0_.markdown AS markdown_9,
  m0_.duree AS duree_10,
  m0_.date AS date_11,
  m0_.lieu AS lieu_12,
  m0_.particip_comed AS particip_comed_13,
  m0_.description AS description_14,
  m0_.use_cloud AS use_cloud_15,
  m0_.type_streaming AS type_streaming_16,
  m0_.mp3 AS mp3_17,
  m0_.hd2160 AS hd2160_18,
  m0_.hd1080 AS hd1080_19,
  m0_.upload AS upload_20,
  m0_.hd720 AS hd720_21,
  m0_.h264m AS h264m_22,
  m0_.h264 AS h264_23,
  m0_.flv AS flv_24,
  m0_.flv_width AS flv_width_25,
  m0_.flv_height AS flv_height_26,
  m0_.duree_site AS duree_site_27,
  m0_.duree_site_sec AS duree_site_sec_28,
  m0_.audio_video AS audio_video_29,
  m0_.filmeur AS filmeur_30,
  m0_.copyright AS copyright_31,
  m0_.etalab AS etalab_32,
  m0_.mots AS mots_33,
  m0_.tags AS tags_34,
  m0_.quality AS quality_35,
  m0_.url_clean AS url_clean_36,
  m0_.code AS code_37,
  m0_.fichier_local AS fichier_local_38,
  m0_.note_extranet AS note_extranet_39,
  m0_.note_extranetuser AS note_extranetuser_40,
  m0_.video_tete AS video_tete_41,
  m0_.avignondate AS avignondate_42,
  m0_.heywatch AS heywatch_43,
  m0_.is_coconut AS is_coconut_44,
  m0_.price AS price_45,
  m0_.count_view AS count_view_46,
  m0_.dateupdate AS dateupdate_47,
  m0_.dateinsert AS dateinsert_48,
  m0_.traite_comed AS traite_comed_49,
  m0_.traite_format AS traite_format_50,
  m0_.conversion_local AS conversion_local_51,
  m0_.idextranetuser_producteur AS idextranetuser_producteur_52,
  m0_.type AS type_53,
  m0_.idextranetuser AS idextranetuser_54,
  m0_.idcontact_producteur AS idcontact_producteur_55
FROM
  multimedias m0_
WHERE
  m0_.idmultimedia = ?

SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = '9930';

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 = 9930
  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=9930
                    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 = 9930
  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=9930
                    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 = 9930
  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=9930
                    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 = 9930
  AND object_multimedia.object = 'persons'
  AND object_multimedia.idrole = 25
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=9930
                    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 = 9930
  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=9930
                    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 = 9930
  AND object_multimedia.object = 'contacts'
  AND object_multimedia.idrole = 23
ORDER BY
  object_multimedia.ordermultimedia

SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=9930
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;