This should be `SELECT iso_3166_1.code, area.name FROM country_area JOIN area on country_area.area = area.id JOIN iso_3166_1 ON iso_3166_1.area = area.id;` since the may 2013 schema change.