number of errors=7
number of warnings=0
country=GT
Group=chkGrpShp
select geonameid,name,countrycode,admincode1,admincode2 from geoname where countrycode='GT' 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 9975227 Municipio de La Blanca GT 17 1230 9253824 Las Cruces GT 12 1713 9975225 La Máquina GT 20 1021 9975228 Municipio de San Jorge GT 22 1911 9975229 Municipio de El Chal GT 12 1714 12017928 Sipacate GT 06 514 12017929 Petatán GT 08 1333