number of errors=0
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')
[]
countrycode placename zip geonameid name admincode4 adminname4