number of errors=1
number of warnings=0
select geonameid,ansiname,featurecode,countrycode,admincode1,admincode2 from geoname where featureclass<>'A' and admincode2=geonameid::text and admincode2 is not null
geonameid ansiname featurecode countrycode admincode1 admincode2 97825 Batifa PPLA2 IQ 08 97825