# Pastebin u6EuWOyj
(SELECT artist.gid AS artist,
        area.gid AS area
FROM artist
JOIN area ON artist.area = area.id
WHERE area.type = 1)
UNION
(SELECT artist.gid AS artist,
        area.gid AS area
FROM artist
JOIN area_containment ac ON artist.area = ac.descendant
JOIN area ON ac.parent = area.id
WHERE area.type = 1);