Get country code (US) for Chicago (5099)

country_from_area.sql

WITH RECURSIVE area_descendants AS (
    SELECT entity0 AS parent, entity1 AS descendant, 1 AS depth
      FROM l_area_area laa
      JOIN link ON laa.link = link.id
     WHERE link.link_type = 356
       AND entity1 = 5099
     UNION
    SELECT entity0 AS parent, descendant, (depth + 1) AS depth
      FROM l_area_area laa
      JOIN link ON laa.link = link.id
      JOIN area_descendants ON area_descendants.parent = laa.entity1
     WHERE link.link_type = 356
       AND entity0 != descendant
)
SELECT iso.code
FROM area_descendants ad
JOIN iso_3166_1 iso ON iso.area = ad.parent;