1325.36 ms (54.64%)
|
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_multimedia o9_ ON (s0_.idspectacle = o9_.idobject) LEFT JOIN multimedias m10_ ON (m10_.idmultimedia = o9_.idmultimedia) LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c11_ ON (c11_.idcontent = o2_.idcontent) LEFT JOIN content_classification c13_ ON c11_.idcontent = c13_.idcontent LEFT JOIN classifications c12_ ON c12_.idclassification = c13_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND o9_.object = 'spectacles' AND m10_.publish = 1 AND (c11_.valid = 1 AND c11_.publish = 1) AND c12_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c11_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 8 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_multimedia o9_ ON (s0_.idspectacle = o9_.idobject) LEFT JOIN multimedias m10_ ON (m10_.idmultimedia = o9_.idmultimedia) LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c11_ ON (c11_.idcontent = o2_.idcontent) LEFT JOIN content_classification c13_ ON c11_.idcontent = c13_.idcontent LEFT JOIN classifications c12_ ON c12_.idclassification = c13_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND o9_.object = 'spectacles' AND m10_.publish = 1 AND (c11_.valid = 1 AND c11_.publish = 1) AND c12_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c11_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 8 ORDER BY s1_.date ASC;
|
534.97 ms (22.05%)
|
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 8 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 8 ORDER BY s1_.date ASC;
|
165.21 ms (6.81%)
|
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 8 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 8 ORDER BY s1_.date ASC;
|
132.34 ms (5.46%)
|
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 8 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 8 ORDER BY s1_.date ASC;
|
43.97 ms (1.81%)
|
1 |
SELECT sc.`date`, YEAR(sc.`date`) as annee
FROM `schedules` sc
JOIN `spectacles` s ON sc.`idspectacle`=s.`idspectacle`
JOIN `text_spectacle` ts ON ts.`idspectacle`=s.`idspectacle`
JOIN `playlists` p ON p.`idtext`=ts.`idtext`
JOIN `playlist_classification` pc ON pc.`idplaylist`=p.`idplaylist`
WHERE 1
AND s.`textfictif`=0 AND s.`publish`=1 AND s.`valid`=1
AND p.`publish`=1
AND pc.`idclassification` IN (144)
AND sc.`date` > '1999-12-31'
ORDER BY sc.`date`
SELECT sc.`date`, YEAR(sc.`date`) as annee
FROM `schedules` sc
JOIN `spectacles` s ON sc.`idspectacle`=s.`idspectacle`
JOIN `text_spectacle` ts ON ts.`idspectacle`=s.`idspectacle`
JOIN `playlists` p ON p.`idtext`=ts.`idtext`
JOIN `playlist_classification` pc ON pc.`idplaylist`=p.`idplaylist`
WHERE 1
AND s.`textfictif`=0 AND s.`publish`=1 AND s.`valid`=1
AND p.`publish`=1
AND pc.`idclassification` IN (144)
AND sc.`date` > '1999-12-31'
ORDER BY sc.`date` ;
|
27.12 ms (1.12%)
|
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 8 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 8 ORDER BY s1_.date ASC;
|
26.29 ms (1.08%)
|
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 8 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 8 ORDER BY s1_.date ASC;
|
17.92 ms (0.74%)
|
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 8 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 8 ORDER BY s1_.date ASC;
|
15.15 ms (0.62%)
|
2 |
SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=8
SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=8;
|
14.31 ms (0.59%)
|
1 |
SELECT COUNT(DISTINCT t0_.idtext) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s2_ LEFT JOIN text_spectacle t3_ ON s2_.idspectacle = t3_.idspectacle LEFT JOIN texts t0_ ON t0_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s2_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s2_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN playlists p8_ ON (p8_.idtext = t0_.idtext) INNER JOIN playlist_classification p10_ ON p8_.idplaylist = p10_.idplaylist INNER JOIN classifications c9_ ON c9_.idclassification = p10_.idclassification WHERE s2_.textfictif = 0 AND c9_.idclassification IN (144) AND p8_.publish = 1 AND s1_.idspectacle = s2_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND t0_.idcontact_publisher = 8 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT t0_.idtext) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s2_ LEFT JOIN text_spectacle t3_ ON s2_.idspectacle = t3_.idspectacle LEFT JOIN texts t0_ ON t0_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s2_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s2_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN playlists p8_ ON (p8_.idtext = t0_.idtext) INNER JOIN playlist_classification p10_ ON p8_.idplaylist = p10_.idplaylist INNER JOIN classifications c9_ ON c9_.idclassification = p10_.idclassification WHERE s2_.textfictif = 0 AND c9_.idclassification IN (144) AND p8_.publish = 1 AND s1_.idspectacle = s2_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-28' AND '2025-04-28')) AND t0_.idcontact_publisher = 8 ORDER BY s1_.date ASC;
|
10.17 ms (0.42%)
|
18 |
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 = ?
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 = '8998';
|
7.78 ms (0.32%)
|
1 |
SELECT COUNT(DISTINCT(T1.idperson)) as total FROM persons T1
JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
JOIN texts t ON t.`idtext`=T2.`idtext`
WHERE 1 AND t.`idcontact_publisher` IN ('8') AND T1.`publish`=1
SELECT COUNT(DISTINCT(T1.idperson)) as total FROM persons T1
JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
JOIN texts t ON t.`idtext`=T2.`idtext`
WHERE 1 AND t.`idcontact_publisher` IN ('8') AND T1.`publish`=1 ;
|
4.37 ms (0.18%)
|
1 |
SELECT DISTINCT(T1.idperson), T1.lastname,T1.firstname,T1.url_clean FROM persons T1
JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
JOIN texts t ON t.`idtext`=T2.`idtext`
WHERE 1 AND t.`idcontact_publisher` IN ('8') AND T1.`publish`=1 GROUP BY T1.idperson ORDER BY T1.lastname ASC
SELECT DISTINCT(T1.idperson), T1.lastname,T1.firstname,T1.url_clean FROM persons T1
JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
JOIN texts t ON t.`idtext`=T2.`idtext`
WHERE 1 AND t.`idcontact_publisher` IN ('8') AND T1.`publish`=1 GROUP BY T1.idperson ORDER BY T1.lastname ASC ;
|
4.35 ms (0.18%)
|
2 |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (14,19,25,52,56,157,159,288,290,711,902,1140,1171,1232,1311,1477,1630,1780,1802,1909,1910,1940,1983,2027,2073,2135,2143,2187,2258,2278,2313,2387,2433,2434,2462,2480,2541,2621,2640,2641,2642,2875,2963,2972,3024,3031,3085,3111,3124,3143,3175,3184,3232,3356,3386,3508,3580,3627,3745,3787,3934,4116,4117,4380,4439,4634,4635,4637,4638,4640,4762,5116,5175,5222,5223,5224,5225,5380,5549,5589,5802,6031,6052,6055,6056,6057,6113,6225,6281,6333,6346,7087,7254,7636,7947,7949,7967,7991,8046,8096,8153,8233,8239,8503,8599,8629,8647,8656,8657,8658,8659,8808,8862,9025,9096,9197,9230,9231,9517,9622,9775,10004,10005,10006,10007,10102,10320,10917,11042,11065,11143,11189,11239,12159,12819,13137,13651,13939,14280,14792,14812,14877,15046,15047,15664,15666,15736,15853,15854,16296,18012,18142,18564,18650,18721,19176,21091,21286,21311,22675,23806,23829,23859,23988,24649,25671,26208,26238,28003,28102,30296,30340,30396,32176,32561,32929,33383,34389,35445,35766,36125,36379,37039,39927,40424,41318,42492,42715,43181,44997) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
SELECT
COUNT(
DISTINCT(T1.`idtext`)
) as total
FROM
texts T1
LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
1
AND T1.`idtext` IN (
14,
19,
25,
52,
56,
157,
159,
288,
290,
711,
902,
1140,
1171,
1232,
1311,
1477,
1630,
1780,
1802,
1909,
1910,
1940,
1983,
2027,
2073,
2135,
2143,
2187,
2258,
2278,
2313,
2387,
2433,
2434,
2462,
2480,
2541,
2621,
2640,
2641,
2642,
2875,
2963,
2972,
3024,
3031,
3085,
3111,
3124,
3143,
3175,
3184,
3232,
3356,
3386,
3508,
3580,
3627,
3745,
3787,
3934,
4116,
4117,
4380,
4439,
4634,
4635,
4637,
4638,
4640,
4762,
5116,
5175,
5222,
5223,
5224,
5225,
5380,
5549,
5589,
5802,
6031,
6052,
6055,
6056,
6057,
6113,
6225,
6281,
6333,
6346,
7087,
7254,
7636,
7947,
7949,
7967,
7991,
8046,
8096,
8153,
8233,
8239,
8503,
8599,
8629,
8647,
8656,
8657,
8658,
8659,
8808,
8862,
9025,
9096,
9197,
9230,
9231,
9517,
9622,
9775,
10004,
10005,
10006,
10007,
10102,
10320,
10917,
11042,
11065,
11143,
11189,
11239,
12159,
12819,
13137,
13651,
13939,
14280,
14792,
14812,
14877,
15046,
15047,
15664,
15666,
15736,
15853,
15854,
16296,
18012,
18142,
18564,
18650,
18721,
19176,
21091,
21286,
21311,
22675,
23806,
23829,
23859,
23988,
24649,
25671,
26208,
26238,
28003,
28102,
30296,
30340,
30396,
32176,
32561,
32929,
33383,
34389,
35445,
35766,
36125,
36379,
37039,
39927,
40424,
41318,
42492,
42715,
43181,
44997
)
ORDER BY
CAST(
CONCAT(
T1.`publication_year`, '-', T1.`publication_month`,
'-00'
) AS DATE
) ASC
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (14,19,25,52,56,157,159,288,290,711,902,1140,1171,1232,1311,1477,1630,1780,1802,1909,1910,1940,1983,2027,2073,2135,2143,2187,2258,2278,2313,2387,2433,2434,2462,2480,2541,2621,2640,2641,2642,2875,2963,2972,3024,3031,3085,3111,3124,3143,3175,3184,3232,3356,3386,3508,3580,3627,3745,3787,3934,4116,4117,4380,4439,4634,4635,4637,4638,4640,4762,5116,5175,5222,5223,5224,5225,5380,5549,5589,5802,6031,6052,6055,6056,6057,6113,6225,6281,6333,6346,7087,7254,7636,7947,7949,7967,7991,8046,8096,8153,8233,8239,8503,8599,8629,8647,8656,8657,8658,8659,8808,8862,9025,9096,9197,9230,9231,9517,9622,9775,10004,10005,10006,10007,10102,10320,10917,11042,11065,11143,11189,11239,12159,12819,13137,13651,13939,14280,14792,14812,14877,15046,15047,15664,15666,15736,15853,15854,16296,18012,18142,18564,18650,18721,19176,21091,21286,21311,22675,23806,23829,23859,23988,24649,25671,26208,26238,28003,28102,30296,30340,30396,32176,32561,32929,33383,34389,35445,35766,36125,36379,37039,39927,40424,41318,42492,42715,43181,44997) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;
|
3.70 ms (0.15%)
|
1 |
SELECT COUNT(DISTINCT t0_.idtext) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s2_ LEFT JOIN text_spectacle t3_ ON s2_.idspectacle = t3_.idspectacle LEFT JOIN texts t0_ ON t0_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s2_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s2_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN playlists p8_ ON (p8_.idtext = t0_.idtext) INNER JOIN playlist_classification p10_ ON p8_.idplaylist = p10_.idplaylist INNER JOIN classifications c9_ ON c9_.idclassification = p10_.idclassification WHERE s2_.textfictif = 0 AND c9_.idclassification IN (144) AND p8_.publish = 1 AND s1_.idspectacle = s2_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND t0_.idcontact_publisher = 8 ORDER BY s1_.date ASC
SELECT COUNT(DISTINCT t0_.idtext) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s2_ LEFT JOIN text_spectacle t3_ ON s2_.idspectacle = t3_.idspectacle LEFT JOIN texts t0_ ON t0_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s2_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s2_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN playlists p8_ ON (p8_.idtext = t0_.idtext) INNER JOIN playlist_classification p10_ ON p8_.idplaylist = p10_.idplaylist INNER JOIN classifications c9_ ON c9_.idclassification = p10_.idclassification WHERE s2_.textfictif = 0 AND c9_.idclassification IN (144) AND p8_.publish = 1 AND s1_.idspectacle = s2_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND t0_.idcontact_publisher = 8 ORDER BY s1_.date ASC;
|
3.51 ms (0.14%)
|
1 |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1,contacts T2 WHERE 1 AND T2.idcontact=T1.idcontact_publisher AND T1.idcontact_publisher=8 ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1,contacts T2 WHERE 1 AND T2.idcontact=T1.idcontact_publisher AND T1.idcontact_publisher=8 ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;
|
2.61 ms (0.11%)
|
2 |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (958,1068,1081,1189,1435,1509,1552,1555,1556,1634,1779,1842,1843,1999,2000,2026,2306,2393,2438,2551,2596,2634,2635,2695,3077,3099,3130,3157,3224,3227,3250,3340,3371,3604,3612,3647,3683,3695,4013,4027,4128,4190,4223,4232,4531,4881,5150,5158,5163,5266,6002,6266,6552,6589,6631,6750,6771,6786,6963,7073,7516,7560,7965,8120,8142,8455,8730,8731,8987,9063,9313,9424,9602,9828,9888,10240,10319,10398,10481,10639,10640,10649,11044,11145,11146,11581,12083,12520,12522,14199,15403,15650,16544,16597,16602,17500,17630,18780,19860,20858,20861,21138,21531,22243,22244,22433,23315,23316,23389,23465,23841,23997,24745,24746,25872,26935,27194,27465,27909,29220,31679,32227,32325,34702,35193,35451,37176,37205,37266,37372,38037,38088,38367,39236,39543,39654,40055,40200,40575,41267,41348,41495,41615,41961,43161,43162,43164,43195,43238,43256,44296,45223,45259,45535) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
SELECT
COUNT(
DISTINCT(T1.`idtext`)
) as total
FROM
texts T1
LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
1
AND T1.`idtext` IN (
958,
1068,
1081,
1189,
1435,
1509,
1552,
1555,
1556,
1634,
1779,
1842,
1843,
1999,
2000,
2026,
2306,
2393,
2438,
2551,
2596,
2634,
2635,
2695,
3077,
3099,
3130,
3157,
3224,
3227,
3250,
3340,
3371,
3604,
3612,
3647,
3683,
3695,
4013,
4027,
4128,
4190,
4223,
4232,
4531,
4881,
5150,
5158,
5163,
5266,
6002,
6266,
6552,
6589,
6631,
6750,
6771,
6786,
6963,
7073,
7516,
7560,
7965,
8120,
8142,
8455,
8730,
8731,
8987,
9063,
9313,
9424,
9602,
9828,
9888,
10240,
10319,
10398,
10481,
10639,
10640,
10649,
11044,
11145,
11146,
11581,
12083,
12520,
12522,
14199,
15403,
15650,
16544,
16597,
16602,
17500,
17630,
18780,
19860,
20858,
20861,
21138,
21531,
22243,
22244,
22433,
23315,
23316,
23389,
23465,
23841,
23997,
24745,
24746,
25872,
26935,
27194,
27465,
27909,
29220,
31679,
32227,
32325,
34702,
35193,
35451,
37176,
37205,
37266,
37372,
38037,
38088,
38367,
39236,
39543,
39654,
40055,
40200,
40575,
41267,
41348,
41495,
41615,
41961,
43161,
43162,
43164,
43195,
43238,
43256,
44296,
45223,
45259,
45535
)
ORDER BY
CAST(
CONCAT(
T1.`publication_year`, '-', T1.`publication_month`,
'-00'
) AS DATE
) ASC
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1
LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` WHERE 1 AND T1.`idtext` IN (958,1068,1081,1189,1435,1509,1552,1555,1556,1634,1779,1842,1843,1999,2000,2026,2306,2393,2438,2551,2596,2634,2635,2695,3077,3099,3130,3157,3224,3227,3250,3340,3371,3604,3612,3647,3683,3695,4013,4027,4128,4190,4223,4232,4531,4881,5150,5158,5163,5266,6002,6266,6552,6589,6631,6750,6771,6786,6963,7073,7516,7560,7965,8120,8142,8455,8730,8731,8987,9063,9313,9424,9602,9828,9888,10240,10319,10398,10481,10639,10640,10649,11044,11145,11146,11581,12083,12520,12522,14199,15403,15650,16544,16597,16602,17500,17630,18780,19860,20858,20861,21138,21531,22243,22244,22433,23315,23316,23389,23465,23841,23997,24745,24746,25872,26935,27194,27465,27909,29220,31679,32227,32325,34702,35193,35451,37176,37205,37266,37372,38037,38088,38367,39236,39543,39654,40055,40200,40575,41267,41348,41495,41615,41961,43161,43162,43164,43195,43238,43256,44296,45223,45259,45535) ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;
|
2.49 ms (0.10%)
|
2 |
SELECT DISTINCT(playlists.idplaylist), playlists.*
FROM `playlist_classification` ,
`playlists`
WHERE 1 AND playlists.`publish`=1 AND playlists.`idperson` IN (18259,27992,87354,80,12699,2158,32821,85835,2560,24218,63362,42465,1992,60399,29830,1107,97991,2626,47059,26755,44640,12685,20986,23244,11601,13598,19296,2497,27600,24860,88396,15245,67419,1979,31922,15110,52686,8755,2126,35193,75048,632,68687,14921,98875,10,83610,12414,58909,29116,33243,14203,68977,3893,49832,60609,63821,10365,13691,2420,78468,86242,2612,39813,12,21065,57009,72062,13988,60179,2602,10371,43229,83373,49123,29808,65913,22513,57782,24217,24654,5299,80807,12032,8943,44341,98699,5099,4546,15400,44792,37065,710,76262,1336,93329,240,34884,73,34043,83133,371,103741,4315,52075,34477,86447,28713,93963,23376,33822,20727,15,16630,60599,2794,12025,6008,4321,34051,1353,18818,6358,21494,47,2731,2636,90434,21829,12350,21883,1271,603,64020,56918,1376,376,35051,56098,11584,5606,46702,95278,80675,94244,57314,502,32350,30903,62120,2625,70767,67930,52508,374,34445,8264,1886,54292,2849,9959,45949,16329,16964,373,13468,17051,1087,57975,542,40596,1659,1060,63305,33502,100109,36348,21392,2423,2383,365,64172,25761,4925,46833,25,1671,1407,48875,21103,1408,22138,28478,871,26194,1847,1412,884,29248,83574,28,1674,12361,25660,2095,30631,83505,24655,25612,1780,54436,24029,12942,33668,21272,2312,23500,82001,1928,5671,1658) AND playlist_classification.`idclassification` IN (116) AND playlists.`idplaylist`=playlist_classification.`idplaylist`
GROUP BY playlists.idplaylist
ORDER BY FIELD(playlists.`idperson`,18259,27992,87354,80,12699,2158,32821,85835,2560,24218,63362,42465,1992,60399,29830,1107,97991,2626,47059,26755,44640,12685,20986,23244,11601,13598,19296,2497,27600,24860,88396,15245,67419,1979,31922,15110,52686,8755,2126,35193,75048,632,68687,14921,98875,10,83610,12414,58909,29116,33243,14203,68977,3893,49832,60609,63821,10365,13691,2420,78468,86242,2612,39813,12,21065,57009,72062,13988,60179,2602,10371,43229,83373,49123,29808,65913,22513,57782,24217,24654,5299,80807,12032,8943,44341,98699,5099,4546,15400,44792,37065,710,76262,1336,93329,240,34884,73,34043,83133,371,103741,4315,52075,34477,86447,28713,93963,23376,33822,20727,15,16630,60599,2794,12025,6008,4321,34051,1353,18818,6358,21494,47,2731,2636,90434,21829,12350,21883,1271,603,64020,56918,1376,376,35051,56098,11584,5606,46702,95278,80675,94244,57314,502,32350,30903,62120,2625,70767,67930,52508,374,34445,8264,1886,54292,2849,9959,45949,16329,16964,373,13468,17051,1087,57975,542,40596,1659,1060,63305,33502,100109,36348,21392,2423,2383,365,64172,25761,4925,46833,25,1671,1407,48875,21103,1408,22138,28478,871,26194,1847,1412,884,29248,83574,28,1674,12361,25660,2095,30631,83505,24655,25612,1780,54436,24029,12942,33668,21272,2312,23500,82001,1928,5671,1658)
LIMIT 0,200
SELECT
DISTINCT(playlists.idplaylist),
playlists.*
FROM
`playlist_classification`,
`playlists`
WHERE
1
AND playlists.`publish` = 1
AND playlists.`idperson` IN (
18259,
27992,
87354,
80,
12699,
2158,
32821,
85835,
2560,
24218,
63362,
42465,
1992,
60399,
29830,
1107,
97991,
2626,
47059,
26755,
44640,
12685,
20986,
23244,
11601,
13598,
19296,
2497,
27600,
24860,
88396,
15245,
67419,
1979,
31922,
15110,
52686,
8755,
2126,
35193,
75048,
632,
68687,
14921,
98875,
10,
83610,
12414,
58909,
29116,
33243,
14203,
68977,
3893,
49832,
60609,
63821,
10365,
13691,
2420,
78468,
86242,
2612,
39813,
12,
21065,
57009,
72062,
13988,
60179,
2602,
10371,
43229,
83373,
49123,
29808,
65913,
22513,
57782,
24217,
24654,
5299,
80807,
12032,
8943,
44341,
98699,
5099,
4546,
15400,
44792,
37065,
710,
76262,
1336,
93329,
240,
34884,
73,
34043,
83133,
371,
103741,
4315,
52075,
34477,
86447,
28713,
93963,
23376,
33822,
20727,
15,
16630,
60599,
2794,
12025,
6008,
4321,
34051,
1353,
18818,
6358,
21494,
47,
2731,
2636,
90434,
21829,
12350,
21883,
1271,
603,
64020,
56918,
1376,
376,
35051,
56098,
11584,
5606,
46702,
95278,
80675,
94244,
57314,
502,
32350,
30903,
62120,
2625,
70767,
67930,
52508,
374,
34445,
8264,
1886,
54292,
2849,
9959,
45949,
16329,
16964,
373,
13468,
17051,
1087,
57975,
542,
40596,
1659,
1060,
63305,
33502,
100109,
36348,
21392,
2423,
2383,
365,
64172,
25761,
4925,
46833,
25,
1671,
1407,
48875,
21103,
1408,
22138,
28478,
871,
26194,
1847,
1412,
884,
29248,
83574,
28,
1674,
12361,
25660,
2095,
30631,
83505,
24655,
25612,
1780,
54436,
24029,
12942,
33668,
21272,
2312,
23500,
82001,
1928,
5671,
1658
)
AND playlist_classification.`idclassification` IN (116)
AND playlists.`idplaylist` = playlist_classification.`idplaylist`
GROUP BY
playlists.idplaylist
ORDER BY
FIELD(
playlists.`idperson`,
18259,
27992,
87354,
80,
12699,
2158,
32821,
85835,
2560,
24218,
63362,
42465,
1992,
60399,
29830,
1107,
97991,
2626,
47059,
26755,
44640,
12685,
20986,
23244,
11601,
13598,
19296,
2497,
27600,
24860,
88396,
15245,
67419,
1979,
31922,
15110,
52686,
8755,
2126,
35193,
75048,
632,
68687,
14921,
98875,
10,
83610,
12414,
58909,
29116,
33243,
14203,
68977,
3893,
49832,
60609,
63821,
10365,
13691,
2420,
78468,
86242,
2612,
39813,
12,
21065,
57009,
72062,
13988,
60179,
2602,
10371,
43229,
83373,
49123,
29808,
65913,
22513,
57782,
24217,
24654,
5299,
80807,
12032,
8943,
44341,
98699,
5099,
4546,
15400,
44792,
37065,
710,
76262,
1336,
93329,
240,
34884,
73,
34043,
83133,
371,
103741,
4315,
52075,
34477,
86447,
28713,
93963,
23376,
33822,
20727,
15,
16630,
60599,
2794,
12025,
6008,
4321,
34051,
1353,
18818,
6358,
21494,
47,
2731,
2636,
90434,
21829,
12350,
21883,
1271,
603,
64020,
56918,
1376,
376,
35051,
56098,
11584,
5606,
46702,
95278,
80675,
94244,
57314,
502,
32350,
30903,
62120,
2625,
70767,
67930,
52508,
374,
34445,
8264,
1886,
54292,
2849,
9959,
45949,
16329,
16964,
373,
13468,
17051,
1087,
57975,
542,
40596,
1659,
1060,
63305,
33502,
100109,
36348,
21392,
2423,
2383,
365,
64172,
25761,
4925,
46833,
25,
1671,
1407,
48875,
21103,
1408,
22138,
28478,
871,
26194,
1847,
1412,
884,
29248,
83574,
28,
1674,
12361,
25660,
2095,
30631,
83505,
24655,
25612,
1780,
54436,
24029,
12942,
33668,
21272,
2312,
23500,
82001,
1928,
5671,
1658
)
LIMIT
0, 200
SELECT DISTINCT(playlists.idplaylist), playlists.*
FROM `playlist_classification` ,
`playlists`
WHERE 1 AND playlists.`publish`=1 AND playlists.`idperson` IN (18259,27992,87354,80,12699,2158,32821,85835,2560,24218,63362,42465,1992,60399,29830,1107,97991,2626,47059,26755,44640,12685,20986,23244,11601,13598,19296,2497,27600,24860,88396,15245,67419,1979,31922,15110,52686,8755,2126,35193,75048,632,68687,14921,98875,10,83610,12414,58909,29116,33243,14203,68977,3893,49832,60609,63821,10365,13691,2420,78468,86242,2612,39813,12,21065,57009,72062,13988,60179,2602,10371,43229,83373,49123,29808,65913,22513,57782,24217,24654,5299,80807,12032,8943,44341,98699,5099,4546,15400,44792,37065,710,76262,1336,93329,240,34884,73,34043,83133,371,103741,4315,52075,34477,86447,28713,93963,23376,33822,20727,15,16630,60599,2794,12025,6008,4321,34051,1353,18818,6358,21494,47,2731,2636,90434,21829,12350,21883,1271,603,64020,56918,1376,376,35051,56098,11584,5606,46702,95278,80675,94244,57314,502,32350,30903,62120,2625,70767,67930,52508,374,34445,8264,1886,54292,2849,9959,45949,16329,16964,373,13468,17051,1087,57975,542,40596,1659,1060,63305,33502,100109,36348,21392,2423,2383,365,64172,25761,4925,46833,25,1671,1407,48875,21103,1408,22138,28478,871,26194,1847,1412,884,29248,83574,28,1674,12361,25660,2095,30631,83505,24655,25612,1780,54436,24029,12942,33668,21272,2312,23500,82001,1928,5671,1658) AND playlist_classification.`idclassification` IN (116) AND playlists.`idplaylist`=playlist_classification.`idplaylist`
GROUP BY playlists.idplaylist
ORDER BY FIELD(playlists.`idperson`,18259,27992,87354,80,12699,2158,32821,85835,2560,24218,63362,42465,1992,60399,29830,1107,97991,2626,47059,26755,44640,12685,20986,23244,11601,13598,19296,2497,27600,24860,88396,15245,67419,1979,31922,15110,52686,8755,2126,35193,75048,632,68687,14921,98875,10,83610,12414,58909,29116,33243,14203,68977,3893,49832,60609,63821,10365,13691,2420,78468,86242,2612,39813,12,21065,57009,72062,13988,60179,2602,10371,43229,83373,49123,29808,65913,22513,57782,24217,24654,5299,80807,12032,8943,44341,98699,5099,4546,15400,44792,37065,710,76262,1336,93329,240,34884,73,34043,83133,371,103741,4315,52075,34477,86447,28713,93963,23376,33822,20727,15,16630,60599,2794,12025,6008,4321,34051,1353,18818,6358,21494,47,2731,2636,90434,21829,12350,21883,1271,603,64020,56918,1376,376,35051,56098,11584,5606,46702,95278,80675,94244,57314,502,32350,30903,62120,2625,70767,67930,52508,374,34445,8264,1886,54292,2849,9959,45949,16329,16964,373,13468,17051,1087,57975,542,40596,1659,1060,63305,33502,100109,36348,21392,2423,2383,365,64172,25761,4925,46833,25,1671,1407,48875,21103,1408,22138,28478,871,26194,1847,1412,884,29248,83574,28,1674,12361,25660,2095,30631,83505,24655,25612,1780,54436,24029,12942,33668,21272,2312,23500,82001,1928,5671,1658)
LIMIT 0,200;
|
2.01 ms (0.08%)
|
1 |
SELECT tt.idtext FROM text_traduction tt, texts t
WHERE t.idtext=tt.idtext
AND (t.idgenretext=1 OR t.idgenretext IS NULL)
AND tt.idtexttraduction IN (958,1068,1081,1189,1435,1509,1552,1555,1556,1634,1779,1842,1843,1999,2000,2026,2306,2393,2438,2551,2596,2634,2635,2695,3077,3099,3130,3157,3224,3227,3250,3340,3371,3604,3612,3647,3683,3695,4013,4027,4128,4190,4223,4232,4531,4881,5150,5158,5163,5266,6002,6266,6552,6589,6631,6750,6771,6786,6963,7073,7516,7560,7965,8120,8142,8455,8730,8731,8987,9063,9313,9424,9602,9828,9888,10240,10319,10398,10481,10639,10640,10649,11044,11145,11146,11581,12083,12520,12522,14199,15403,15650,16544,16597,16602,17500,17630,18780,19860,20858,20861,21138,21531,22243,22244,22433,23315,23316,23389,23465,23841,23997,24745,24746,25872,26935,27194,27465,27909,29220,31679,32227,32325,34702,35193,35451,37176,37205,37266,37372,38037,38088,38367,39236,39543,39654,40055,40200,40575,41267,41348,41495,41615,41961,43161,43162,43164,43195,43238,43256,44296,45223,45259,45535)
SELECT
tt.idtext
FROM
text_traduction tt,
texts t
WHERE
t.idtext = tt.idtext
AND (
t.idgenretext = 1
OR t.idgenretext IS NULL
)
AND tt.idtexttraduction IN (
958,
1068,
1081,
1189,
1435,
1509,
1552,
1555,
1556,
1634,
1779,
1842,
1843,
1999,
2000,
2026,
2306,
2393,
2438,
2551,
2596,
2634,
2635,
2695,
3077,
3099,
3130,
3157,
3224,
3227,
3250,
3340,
3371,
3604,
3612,
3647,
3683,
3695,
4013,
4027,
4128,
4190,
4223,
4232,
4531,
4881,
5150,
5158,
5163,
5266,
6002,
6266,
6552,
6589,
6631,
6750,
6771,
6786,
6963,
7073,
7516,
7560,
7965,
8120,
8142,
8455,
8730,
8731,
8987,
9063,
9313,
9424,
9602,
9828,
9888,
10240,
10319,
10398,
10481,
10639,
10640,
10649,
11044,
11145,
11146,
11581,
12083,
12520,
12522,
14199,
15403,
15650,
16544,
16597,
16602,
17500,
17630,
18780,
19860,
20858,
20861,
21138,
21531,
22243,
22244,
22433,
23315,
23316,
23389,
23465,
23841,
23997,
24745,
24746,
25872,
26935,
27194,
27465,
27909,
29220,
31679,
32227,
32325,
34702,
35193,
35451,
37176,
37205,
37266,
37372,
38037,
38088,
38367,
39236,
39543,
39654,
40055,
40200,
40575,
41267,
41348,
41495,
41615,
41961,
43161,
43162,
43164,
43195,
43238,
43256,
44296,
45223,
45259,
45535
)
SELECT tt.idtext FROM text_traduction tt, texts t
WHERE t.idtext=tt.idtext
AND (t.idgenretext=1 OR t.idgenretext IS NULL)
AND tt.idtexttraduction IN (958,1068,1081,1189,1435,1509,1552,1555,1556,1634,1779,1842,1843,1999,2000,2026,2306,2393,2438,2551,2596,2634,2635,2695,3077,3099,3130,3157,3224,3227,3250,3340,3371,3604,3612,3647,3683,3695,4013,4027,4128,4190,4223,4232,4531,4881,5150,5158,5163,5266,6002,6266,6552,6589,6631,6750,6771,6786,6963,7073,7516,7560,7965,8120,8142,8455,8730,8731,8987,9063,9313,9424,9602,9828,9888,10240,10319,10398,10481,10639,10640,10649,11044,11145,11146,11581,12083,12520,12522,14199,15403,15650,16544,16597,16602,17500,17630,18780,19860,20858,20861,21138,21531,22243,22244,22433,23315,23316,23389,23465,23841,23997,24745,24746,25872,26935,27194,27465,27909,29220,31679,32227,32325,34702,35193,35451,37176,37205,37266,37372,38037,38088,38367,39236,39543,39654,40055,40200,40575,41267,41348,41495,41615,41961,43161,43162,43164,43195,43238,43256,44296,45223,45259,45535);
|
1.99 ms (0.08%)
|
1 |
SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=8
SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=8;
|
1.48 ms (0.06%)
|
2 |
SELECT * FROM bannieres
WHERE publish=1
AND valid=1
AND is_bottom=1
AND date_start<=NOW()
AND date_end>=NOW()
ORDER BY bannieres.order ASC
LIMIT 0,10
SELECT * FROM bannieres
WHERE publish=1
AND valid=1
AND is_bottom=1
AND date_start<=NOW()
AND date_end>=NOW()
ORDER BY bannieres.order ASC
LIMIT 0,10;
|
1.20 ms (0.05%)
|
5 |
SELECT p0_.idplaylist AS idplaylist_0, p0_.title AS title_1, p0_.description AS description_2, p0_.url_clean AS url_clean_3, p0_.dateupdate AS dateupdate_4, p0_.dateinsert AS dateinsert_5, p0_.publish AS publish_6, p0_.valid AS valid_7 FROM playlists p0_ WHERE p0_.idplaylist = ?
SELECT p0_.idplaylist AS idplaylist_0, p0_.title AS title_1, p0_.description AS description_2, p0_.url_clean AS url_clean_3, p0_.dateupdate AS dateupdate_4, p0_.dateinsert AS dateinsert_5, p0_.publish AS publish_6, p0_.valid AS valid_7 FROM playlists p0_ WHERE p0_.idplaylist = '321';
|
0.99 ms (0.04%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=8998
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=8998
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.96 ms (0.04%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=9003
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=9003
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.95 ms (0.04%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=13642
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=13642
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.93 ms (0.04%)
|
1 |
SELECT COUNT(DISTINCT(T1.idnew)) as total FROM news T1 INNER JOIN newschedules T3
ON T3.idnew=T1.idnew
INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=8 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND (( T3.date>='2024-04-28' ))
SELECT COUNT(DISTINCT(T1.idnew)) as total FROM news T1 INNER JOIN newschedules T3
ON T3.idnew=T1.idnew
INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=8 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND (( T3.date>='2024-04-28' )) ;
|
0.92 ms (0.04%)
|
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='8'
AND of.object='contacts'
AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (100))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT *
FROM object_file of,
files f,
file_classification fc,
classifications cl,typesfiles tf
WHERE of.idfile=f.idfile
AND f.idfile=fc.idfile
AND of.idobject='8'
AND of.object='contacts'
AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (100))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;
|
0.90 ms (0.04%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=13642
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=13642
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.87 ms (0.04%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=13642
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=13642
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.87 ms (0.04%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=8999
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=8999
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.86 ms (0.04%)
|
1 |
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (8998,9002,8999,9003) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,8998,9002,8999,9003)
LIMIT 0,10
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (8998,9002,8999,9003) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,8998,9002,8999,9003)
LIMIT 0,10;
|
0.84 ms (0.03%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=11081
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=11081
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.81 ms (0.03%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13642
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=13642
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.78 ms (0.03%)
|
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='8'
AND of.object='contacts'
AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT *
FROM object_file of,
files f,
file_classification fc,
classifications cl,typesfiles tf
WHERE of.idfile=f.idfile
AND f.idfile=fc.idfile
AND of.idobject='8'
AND of.object='contacts'
AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;
|
0.69 ms (0.03%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=1664
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=1664
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.66 ms (0.03%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13642
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=13642
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.65 ms (0.03%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=1644
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=1644
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.65 ms (0.03%)
|
1 |
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (11085,11084,11081,11079) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,11085,11084,11081,11079)
LIMIT 0,10
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (11085,11084,11081,11079) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,11085,11084,11081,11079)
LIMIT 0,10;
|
0.64 ms (0.03%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=13642 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=13642 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.64 ms (0.03%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=13674
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=13674
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.64 ms (0.03%)
|
1 |
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (13642,13674,13675) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,13642,13674,13675)
LIMIT 0,10
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (13642,13674,13675) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,13642,13674,13675)
LIMIT 0,10;
|
0.63 ms (0.03%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13642
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=13642
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.63 ms (0.03%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=7638
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=7638
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.62 ms (0.03%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11085
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=11085
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.60 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=7640
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=7640
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.60 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=1644
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=1644
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.59 ms (0.02%)
|
1 |
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (1644,1664,1665,1666) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,1644,1664,1665,1666)
LIMIT 0,10
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (1644,1664,1665,1666) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,1644,1664,1665,1666)
LIMIT 0,10;
|
0.59 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=1665
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=1665
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.58 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=1666
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=1666
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.58 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=9002
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=9002
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.58 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=7639
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=7639
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.58 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13642
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=13642
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.57 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=8998
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=8998
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.57 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=9003
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=9003
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.57 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13674
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=13674
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.55 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=9003
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=9003
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.55 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1665
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=1665
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.54 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13674
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=13674
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.53 ms (0.02%)
|
1 |
SELECT COUNT(DISTINCT(T1.idnew)) as total FROM news T1 INNER JOIN newschedules T3
ON T3.idnew=T1.idnew
INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=8 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND (( T3.date<'2024-04-28' ))
SELECT COUNT(DISTINCT(T1.idnew)) as total FROM news T1 INNER JOIN newschedules T3
ON T3.idnew=T1.idnew
INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=8 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND (( T3.date<'2024-04-28' )) ;
|
0.51 ms (0.02%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=762 ORDER BY j2.`orderplaylist`
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=762 ORDER BY j2.`orderplaylist` ;
|
0.50 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=13642
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=13642
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.49 ms (0.02%)
|
1 |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=171
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=171;
|
0.49 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=9002
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=9002
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.49 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=13674
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=13674
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.49 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=8998
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=8998
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.48 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=8998
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=8998
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.46 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=9003
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=9003
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.45 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1666
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=1666
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.45 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=9003
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=9003
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.45 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11081
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=11081
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.44 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1665
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=1665
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.44 ms (0.02%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=7638 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=7638 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.43 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1644
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=1644
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.43 ms (0.02%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=8998 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=8998 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.43 ms (0.02%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=1664 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=1664 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.42 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1664
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=1664
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.42 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=8999
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=8999
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.42 ms (0.02%)
|
2 |
SELECT COUNT(DISTINCT(m.idmultimedia))
FROM object_multimedia om, multimedias m
WHERE om.idmultimedia=m.idmultimedia
AND om.idobject=8
AND om.object='contacts'
AND m.publish=1 AND m.audio_video=2
SELECT COUNT(DISTINCT(m.idmultimedia))
FROM object_multimedia om, multimedias m
WHERE om.idmultimedia=m.idmultimedia
AND om.idobject=8
AND om.object='contacts'
AND m.publish=1 AND m.audio_video=2;
|
0.41 ms (0.02%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=321 ORDER BY j2.`orderplaylist`
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=321 ORDER BY j2.`orderplaylist` ;
|
0.41 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=7638
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=7638
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.41 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13674
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=13674
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.40 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=9002
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=9002
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.40 ms (0.02%)
|
2 |
SELECT COUNT(DISTINCT(of.idfile)) as total
FROM object_file of,
files f,
file_classification fc,
classifications cl,typesfiles tf
WHERE of.idfile=f.idfile
AND f.idfile=fc.idfile
AND of.idobject='8'
AND of.object='contacts'
AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (112,168))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT COUNT(DISTINCT(of.idfile)) as total
FROM object_file of,
files f,
file_classification fc,
classifications cl,typesfiles tf
WHERE of.idfile=f.idfile
AND f.idfile=fc.idfile
AND of.idobject='8'
AND of.object='contacts'
AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (112,168))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype;
|
0.40 ms (0.02%)
|
1 |
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=762
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=762;
|
0.40 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=13674
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=13674
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.40 ms (0.02%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=9003 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=9003 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.40 ms (0.02%)
|
1 |
SELECT c0_.idcontact AS idcontact_0, c0_.type AS type_1, c0_.organisation AS organisation_2, c0_.nom_suite AS nom_suite_3, c0_.lastname AS lastname_4, c0_.firstname AS firstname_5, c0_.idtypestructure AS idtypestructure_6, c0_.license AS license_7, c0_.comment AS comment_8, c0_.private_comment AS private_comment_9, c0_.address1 AS address1_10, c0_.address2 AS address2_11, c0_.zip AS zip_12, c0_.city AS city_13, c0_.phone1 AS phone1_14, c0_.phone2 AS phone2_15, c0_.fax AS fax_16, c0_.email1 AS email1_17, c0_.email1_online AS email1_online_18, c0_.email2_online AS email2_online_19, c0_.email2 AS email2_20, c0_.url AS url_21, c0_.url_ticket AS url_ticket_22, c0_.facebook AS facebook_23, c0_.twitter AS twitter_24, c0_.instagram AS instagram_25, c0_.mobile AS mobile_26, c0_.geocodable AS geocodable_27, c0_.x AS x_28, c0_.y AS y_29, c0_.idmultimedia AS idmultimedia_30, c0_.type_view AS type_view_31, c0_.stats_access AS stats_access_32, c0_.ga_tracking_id AS ga_tracking_id_33, c0_.is_festival AS is_festival_34, c0_.link_on_video AS link_on_video_35, c0_.is_partenaire AS is_partenaire_36, c0_.valid_version AS valid_version_37, c0_.other_versions AS other_versions_38, c0_.url_redirect AS url_redirect_39, c0_.url_clean AS url_clean_40, c0_.dateupdate AS dateupdate_41, c0_.dateinsert AS dateinsert_42, c0_.publish AS publish_43, c0_.valid AS valid_44, c1_.id AS id_45, c1_.fr AS fr_46, c1_.en AS en_47, c1_.es AS es_48, c1_.pt AS pt_49, c1_.de AS de_50, c1_.ru AS ru_51, c1_.orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_.country = c1_.id WHERE c0_.idcontact = ?
SELECT
c0_.idcontact AS idcontact_0,
c0_.type AS type_1,
c0_.organisation AS organisation_2,
c0_.nom_suite AS nom_suite_3,
c0_.lastname AS lastname_4,
c0_.firstname AS firstname_5,
c0_.idtypestructure AS idtypestructure_6,
c0_.license AS license_7,
c0_.comment AS comment_8,
c0_.private_comment AS private_comment_9,
c0_.address1 AS address1_10,
c0_.address2 AS address2_11,
c0_.zip AS zip_12,
c0_.city AS city_13,
c0_.phone1 AS phone1_14,
c0_.phone2 AS phone2_15,
c0_.fax AS fax_16,
c0_.email1 AS email1_17,
c0_.email1_online AS email1_online_18,
c0_.email2_online AS email2_online_19,
c0_.email2 AS email2_20,
c0_.url AS url_21,
c0_.url_ticket AS url_ticket_22,
c0_.facebook AS facebook_23,
c0_.twitter AS twitter_24,
c0_.instagram AS instagram_25,
c0_.mobile AS mobile_26,
c0_.geocodable AS geocodable_27,
c0_.x AS x_28,
c0_.y AS y_29,
c0_.idmultimedia AS idmultimedia_30,
c0_.type_view AS type_view_31,
c0_.stats_access AS stats_access_32,
c0_.ga_tracking_id AS ga_tracking_id_33,
c0_.is_festival AS is_festival_34,
c0_.link_on_video AS link_on_video_35,
c0_.is_partenaire AS is_partenaire_36,
c0_.valid_version AS valid_version_37,
c0_.other_versions AS other_versions_38,
c0_.url_redirect AS url_redirect_39,
c0_.url_clean AS url_clean_40,
c0_.dateupdate AS dateupdate_41,
c0_.dateinsert AS dateinsert_42,
c0_.publish AS publish_43,
c0_.valid AS valid_44,
c1_.id AS id_45,
c1_.fr AS fr_46,
c1_.en AS en_47,
c1_.es AS es_48,
c1_.pt AS pt_49,
c1_.de AS de_50,
c1_.ru AS ru_51,
c1_.orderby AS orderby_52
FROM
contacts c0_
LEFT JOIN countries c1_ ON c0_.country = c1_.id
WHERE
c0_.idcontact = ?
SELECT c0_.idcontact AS idcontact_0, c0_.type AS type_1, c0_.organisation AS organisation_2, c0_.nom_suite AS nom_suite_3, c0_.lastname AS lastname_4, c0_.firstname AS firstname_5, c0_.idtypestructure AS idtypestructure_6, c0_.license AS license_7, c0_.comment AS comment_8, c0_.private_comment AS private_comment_9, c0_.address1 AS address1_10, c0_.address2 AS address2_11, c0_.zip AS zip_12, c0_.city AS city_13, c0_.phone1 AS phone1_14, c0_.phone2 AS phone2_15, c0_.fax AS fax_16, c0_.email1 AS email1_17, c0_.email1_online AS email1_online_18, c0_.email2_online AS email2_online_19, c0_.email2 AS email2_20, c0_.url AS url_21, c0_.url_ticket AS url_ticket_22, c0_.facebook AS facebook_23, c0_.twitter AS twitter_24, c0_.instagram AS instagram_25, c0_.mobile AS mobile_26, c0_.geocodable AS geocodable_27, c0_.x AS x_28, c0_.y AS y_29, c0_.idmultimedia AS idmultimedia_30, c0_.type_view AS type_view_31, c0_.stats_access AS stats_access_32, c0_.ga_tracking_id AS ga_tracking_id_33, c0_.is_festival AS is_festival_34, c0_.link_on_video AS link_on_video_35, c0_.is_partenaire AS is_partenaire_36, c0_.valid_version AS valid_version_37, c0_.other_versions AS other_versions_38, c0_.url_redirect AS url_redirect_39, c0_.url_clean AS url_clean_40, c0_.dateupdate AS dateupdate_41, c0_.dateinsert AS dateinsert_42, c0_.publish AS publish_43, c0_.valid AS valid_44, c1_.id AS id_45, c1_.fr AS fr_46, c1_.en AS en_47, c1_.es AS es_48, c1_.pt AS pt_49, c1_.de AS de_50, c1_.ru AS ru_51, c1_.orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_.country = c1_.id WHERE c0_.idcontact = '8';
|
0.40 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1665
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=1665
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.39 ms (0.02%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=11079 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=11079 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.39 ms (0.02%)
|
1 |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=321
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=321;
|
0.39 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=9002
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=9002
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.39 ms (0.02%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=11085 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=11085 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.39 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=9003
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=9003
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.38 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=1664
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=1664
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.38 ms (0.02%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=563 ORDER BY j2.`orderplaylist`
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=563 ORDER BY j2.`orderplaylist` ;
|
0.38 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=9003
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=9003
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.38 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=8998
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=8998
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.37 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=8999
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=8999
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.37 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=7638
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=7638
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.37 ms (0.02%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13675
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=13675
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.36 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=13674 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=13674 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.36 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1644
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=1644
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.35 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=8998
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=8998
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.35 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11079
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=11079
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.35 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=1666
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=1666
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.35 ms (0.01%)
|
1 |
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=3
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=3 ;
|
0.35 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=8999
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=8999
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.35 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=1665
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=1665
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.35 ms (0.01%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=762
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=762;
|
0.34 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=9003
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=9003
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.34 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13674
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=13674
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.34 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=9002
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=9002
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.34 ms (0.01%)
|
1 |
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (7638,7639,7640) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,7638,7639,7640)
LIMIT 0,10
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*
FROM `multimedias`
WHERE 1 AND multimedias.`idmultimedia` IN (7638,7639,7640) AND multimedias.`publish`=1
GROUP BY multimedias.idmultimedia
ORDER BY FIELD(multimedias.`idmultimedia`,7638,7639,7640)
LIMIT 0,10;
|
0.33 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1644
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=1644
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.33 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7638
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=7638
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.33 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=9002
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=9002
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.32 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7640
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=7640
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.32 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13675
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=13675
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.32 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=8998
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=8998
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.31 ms (0.01%)
|
1 |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=563
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=563;
|
0.31 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=9002
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=9002
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.30 ms (0.01%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=13 ORDER BY j2.`orderplaylist`
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=13 ORDER BY j2.`orderplaylist` ;
|
0.30 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=8998
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=8998
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.30 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7638
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=7638
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.30 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=9002
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=9002
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.30 ms (0.01%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=321
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=321;
|
0.29 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=13675
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=13675
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.29 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=8999
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=8999
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.29 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=9002 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=9002 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.29 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=13674
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=13674
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.28 ms (0.01%)
|
1 |
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=4
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=4 ;
|
0.28 ms (0.01%)
|
1 |
SELECT idcontact FROM contacts WHERE url_clean='Gallimard-Editions'
SELECT idcontact FROM contacts WHERE url_clean='Gallimard-Editions' ;
|
0.28 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11085
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=11085
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.27 ms (0.01%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=762
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=762;
|
0.27 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=1644
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=1644
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.27 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=8999
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=8999
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.26 ms (0.01%)
|
1 |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=762
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=762;
|
0.26 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11084
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=11084
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.26 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1664
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=1664
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.26 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=11085
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=11085
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.26 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=11084
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=11084
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.26 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=7639
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=7639
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.26 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=13675
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=13675
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.26 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13675
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=13675
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.26 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=11085
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=11085
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.26 ms (0.01%)
|
1 |
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=2
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=2 ;
|
0.25 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11081
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=11081
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.25 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11079
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=11079
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.25 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=1644 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=1644 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.25 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1666
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=1666
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.25 ms (0.01%)
|
1 |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=13
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idplaylist FROM theatreok_dev.classifications j1, theatreok_dev.playlist_classification j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idclassification=j2.idclassification
AND j3.idplaylist=13;
|
0.25 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=11085
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=11085
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.25 ms (0.01%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=13
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=13;
|
0.24 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=11081
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=11081
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.24 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7639
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=7639
AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia ;
|
0.24 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7640
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=7640
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.24 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=7640
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=7640
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.24 ms (0.01%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=13
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=13;
|
0.23 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=13675
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=13675
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.23 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11081
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=11081
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.23 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=1666
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=1666
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.23 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1644
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=1644
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.23 ms (0.01%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=321
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=321;
|
0.23 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=1666 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=1666 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.23 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1664
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=1664
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.23 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=7639
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=7639
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.23 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=13675
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=13675
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=11079
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=11079
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=1666
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=1666
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=11081
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=11081
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=11085
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=11085
AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=11084 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=11084 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=1664
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=1664
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=11079
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=11079
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=8999
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=8999
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11079
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=11079
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=171 ORDER BY j2.`orderplaylist`
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.idplaylist FROM theatreok_dev.multimedias j1, theatreok_dev.playlist_multimedia j2, theatreok_dev.playlists j3
WHERE j3.idplaylist=j2.idplaylist
AND j1.idmultimedia=j2.idmultimedia
AND j3.idplaylist=171 ORDER BY j2.`orderplaylist` ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=11084
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=11084
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7639
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=7639
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11084
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=11084
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7638
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=7638
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7639
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=7639
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=1644
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=1644
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.22 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11084
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=11084
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1666
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=1666
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7640
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=7640
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=1665
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=1665
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=11081 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=11081 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.21 ms (0.01%)
|
1 |
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=2
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=2 ;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1664
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=1664
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=1665
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=1665
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=1
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=1 ;
|
0.21 ms (0.01%)
|
1 |
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=171
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=171;
|
0.21 ms (0.01%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=762
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=762;
|
0.21 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=8999 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=8999 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
FROM object_multimedia, contacts
WHERE object_multimedia.idobject=contacts.idcontact
AND object_multimedia.idmultimedia=11084
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=11084
AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11084
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=11084
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11085
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=11085
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=1665 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=1665 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.21 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=7640 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=7640 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11081
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=11081
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=11081
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=11081
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=7639 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=7639 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=7640
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=7640
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7638
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=7638
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.21 ms (0.01%)
|
1 |
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=321
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=321;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=8999
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=8999
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=11079
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=11079
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.20 ms (0.01%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=321
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=321;
|
0.20 ms (0.01%)
|
1 |
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=13675 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10
SELECT DISTINCT(keywords.idkeyword), keywords.*
FROM `multimedia_keyword` ,
`keywords`
WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=13675 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword`
GROUP BY keywords.idkeyword
ORDER BY keywords.dateinsert
DESC
LIMIT 0,10;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=1664
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=1664
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1665
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=1665
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11079
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=11079
AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia ;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7640
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=7640
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=7640
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=7640
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=7639
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=7639
AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia ;
|
0.20 ms (0.01%)
|
1 |
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=3
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=3 ;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=11085
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=11085
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.20 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=13675
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
FROM object_multimedia, texts
WHERE object_multimedia.idobject=texts.idtext
AND object_multimedia.idmultimedia=13675
AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia ;
|
0.19 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=7638
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=7638
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.19 ms (0.01%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=563
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=563;
|
0.19 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=11084
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=11084
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.19 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
FROM object_multimedia, persons
WHERE object_multimedia.idobject=persons.idperson
AND object_multimedia.idmultimedia=1666
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=1666
AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia ;
|
0.18 ms (0.01%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=563
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=563;
|
0.18 ms (0.01%)
|
1 |
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=4
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=4 ;
|
0.18 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=11079
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=11079
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.18 ms (0.01%)
|
1 |
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=1
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=1 ;
|
0.18 ms (0.01%)
|
1 |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=7639
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
FROM object_multimedia, spectacles
WHERE object_multimedia.idobject=spectacles.idspectacle
AND object_multimedia.idmultimedia=7639
AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia ;
|
0.17 ms (0.01%)
|
1 |
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=2
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=2 ;
|
0.17 ms (0.01%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=13
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=13;
|
0.17 ms (0.01%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=563
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=563;
|
0.17 ms (0.01%)
|
1 |
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=4
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=4 ;
|
0.16 ms (0.01%)
|
1 |
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=4
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=4 ;
|
0.16 ms (0.01%)
|
1 |
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=13
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=13;
|
0.16 ms (0.01%)
|
1 |
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=3
SELECT COUNT(contact_aide.`idaide`)
FROM aides
JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=3 ;
|
0.16 ms (0.01%)
|
1 |
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=2
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=2 ;
|
0.16 ms (0.01%)
|
1 |
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=563
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.texts j1, theatreok_dev.playlists j3
WHERE j1.idtext=j3.idtext
AND j3.idplaylist=563;
|
0.15 ms (0.01%)
|
1 |
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=1
SELECT COUNT(text_aide.`idaide`)
FROM aides
JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=1 ;
|
0.15 ms (0.01%)
|
1 |
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=1
SELECT COUNT(spectacle_aide.`idaide`)
FROM aides
JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=1 ;
|
0.14 ms (0.01%)
|
1 |
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=3
SELECT COUNT(person_aide.`idaide`)
FROM aides
JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
WHERE aides.`idcontact`=8
AND aides.`type_aide`=3 ;
|
0.14 ms (0.01%)
|
2 |
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND contacts=1 AND lagarce!=1 AND is_public IN (1)
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND contacts=1 AND lagarce!=1 AND is_public IN (1) ;
|
0.13 ms (0.01%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=171
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idplaylist FROM theatreok_dev.spectacles j1, theatreok_dev.playlists j3
WHERE j1.idspectacle=j3.idspectacle
AND j3.idplaylist=171;
|
0.13 ms (0.01%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=171
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idplaylist FROM theatreok_dev.contacts j1, theatreok_dev.playlists j3
WHERE j1.idcontact=j3.idcontact
AND j3.idplaylist=171;
|
0.12 ms (0.01%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=171
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idplaylist FROM theatreok_dev.persons j1, theatreok_dev.playlists j3
WHERE j1.idperson=j3.idperson
AND j3.idplaylist=171;
|
0.10 ms (0.00%)
|
1 |
SELECT fr FROM countries WHERE id='France'
SELECT fr FROM countries WHERE id='France';
|
0.05 ms (0.00%)
|
1 |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=1;
|
0.05 ms (0.00%)
|
1 |
SELECT fr FROM countries WHERE id='FR'
SELECT fr FROM countries WHERE id='FR';
|
0.05 ms (0.00%)
|
1 |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (100))) AND contacts=1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (100))) AND contacts=1;
|