no adm1,adm2,adm3 has an admincode4

number of errors=0
number of warnings=0

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

geonameid	name	featurecode	countrycode	admincode1	admincode2	admincode3	admincode4