# Pastebin PUcV311G
             SELECT r.name AS release_name
                  , ac.name AS artist
                  , mf.name AS format
                  , array_to_string(array_agg(rec.name), ' | ') AS tracks
                  , a.name AS area
                  , date_year || '-' || date_month || '-' || date_day AS date
                  , l.name AS label
                  , rl.catalog_number AS catalog_num
                  , r.barcode
                  , la.iso_code_3 AS language
                  , rgpt.name AS type
                  , rs.name AS status
               INTO releases_exploded
               FROM release r
               JOIN artist_credit ac
                 ON r.artist_credit = ac.id
               JOIN medium m
                 ON m.release = r.id
               JOIN medium_format mf
                 ON m.format = mf.id
    FULL OUTER JOIN release_country rc
                 ON rc.release = r.id
    FULL OUTER JOIN country_area ca
                 ON rc.country = ca.area
               JOIN area a
                 ON ca.area = a.id
    FULL OUTER JOIN release_label rl
                 ON rl.release = r.id
               JOIN label l
                 ON rl.label = l.id
    FULL OUTER JOIN language la
                 ON r.language = la.id
    FULL OUTER JOIN release_status rs
                 ON r.status = rs.id
               JOIN release_group rg
                 ON r.release_group = rg.id
    FULL OUTER JOIN release_group_primary_type rgpt
                 ON rg.type = rgpt.id
               JOIN track t
                 ON t.medium = m.id
               JOIN recording rec
                 ON t.recording = rec.id
              WHERE mf.name = 'CD'
           GROUP BY r.name, ac.name, mf.name, a.name, date, l.name, rl.catalog_number, r.barcode, la.iso_code_3, rgpt.name, rs.name