number of errors=0
number of warnings=0
Group=chkGrpSubdivision
select countrysubdivision.countrycode,countrysubdivision.name,iso_3166_2,fips,geonamesadmcode,subdivisionid,geoname.featurecode,validTill from countrysubdivision,geoname where validtill is not null and subdivisionid=geoname.geonameid and geoname.featurecode not in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMDH') order by countrycode,name
countrycode name iso_3166_2 fips geonamesadmcode subdivisionid featurecode validtill