Re: achievable with the means of SQL?

[laptop alias]

SELECT t1.display_id,t1.fs_path,t2.fs_path
FROM playlist_items t1
LEFT JOIN playlist_items t2 ON t1.display_id+1 = t2.display_id
WHERE t1.list_id=123 AND t1.display_id>=12
LIMIT 10;