number of errors=3
number of warnings=0
country=GB
select geonameid,name,ansiname,featurecode,countrycode,admincode1,admincode2,admincode3,admincode4,admincode5 from geoname where countrycode='GB' and featurecode='ADM2' and not exists (select 1 from countrysubdiv_code where validtill is null and countrysubdiv_code.countrycode='GB' and countrysubdiv_code.featurecode='ADM2' and geoname.admincode1=countrysubdiv_code.admincode1 and geoname.admincode2=countrysubdiv_code.admincode2) order by admincode1,admincode2,admincode3,admincode4,admincode5
171 from ons
geonameid name ansiname featurecode countrycode admincode1 admincode2 admincode3 admincode4 admincode5 2648110 Greater London Greater London ADM2 GB ENG GLA null null null 13192429 North Northamptonshire North Northamptonshire ADM2 GB ENG NNH null null null 13192427 West Northamptonshire West Northamptonshire ADM2 GB ENG WNH null null null