SELECT
    a.name,
    a.comment,
    t.name AS track_name,
    r.name AS release_name,
    rg.name AS release_group_name,
    CASE
        WHEN rg.type = 1 THEN 'Album'
        WHEN rg.type = 2 THEN 'Single'
        WHEN rg.type = 3 THEN 'EP'
        WHEN rg.type = 4 THEN 'Other'
        ELSE CAST(rg.type AS VARCHAR)
    END AS release_group_type,
    array_agg(DISTINCT genre.name) AS genre_names
FROM artist a
JOIN artist_credit_name acn ON a.id = acn.artist
JOIN track t ON t.artist_credit = acn.artist_credit
JOIN medium m ON t.medium = m.id
JOIN release r ON m.release = r.id
JOIN release_group rg ON r.release_group = rg.id
LEFT JOIN release_tag rt ON r.id = rt.release
LEFT JOIN release_group_tag rgt ON rg.id = rgt.release_group
LEFT JOIN tag ON rt.tag = tag.id OR rgt.tag = tag.id
LEFT JOIN genre ON tag.name = genre.name
WHERE
    a.comment ~* '\y(IRAN|IRANIAN|PERSIA|PERSIAN)\y'
    OR area = 101
GROUP BY
    a.name,
    a.comment,
    t.name,
    r.name,
    rg.name,
    rg.type
ORDER BY a.name;