number of errors=39
number of warnings=0
country=BD
Group=chkGrpPostalCode
select countrycode,zip,placename,geonameid,admincode1,admincode2,geonamesadmcode from zip_code where countrycode in ('BD') and zip_code.geonameid not in (2775000,4020092) and zip_code.admincode1 is not null and not exists (select 1 from geoname b where b.countrycode=zip_code.countrycode and b.admincode1=zip_code.geonamesadmcode and b.admincode2=zip_code.admincode2 and b.featurecode='ADM2' and b.countrycode in ('BD')) order by countrycode,zip,placename
http://www.bangladeshpost.gov.bd/PostCode.asp
countrycode zip placename geonameid admincode1 admincode2 geonamesadmcode BD 2000 Jamalpur 1185106 H 3039 81 BD 2001 Nandina 1193455 H 3039 81 BD 2002 Narundi 1193141 H 3039 81 BD 2011 Jamalpur 1185106 H 3039 81 BD 2012 Malancha 1195227 H 3039 81 BD 2013 Mahmoodpur 1195088 H 3039 81 BD 2020 Islampur 7914734 H 3039 81 BD 2022 Gilabari 1202464 H 3039 81 BD 2030 Dewangonj 1185231 H 3039 81 BD 2051 Gunerbari 1201863 H 3039 81 BD 2054 Pingna 1191111 H 3039 81 BD 2110 Nalitabari 7670694 H 3089 81 BD 2111 Hatibandha 1201226 H 3089 81 BD 2120 Jhinaigati 7912475 H 3089 81 BD 2150 Nakla 1185158 H 3089 81 BD 2200 Mymensingh Sadar 1189385 H 3061 81 BD 2210 Muktagachha 1185164 H 3061 81 BD 2216 Fulbaria 9972611 H 3061 81 BD 2220 Trishal 9295696 H 3061 81 BD 2223 Dhala 1204539 H 3061 81 BD 2233 Kandipara 1198649 H 3061 81 BD 2240 Bhaluka 9171954 H 3061 81 BD 2251 Beltia 1209590 H 3061 81 BD 2252 Tarakanda 1186524 H 3061 81 BD 2260 Haluaghat 7626570 H 3061 81 BD 2261 Dhara 1204343 H 3061 81 BD 2270 Gouripur 1201941 H 3061 81 BD 2271 Ramgopalpur 1190074 H 3061 81 BD 2281 Sohagi 1188125 H 3061 81 BD 2282 Atharabari 1212316 H 3061 81 BD 2290 Nandail 8430306 H 3061 81 BD 2291 Gangail 1202991 H 3061 81 BD 2416 Dhobaura 1204226 H 3072 81 BD 2430 Kalmakanda 1201594 H 3072 81 BD 2440 Barhatta 1185212 H 3072 81 BD 2446 Mohanganj 1185208 H 3072 81 BD 2470 Atpara 1185178 H 3072 81 BD 2480 Kendua 1197932 H 3072 81 BD 2490 Madan 1213094 H 3072 81