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 MD null Slobozia Tr. PA null Darien Y Comarca Embera MD null Grigoriopol Tr. VI 78 Vi AE 03 null RU null Читинская Область MD null Ribnita Tr. GU 66 Gu MD null Dubasari Cr. MD null Ungheni RE 00 Reunion (general) BY null MC 01 Monaco RE RE Réunion MD null Dubasari Tr. YT 00 Mayotte (general) MD null Comrat AS null As GB L93000001 null MD null Criuleni-Dub. MD null Tiraspol Tr. MD null Cantrmir TR null Kktc MD null Bender Tr. MD null Criuleni- Dub. GT 07 Ciudad de Guatemala MD null Criulenii-Dub. RU null MH 68 Marshall Islands GP GP Guadeloupe MD null Lazo PA null Comarca Wargandi MD null Camenca Tr. MD null Mun.Balti GB M83000003 null MD null Mun.Chisinau US MH Marshall Islands