number of errors=0
number of warnings=0
Group=chkGrpPostalCode
select zip_code.countrycode,zip,placename,zip_code.admincode1,geoname.geonameid,name,geoname.admincode1 from geoname,zip_code where geoname.geonameid=zip_code.geonameid and zip_code.countrycode='GB' and geoname.geonameid not in (2653256,2640646,2641696,2645155,2653228,2639123,2635936,11593295,2639924,12261572,12266578,2643895) and geoname.admincode1<>zip_code.admincode1 order by 1,2
countrycode zip placename admincode1 geonameid name admincode1