relevant geonames cities are matched to UN/LOCODE

number of errors=3
number of warnings=0
Group=chkGrpUnlocode

select countrycode,geonameid,name,relevance,featurecode from geoname where iscities5000 and not exists (select 1 from UNLOCODE20241 where geoname.geonameid=UNLOCODE20241.geonameid) and featureclass='P' and relevance>35 order by relevance desc

countrycode	geonameid	name	relevance	featurecode	
FI	658225	Helsinki	39	PPLC	
IL	281184	Jerusalem	38	PPLA	
XK	786714	Pristina	37	PPLC