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