number of errors=0
number of warnings=0
Group=chkGrpShp
Group=chkGrpVarShp
select countrycode,geoshapeid from geoname_shape where geoshapeid=23781 and geoshapeid not in (select s.geoshapeid from geoname_shape s, geoname g where g.geonameid=1281780 and st_within(geography::geometry,wkb_geometry) and s.countrycode='CN' and geoshapeid=23781)
countrycode geoshapeid