each countrycode used for shape also exists in geonames table

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

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

countrycode