2025-07-10     2025-07-11     2025-07-12

regions with wp without countrycode and missing entries in hierarchy

number of errors=1
number of warnings=0

select geonameid,name,relevance from geoname where countrycode is null and featurecode in ('RGN','RGNE') and not exists (select 1 from geoname_bbox where geoname_bbox.geonameid = geoname.geonameid) and exists (select 1 from alternatename where alternatename.geonameid = geoname.geonameid and namelocale='link') and geonameid not in (10941926,12217925)

geonameid	name	relevance	
3607313	Mosquitia	12