number of errors=28
number of warnings=0
Group=chkGrpPostalCode
select countrycode,placename,zip,relevance from zip_code where countrycode='NL' and (isreduced is null or isreduced) and not exists (select 1 from alternatename,geoname where geoname.geonameid=alternatename.geonameid and geoname.countrycode=zip_code.countrycode and alternatename.namelocale='post' and alternatename.name=zip) order by zip,placename
countrycode placename zip relevance NL Amsterdam-Duivendrecht 1099 8 NL Lemiers 1234 5 NL Almere 1364 11 NL Beverwijk 1940 5 NL Tiel 1954 5 NL Valkenburg 2236 20 NL Rhoon 3160 5 NL Kapel Avezaath 4013 32 NL Kerk Avezaath 4017 23 NL Gorinchem 4200 5 NL Breda 4857 5 NL Dongen 5100 5 NL Doeveren 5157 21 NL Haarsteeg 5158 5 NL Heesbeen 5158 28 NL 's-Gravenhage 5217 5 NL Herpt 5255 32 NL Hedikhuizen 5257 27 NL Rosmalen 5442 5 NL Asten 5722 30 NL Vlodrop 6060 5 NL Arnhem 6817 5 NL Deventer 7146 5 NL Nijbroek 7379 5 NL Meppel 7940 15 NL Nijeveen 7940 18 NL Reeve 8269 28 NL Urk 8323 30