2025-03-05     2025-03-06     2025-03-07

country subdivs linked to ADMH feature should have validTill date

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 null and subdivisionid=geoname.geonameid and geoname.featurecode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMDH') order by countrycode,name

countrycode	name	iso_3166_2	fips	geonamesadmcode	subdivisionid	featurecode	validtill