each countrycode has a shape for the mainland.

number of errors=0
number of warnings=0
Group=chkGrpShp

select countrycode from geoname where featureclass='A' and (featurecode like 'PCL%' or featurecode='TERR') and featurecode <>'PCLH' and countrycode not in (select countrycode from geoname_shape where level=1 and ismainland=true and countrycode is not null)

countrycode