number of errors=0
number of warnings=0
select geonameid,name,countrycode,admincode1 from geoname where featurecode in ('PCLI','PCLF','PCLD','PCL','PCLIX','PCLS','TERR') and (admincode1 is null OR admincode1 <>'00') order by countryCode
geonameid name countrycode admincode1