Untitled

SELECT ma.artist_id, a.artist_name_capitalization, ma.id, ma.album_name_capitalization, la.YEAR,
d1.path, f1.filename, d2.path, f2.filename, ai.largeimageurl, tr.track_ids FROM
(SELECT lt.album_id AS album_id, array_agg(lt.id ORDER BY COALESCE(ft.disc_nr, 1)*100 + COALESCE(ft.track_nr, 0)) AS track_ids
FROM library.track lt
INNER JOIN music.album ma ON lt.album_id = ma.id
INNER JOIN library.filetag ft ON ft.file_id = lt.file_id
WHERE ft.artist_id = 1536 GROUP BY lt.album_id) tr
INNER JOIN library.album la ON la.album_id = tr.album_id
INNER JOIN music.album ma ON la.album_id = ma.id
INNER JOIN music.artist a ON ma.artist_id = a.id
LEFT OUTER JOIN library.file f1 ON f1.id = la.embeddedcoverartfile_id
LEFT OUTER JOIN library.directory d1 ON f1.directory_id = d1.id
LEFT OUTER JOIN library.file f2 ON f2.id = la.coverartfile_id
LEFT OUTER JOIN library.directory d2 ON f2.directory_id = d2.id
LEFT OUTER JOIN music.albuminfo ai ON ai.album_id = la.album_id
ORDER BY (ma.artist_id = 1536) DESC, la.YEAR DESC;