find invalid ISO:3166-2 codes (dewiki)

queries table geo-tags for non matching pairs of iso:3166-1 and iso:3166-2 codes. Does not check for false iso:3166-1 codes.

SQL

use dewiki_p;
#describe geo_tags;
#select gt_page_id,gt_lat,gt_lon,gt_name,gt_primary,(select page_title from page where page_id = gt_page_id) from geo_tags where gt_country='AT' and gt_region is null
select abs(gt_lat - cen_gt_lat + gt_lon - cen_gt_lon) as distanzungefaehr, gt_lat, gt_lon, gt_page_id, gt_name, (select page_title from page where page_id = gt_page_id) from geo_tags, (select avg(gt_lat) cen_gt_lat,avg(gt_lon) cen_gt_lon,count(*) from geo_tags where gt_country='AT' and gt_region = '3') as zentrumdavon where gt_country='AT' and gt_region = '3' order by 1 desc limit 100;

SQL

Checking query status...