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