gistfile1.php

SELECT kfm.id,
       n.title,
       kvu.file_and_folder,
       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 file_and_folder;