countries without capital (except AQ,BQ,BV,EH,HM,IO,IL,MP,NR,PS,TK,UM,VA)

number of errors=0
number of warnings=0

select geonameid,ansiname,countrycode,featurecode from geoname where featurecode in ('PCLI','PCLF','PCLD','PCL','PCLIX','PCLS','TERR') and countrycode not in (select countrycode from geoname where featurecode = 'PPLC') and countrycode not in ('AQ','BQ','BV','EH','HM','IO','IL','MP','NR','PS','TK','UM','VA')

geonameid	ansiname	countrycode	featurecode