number of errors=8
number of warnings=0
country=MX
Group=chkGrpShp
select geonameid,name,countrycode,admincode1,admincode2 from geoname where countrycode='MX' and featurecode='ADM2' and not exists (select 1 from geoname_shape where level=3 and geoname_shape.countrycode=geoname.countrycode and geoname_shape.admincode1=geoname.admincode1 and geoname_shape.admincode2=geoname.admincode2)
geonameid name countrycode admincode1 admincode2 12514809 San Quintín MX 02 006 12514808 San Felipe MX 02 007 12514810 Seybaplaya MX 04 012 12514811 Municipio de Dzitbalché MX 04 013 12514807 Honduras de la Sierra MX 05 125 12514812 Coatetelco MX 17 034 12514814 Xoxocotla MX 17 035 12514813 Municipio de Hueyapan MX 17 036