no adm1 has an admincode2

number of errors=0
number of warnings=0

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

geonameid	name	countrycode	admincode1	admincode2