number of errors=0 number of warnings=0
select geonameid,name,featurecode,countrycode,admincode1 from geoname where (admincode1 is not null and admincode1<>'00') and length(cc2)>8
geonameid name featurecode countrycode admincode1