alternate names are links but don't have the link pseudo language code

number of errors=1
number of warnings=0
Group=ckgGrpName

select geonameid,name,namelocale from alternatename where name like 'http%' and (namelocale is null or namelocale<>'link') and geonameid in (select geonameid from geoname)

geonameid	name	namelocale	
1688386	https://en.wikipedia.org/wiki/Santa_Barbara,_Iloilo	ln