16 lines
371 B
SQL
16 lines
371 B
SQL
SELECT
|
|
CASE
|
|
WHEN Folder.path LIKE 'file://%'
|
|
THEN SUBSTR(Folder.path, 8) || Media.filename
|
|
ELSE Folder.path || Media.filename
|
|
END AS full_path
|
|
FROM
|
|
Media
|
|
JOIN
|
|
Folder ON Folder.id_folder = Media.folder_id
|
|
WHERE
|
|
Media.id_media IN (
|
|
SELECT media_id
|
|
FROM PlaylistMediaRelation
|
|
WHERE playlist_id = 6
|
|
); |