number of errors=4
number of warnings=0
Group=chkGrpPostalCode
select zip_code.countrycode,placename,zip,geoname.geonameid,geoname.name,zip_code.admincode4,adminname4 from zip_code,geoname where zip_code.geonameid=geoname.geonameid and zip_code.admincode4<>geoname.admincode4 and zip_code.admincode4 is not null and featurecode<>'ADM4H' and not exists (select 1 from qa_exceptions where qa_exceptions.geonameid=geoname.geonameid and qa_exceptions.zip=zip_code.zip and qa_exceptions.key='chkPostalCodeAdmin4CodeEqGeoNameAdm4Code')
[{key=BE,number=4}]
countrycode placename zip geonameid name admincode4 adminname4 BE Zwijndrecht 2070 2783081 Zwijndrecht 11056 Zwijndrecht BE Kruibeke 9150 2793940 Kruibeke 46013 Kruibeke BE Rupelmonde 9150 2787512 Rupelmonde 46013 Kruibeke BE Bazel 9150 2802529 Bazel 46013 Kruibeke