# Pastebin xcnkA7fm
SELECT ac.id as artist_credit_id,
              r.name AS recording_name,
              r.gid AS recording_mbid,
              ac.name AS artist_credit_name,
              s.artist_mbids,
              rl.name AS release_name,
              rl.gid AS release_mbid,
              rpr.id AS score
         FROM recording r
         JOIN artist_credit ac
           ON r.artist_credit = ac.id
         JOIN artist_credit_name acn
           ON ac.id = acn.artist_credit
         JOIN artist a
           ON acn.artist = a.id
         JOIN track t
           ON t.recording = r.id
         JOIN medium m
           ON m.id = t.medium
         JOIN release rl
           ON rl.id = m.release
         JOIN mapping.mbid_mapping_releases rpr
           ON rl.id = rpr.release
         JOIN (SELECT artist_credit, array_agg(gid) AS artist_mbids
                 FROM artist_credit_name acn2
                 JOIN artist a2
                   ON acn2.artist = a2.id
             GROUP BY acn2.artist_credit) s
           ON acn.artist_credit = s.artist_credit
    LEFT JOIN release_country rc
           ON rc.release = rl.id
         WHERE r.gid = '00000373-114f-4fb6-a8dc-81159b727d06'
     GROUP BY rpr.id, ac.id, s.artist_mbids, rl.gid, artist_credit_name, r.gid, r.name, release_name
     ORDER BY ac.id, rpr.id;