number of errors=0
number of warnings=0
Group=chkGrpSubdivision
select countrycode,name,iso_3166_2,fips,geonamesadmcode from countrysubdivision where geonameslevel>0 and subdivisionid is null and validtill is null and countrycode in ('AT','CH','DE','DK','ES','FI','FR','GB','IT','NL','NO','SE','US','CA','AU','NZ','JP') and not countrycode in ('CS') and not (countrycode='US' and iso_3166_2 in ('AS','GU','MP','PR','UM','VI')) and not (countrycode='FR' and iso_3166_2 in ('CP','BL','MF','NC','PF','PM','TF','WF','YT')) and not (countrycode='NO' and iso_3166_2 in ('21','22')) and not (countrycode='FI' and iso_3166_2 in ('01')) order by countrycode,name
AT,CH,DE,DK,ES,FI,FR,GB,IT,NL,NO,SE,US,CA,AU,NZ,JP
and not countrycode in ('CS') and not (countrycode='US' and iso_3166_2 in ('AS','GU','MP','PR','UM','VI')) and not (countrycode='FR' and iso_3166_2 in ('CP','BL','MF','NC','PF','PM','TF','WF','YT')) and not (countrycode='NO' and iso_3166_2 in ('21','22')) and not (countrycode='FI' and iso_3166_2 in ('01'))
countrycode name iso_3166_2 fips geonamesadmcode