# Pastebin mwewyo1Z
    SELECT album.spotify_id AS album_id
         , album.name AS album_name
         , album.type AS album_type
         , album.release_date AS release_date
         , track.id AS track_id
         , track.name AS track_name
         , track.track_number AS track_number
         , array_agg(ARRAY[artist.name, artist.spotify_id])
      FROM spotify_cache.album album
      JOIN spotify_cache.track track
        ON album.spotify_id = track.album_id
      JOIN spotify_cache.rel_track_artist rta
        ON track.spotify_id = rta.track_id
      JOIN spotify_cache.artist artist
        ON rta.artist_id = artist.spotify_id
  GROUP BY album.spotify_id
         , album.name
         , album.type
         , album.release_date
         , track.id
         , track.name
         , track.track_number
  ORDER BY release_date
         , album_type
         , album_id
         , track_number
         , track_name;