number of errors=37
number of warnings=0
Group=chkGrpPostalCode
select distinct countrycode,admincode1,adminname1 from zip_code where (admincode1 is not null or adminname1 is not null) and admin1geonameid is null
[{key=MD,number=17}, {key=GB,number=2}, {key=PA,number=2}, {key=RE,number=2}, {key=RU,number=2}, {key=AE,number=1}, {key=AS,number=1}, {key=BY,number=1}, {key=GP,number=1}, {key=GT,number=1}, {key=GU,number=1}, {key=MC,number=1}, {key=MH,number=1}, {key=TR,number=1}, {key=US,number=1}, {key=VI,number=1}, {key=YT,number=1}]
countrycode admincode1 adminname1 AE 03 null AS null As BY null GB L93000001 null GB M83000003 null GP GP Guadeloupe GT 07 Ciudad de Guatemala GU 66 Gu MC 01 Monaco MD null Bender Tr. MD null Camenca Tr. MD null Cantrmir MD null Comrat MD null Criuleni- Dub. MD null Criuleni-Dub. MD null Criulenii-Dub. MD null Dubasari Cr. MD null Dubasari Tr. MD null Grigoriopol Tr. MD null Lazo MD null Mun.Balti MD null Mun.Chisinau MD null Ribnita Tr. MD null Slobozia Tr. MD null Tiraspol Tr. MD null Ungheni MH 68 Marshall Islands PA null Comarca Wargandi PA null Darien Y Comarca Embera RE 00 Reunion (general) RE RE Réunion RU null RU null Читинская Область TR null Kktc US MH Marshall Islands VI 78 Vi YT 00 Mayotte (general)