{"body":"    SELECT album.spotify_id AS album_id\n         , album.name AS album_name\n         , album.type AS album_type\n         , album.release_date AS release_date\n         , track.id AS track_id\n         , track.name AS track_name\n         , track.track_number AS track_number\n         , array_agg(ARRAY[artist.name, artist.spotify_id])\n      FROM spotify_cache.album album\n      JOIN spotify_cache.track track\n        ON album.spotify_id = track.album_id\n      JOIN spotify_cache.rel_track_artist rta\n        ON track.spotify_id = rta.track_id\n      JOIN spotify_cache.artist artist\n        ON rta.artist_id = artist.spotify_id\n  GROUP BY album.spotify_id\n         , album.name\n         , album.type\n         , album.release_date\n         , track.id\n         , track.name\n         , track.track_number\n  ORDER BY release_date\n         , album_type\n         , album_id\n         , track_number\n         , track_name;","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/mwewyo1Z","modified":1664985743,"id":"mwewyo1Z","size":910,"lines":27,"own_paste":false,"theme":"","date":1664985743}