number of errors=8
number of warnings=0
Group=chkGrpSea
Group=ckgGrpWP
select name,geonameid from geoname where featurecode='OCN' and not exists (select 1 from alternatename where alternatename.geonameid=geoname.geonameid and namelocale='link')
name geonameid North Pacific Ocean - Marshall Islands 7670505 North West Pacific Ocean - Helen Reef 7670624 North West Pacific Ocean - to the East 7839117 North West Pacific Ocean - to the East 7733072 North Pacific Ocean - Ulithi Atoll 7647001 Western Central Pacific Ocean - Kiribati 7669370 North West Pacific Ocean - E to S of Palau Islands 7670826 Océano Pacífico del Norte 3812150