number of errors=3
number of warnings=0
country=BE
Group=chkGrpShp
select distinct countrycode,level,admincode1,adminname1,admincode2,adminname2,admincode3,adminname3,admincode4,adminname4 from geoname_shape where countrycode='BE' and level=5 and not exists (select 1 from geoname where geoname.countrycode='BE' and featurecode='ADM4' and geoname_shape.countrycode=geoname.countrycode and geoname_shape.admincode1=geoname.admincode1 and geoname_shape.admincode2=geoname.admincode2 and geoname_shape.admincode3=geoname.admincode3 and geoname_shape.admincode4=geoname.admincode4) order by admincode1,admincode2,admincode3
countrycode level admincode1 adminname1 admincode2 adminname2 admincode3 adminname3 admincode4 adminname4 BE 5 VLG null VAN null 11 null 11056 Zwijndrecht BE 5 VLG null VOV null 46 null 46003 Beveren BE 5 VLG null VOV null 46 null 46013 Kruibeke