gistfile1.sql

SELECT kfm.id                                     AS id,
       IF(n.title IS NOT NULL, n.title, kfm.name) AS title,
       Concat("Source_Video/", kvu.file_name)     AS video,
       IF(n.title IS NOT NULL, "/kaltura import",
       "/kaltura_import,/no g365 node id")
       AS labels,
       kfm.id                                     AS "metadata:kaltura_id"
FROM   kaltura_full_metadata kfm
       LEFT JOIN node_kaltura nk
         ON kfm.id = nk.kaltura_entryid
       LEFT JOIN node n
         ON nk.nid = n.nid
       LEFT JOIN kaltura_video_and_audio_urls kvu
         ON kfm.id = kvu.entry_id
WHERE  kfm.media_type = 1
   AND kvu.is_original = true
ORDER  BY video