each country has a link to the corresponding wikipedia article

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

select geonameid,name,countrycode from geoname where featurecode in ('PCLI','PCLD','PCLS','PCL','TERR') 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