SELECT DISTINCT
    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)  -- For any other values that may exist, this will show the raw number as text.
    END AS release_group_type,
    genre.name AS genre_name
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