shapes with level 1 and isMainland need same continent
number of errors=0
number of warnings=0
Group=chkGrpShp
select countrycode from (select distinct countrycode,continent from geoname_shape where level=1 and ismainland)s group by countrycode having count(*)>1
