each capital has a link to the corresponding wikipedia article (except MP,TK,TV)

number of errors=0
number of warnings=0
Group=ckgGrpWP

select geonameId,name,countrycode from geoname where countrycode not in ('MP','TK','TV') and featurecode='PPLC' and not exists (select 1 from alternatename where geoname.geonameid=alternatename.geonameid and namelocale='link' and name like 'https://en.wikipedia.org/%') order by countrycode

geonameid	name	countrycode