number of errors=187
number of warnings=0
Group=chkGrpPostalCode
select distinct countrycode,adminname1,admincode1,admin1geonameid,admincode2,admin2geonameid from zip_code where not exists (select 1 from geoname where geoname.geonameid=admin2geonameid and featureclass='A' and geoname.countrycode=zip_code.countrycode) and admin2geonameid is not null
[{key=GB,number=183}, {key=SJ,number=2}, {key=FI,number=1}, {key=PA,number=1}]
countrycode adminname1 admincode1 admin1geonameid admincode2 admin2geonameid GB England ENG 6269131 E99999999 11609039 GB England ENG 6269131 Q4 11609023 GB England ENG 6269131 E99999999 11609018 GB England ENG 6269131 2634219 2634219 GB England ENG 6269131 E99999999 11609017 GB England ENG 6269131 E10000003 11609029 GB England ENG 6269131 11609029 11609029 GB England ENG 6269131 E10000018 11609039 GB England ENG 6269131 E10000021 11609042 GB England ENG 6269131 E99999999 2635274 GB England ENG 6269131 E99999999 11609036 GB Wales WLS 2634895 2652738 GB England ENG 6269131 G5 11609038 GB England ENG 6269131 E99999999 11609044 GB England ENG 6269131 E99999999 2634219 GB England ENG 6269131 11609026 11609026 GB England ENG 6269131 11609048 11609048 GB England ENG 6269131 11609013 GB England ENG 6269131 2655856 2655856 GB England ENG 6269131 J1 11609042 GB Wales WLS 2634895 W99999999 11612612 GB England ENG 6269131 11609028 11609028 GB England ENG 6269131 11609011 GB England ENG 6269131 E99999999 11609035 GB England ENG 6269131 E99999999 11609043 GB England ENG 6269131 E99999999 11609046 GB England ENG 6269131 E10000029 11609019 GB England ENG 6269131 2656044 GB England ENG 6269131 11609043 11609043 GB England ENG 6269131 E99999999 11609048 GB England ENG 6269131 E99999999 11609029 GB England ENG 6269131 11609034 GB England ENG 6269131 11609037 11609037 GB England ENG 6269131 11609016 11609016 GB England ENG 6269131 E99999999 2637273 GB England ENG 6269131 11609029 GB Wales WLS 2634895 2634411 GB England ENG 6269131 E10000015 11609037 GB England ENG 6269131 E10000016 11609038 GB England ENG 6269131 11609015 11609015 GB England ENG 6269131 11609035 GB England ENG 6269131 11609028 GB England ENG 6269131 E99999999 2642713 GB England ENG 6269131 E99999999 11609024 GB England ENG 6269131 11609012 GB England ENG 6269131 E99999999 2656044 GB England ENG 6269131 E10000028 11609018 GB England ENG 6269131 D4 11609025 GB England ENG 6269131 GLA 11609024 GB England ENG 6269131 11609047 GB England ENG 6269131 E10000025 11609045 GB Wales WLS 2634895 2637417 GB England ENG 6269131 11609032 GB England ENG 6269131 11609030 GB England ENG 6269131 11609031 11609031 GB England ENG 6269131 E99999999 2648108 GB England ENG 6269131 11609044 11609044 GB England ENG 6269131 2642713 GB England ENG 6269131 E99999999 2655856 GB England ENG 6269131 2637273 2637273 GB England ENG 6269131 J9 11609044 GB England ENG 6269131 11609045 11609045 GB England ENG 6269131 E10000019 11609040 GB England ENG 6269131 E10000029 11609029 GB England ENG 6269131 11609036 GB England ENG 6269131 E10000008 11609025 GB England ENG 6269131 11609048 GB England ENG 6269131 E10000006 11609030 GB England ENG 6269131 E10000024 11609044 GB England ENG 6269131 11609013 11609013 GB Wales WLS 2634895 2642568 GB England ENG 6269131 E99999999 11609011 GB England ENG 6269131 11609031 GB England ENG 6269131 E10000027 11609046 GB England ENG 6269131 D6 11609032 GB England ENG 6269131 E10000002 11609028 GB England ENG 6269131 11609020 GB Wales WLS 2634895 W99999999 2642568 GB Wales WLS 2634895 W99999999 11612613 GB England ENG 6269131 11609025 11609025 GB England ENG 6269131 AA 11609032 GB England ENG 6269131 11609039 GB England ENG 6269131 E10000023 11609043 GB England ENG 6269131 11609027 11609027 GB England ENG 6269131 11609042 GB England ENG 6269131 E10000034 11609023 GB England ENG 6269131 2653234 2653234 GB England ENG 6269131 E99999999 11609014 GB England ENG 6269131 E99999999 11609047 GB England ENG 6269131 E10000032 11609022 PA Veraguas 10 3700159 12535894 12535894 GB England ENG 6269131 11609024 11609024 GB England ENG 6269131 11609022 11609022 GB England ENG 6269131 E99999999 11609028 GB England ENG 6269131 E99999999 11609012 GB England ENG 6269131 11609039 11609039 GB England ENG 6269131 11609021 11609021 GB England ENG 6269131 11609018 GB England ENG 6269131 11609023 11609023 GB England ENG 6269131 J7 11609043 GB England ENG 6269131 11609016 GB England ENG 6269131 11609032 11609032 GB England ENG 6269131 11609047 11609047 GB Wales WLS 2634895 W99999999 2637417 GB England ENG 6269131 2648108 2648108 GB England ENG 6269131 11609035 11609035 GB England ENG 6269131 2634219 GB Wales WLS 2634895 W99999999 2652738 GB England ENG 6269131 E10000014 11609036 GB England ENG 6269131 E99999999 11609040 GB England ENG 6269131 E99999999 11609031 GB England ENG 6269131 B9 11609028 GB England ENG 6269131 E99999999 11609025 GB England ENG 6269131 11609017 GB England ENG 6269131 11609022 GB Wales WLS 2634895 2650596 GB England ENG 6269131 11609041 11609041 GB England ENG 6269131 11609014 GB England ENG 6269131 E99999999 11609015 GB England ENG 6269131 11609034 11609034 GB England ENG 6269131 N5 11609019 GB England ENG 6269131 2642713 2642713 GB England ENG 6269131 11609033 11609033 GB England ENG 6269131 E99999999 11609027 SJ Svalbard 21 7521757 2111 2728377 GB England ENG 6269131 11609030 11609030 GB England ENG 6269131 11609012 11609012 GB England ENG 6269131 E10000007 11609031 GB England ENG 6269131 11609014 11609014 GB Wales WLS 2634895 11612613 GB Wales WLS 2634895 11612614 GB England ENG 6269131 11609046 11609046 GB England ENG 6269131 11609044 GB England ENG 6269131 E10000011 11609033 GB Wales WLS 2634895 W99999999 2650596 GB England ENG 6269131 11609020 11609020 GB England ENG 6269131 11609033 GB England ENG 6269131 E99999999 11609034 GB England ENG 6269131 E99999999 11609016 GB England ENG 6269131 M3 11609046 GB England ENG 6269131 2635274 GB England ENG 6269131 11609015 GB England ENG 6269131 F8 11609037 GB England ENG 6269131 11609036 11609036 GB England ENG 6269131 11609042 11609042 GB England ENG 6269131 11609040 11609040 GB England ENG 6269131 11609026 GB England ENG 6269131 E99999999 11609026 GB England ENG 6269131 E99999999 11609033 GB England ENG 6269131 11609027 GB England ENG 6269131 11609038 GB England ENG 6269131 2634343 2634343 GB England ENG 6269131 11609011 11609011 GB England ENG 6269131 E99999999 11609032 GB England ENG 6269131 11609024 GB England ENG 6269131 11609046 GB England ENG 6269131 E10000031 11609021 GB Wales WLS 2634895 W99999999 11612614 GB England ENG 6269131 E99999999 11609013 GB England ENG 6269131 2648108 GB England ENG 6269131 2655856 GB England ENG 6269131 11609040 GB Wales WLS 2634895 11612612 GB England ENG 6269131 2634343 GB England ENG 6269131 11609018 11609018 GB England ENG 6269131 11609038 11609038 GB England ENG 6269131 E10000013 11609035 GB England ENG 6269131 2656044 2656044 GB England ENG 6269131 C9 11609030 FI Satakunta 04 831041 043 3041809 SJ Svalbard 21 7521757 2111 7535963 GB England ENG 6269131 2637273 GB England ENG 6269131 E10000017 11609047 GB England ENG 6269131 E10000030 11609020 GB England ENG 6269131 2635274 2635274 GB England ENG 6269131 E99999999 11609038 GB England ENG 6269131 E10000012 11609034 GB England ENG 6269131 11609043 GB England ENG 6269131 2653234 GB England ENG 6269131 E99999999 2653234 GB Wales WLS 2634895 W99999999 2634411 GB England ENG 6269131 E10000020 11609041 GB England ENG 6269131 P6 11609022 GB England ENG 6269131 11609017 11609017 GB England ENG 6269131 11609019 11609019 GB England ENG 6269131 11609025 GB England ENG 6269131 E99999999 2634343