no large region has a country code

number of errors=0
number of warnings=0
Group=chkGrpRegion

select p.geonameid,p.name,p.countrycode,count(*) as numcountries from geoname p, geoname_hierarchy, geoname c where p.geonameid=parentid and c.geonameid=childid and p.featureclass='L' and p.featurecode='RGN' and c.featurecode like 'PCL%' and p.countrycode is not null and p.geonameid not in (12902582,12902589,12954643) group by 1,2,3

geonameid	name	countrycode	numcountries