number of errors=4
number of warnings=0
Group=chkGrpPostalCode
select distinct countrycode,adminname1,admincode1,admin1geonameid,admincode2,admin2geonameid,admincode3,admin3geonameid from zip_code where not exists (select 1 from geoname where geoname.geonameid=admin3geonameid and featureclass='A' and geoname.countrycode=zip_code.countrycode) and admin3geonameid is not null
[{key=BD,number=4}]
countrycode adminname1 admincode1 admin1geonameid admincode2 admin2geonameid admincode3 admin3geonameid BD Dhaka Division 81 1337179 3026 1337178 null 7733109 BD Dhaka Division 81 1337179 3029 1337181 null 9165837 BD Dhaka Division 81 1337179 3086 1337186 null 9258637 BD Khulna Division 82 1337210 4041 1337207 null 9260784