2025-01-28     2025-01-29     2025-01-30

no adm1,adm2 has an admincode3

number of errors=0
number of warnings=0

select geonameid,name,featurecode,countrycode,admincode1,admincode2,admincode3 from geoname where featurecode in ('PCLI','PCLF','PCLD','PCL','PCLIX','PCLS','TERR','ADM1','ADM2') and admincode3 is not null order by featurecode,countryCode,admincode1,admincode2

geonameid	name	featurecode	countrycode	admincode1	admincode2	admincode3