number of errors=65
number of warnings=0
country=IN
Group=chkGrpPostalCode
Group=ckgGrpWP
select distinct zip_code.countrycode,wp_postalcode.title,placename,code,to_char(longlat<->estlonglat,'99.99') as dist,url,'http://www.geonames.org/maps/google_' || wp_postalcode.longlat[1] || '_' || wp_postalcode.longlat[0] || '.html' as wpurl,zip_code.geonameid from wp_postalcode_code,wp_postalcode,zip_code where wp_postalcode.wikipediaid=wp_postalcode_code.wikipediaid and wp_postalcode.language=wp_postalcode_code.language and code=zip and wp_postalcode.countrycode=zip_code.countrycode and longlat<->estlonglat>1 and title=placename and iswithinccbounds and zip_code.countrycode='IN' order by title
[{key=IN,number=65}]
IN=http://www.indiapost.gov.in/
countrycode title placename code dist url wpurl geonameid IN Akoda Akoda 477332 1.59 http://it.wikipedia.org/wiki/Akoda http://www.geonames.org/maps/google_25.162777777777777_77.75024444444445.html null IN Arag Arag 416401 1.11 http://en.wikipedia.org/wiki/Arag http://www.geonames.org/maps/google_16.78_74.8.html null IN Arambhada Arambhada 361345 1.19 http://it.wikipedia.org/wiki/Arambhada http://www.geonames.org/maps/google_22.45588_69.02635.html null IN Atpadi Atpadi 415301 1.38 http://en.wikipedia.org/wiki/Atpadi http://www.geonames.org/maps/google_17.25_74.57.html null IN Attili Attili 534134 2.27 http://en.wikipedia.org/wiki/Attili http://www.geonames.org/maps/google_16.7_81.6.html null IN Awadam Awadam 504204 1.17 http://en.wikipedia.org/wiki/Awadam http://www.geonames.org/maps/google_18.9556284_79.6037793.html null IN Basangi Basangi 535525 1.38 http://en.wikipedia.org/wiki/Basangi http://www.geonames.org/maps/google_17.888_82.483.html 10783198 IN Baskhari Baskhari 224129 3.01 http://en.wikipedia.org/wiki/Baskhari http://www.geonames.org/maps/google_25.85_79.82.html 10651901 IN Bellampalli Bellampalli 504251 1.01 http://es.wikipedia.org/wiki/Bellampalli http://www.geonames.org/maps/google_19.075555555555557_79.48805555555556.html 7302806 IN Bhadarwa Bhadarwa 391780 1.95 http://fr.wikipedia.org/wiki/Bhadarwa http://www.geonames.org/maps/google_22.258652_71.1923805.html 1276359 IN Bhagwatgarh Bhagwatgarh 322701 5.86 http://en.wikipedia.org/wiki/Bhagwatgarh http://www.geonames.org/maps/google_26.2_82.1.html 1276276 IN Budgam Budgam 191111 1.54 http://it.wikipedia.org/wiki/Budgam http://www.geonames.org/maps/google_34.63_76.04.html null IN Chakapara Chakapara 783380 4.41 http://it.wikipedia.org/wiki/Chakapara http://www.geonames.org/maps/google_22.63_88.35.html null IN Dimaruguri Dimaruguri 782003 1.55 http://it.wikipedia.org/wiki/Dimaruguri http://www.geonames.org/maps/google_26.7833_94.2.html 11185242 IN Diskit Diskit 194401 2.10 http://es.wikipedia.org/wiki/Diskit http://www.geonames.org/maps/google_34.54111111111111_77.56027777777777.html null IN Dungra Dungra 396193 2.99 http://es.wikipedia.org/wiki/Dungra http://www.geonames.org/maps/google_23.166666666666668_74.3.html null IN Dwarka Dwarka 361335 1.24 http://it.wikipedia.org/wiki/Dwarka http://www.geonames.org/maps/google_22.243333333333336_68.96888888888888.html null IN Edathara Edathara 678611 1.49 http://en.wikipedia.org/wiki/Edathara http://www.geonames.org/maps/google_9.316666666666666_76.81666666666666.html 11186378 IN Elangadu Elangadu 604408 1.61 http://en.wikipedia.org/wiki/Elangadu http://www.geonames.org/maps/google_10.8353_78.9277.html null IN Garampani Garampani 788931 1.32 http://en.wikipedia.org/wiki/Garampani http://www.geonames.org/maps/google_26.4_93.86666666666666.html null IN Gopavaram Gopavaram 516233 3.09 http://en.wikipedia.org/wiki/Gopavaram http://www.geonames.org/maps/google_16.816666666666666_80.9.html 11271185 IN Hossur Hossur 561210 3.00 http://en.wikipedia.org/wiki/Hossur http://www.geonames.org/maps/google_13.55_75.25.html null IN Hulkund Hulkund 591114 3.48 http://en.wikipedia.org/wiki/Hulkund http://www.geonames.org/maps/google_12.833333333333334_75.96666666666667.html null IN Jaysingpur Jaysingpur 416101 5.34 http://it.wikipedia.org/wiki/Jaysingpur http://www.geonames.org/maps/google_16.7835056_74.5664406.html null IN Jorai Jorai 736207 2.31 http://en.wikipedia.org/wiki/Jorai http://www.geonames.org/maps/google_26.1328_89.54115.html null IN Kamothe Kamothe 410206 1.70 http://en.wikipedia.org/wiki/Kamothe http://www.geonames.org/maps/google_19.016804_73.096461.html null IN Kasipet Kasipet 504231 1.01 http://es.wikipedia.org/wiki/Kasipet http://www.geonames.org/maps/google_19.0333_79.4667.html null IN Kataram Kataram 505503 2.28 http://en.wikipedia.org/wiki/Kataram http://www.geonames.org/maps/google_16.516666666666666_77.93333333333334.html null IN Kavalur Kavalur 635701 1.97 http://en.wikipedia.org/wiki/Kavalur http://www.geonames.org/maps/google_10.849691666666667_79.21409722222222.html null IN Kesanapalli Kesanapalli 533244 2.17 http://en.wikipedia.org/wiki/Kesanapalli http://www.geonames.org/maps/google_16.21_80.07.html null IN Khanpur Ahir Khanpur Ahir 301403 2.53 http://en.wikipedia.org/wiki/Khanpur_Ahir http://www.geonames.org/maps/google_27.0238_74.2179.html 10165491 IN Khopoli Khopoli 410203 2.82 http://it.wikipedia.org/wiki/Khopoli http://www.geonames.org/maps/google_18.79143_73.344183.html null IN Lankapalli Lankapalli 521131 2.04 http://en.wikipedia.org/wiki/Lankapalli http://www.geonames.org/maps/google_18.6_80.65.html null IN Lawalong Lawalong 825103 1.11 http://en.wikipedia.org/wiki/Lawalong http://www.geonames.org/maps/google_23.550833333333333_85.58055555555555.html 10841752 IN Mahendragarh Mahendragarh 311802 3.50 http://es.wikipedia.org/wiki/Mahendragarh http://www.geonames.org/maps/google_28.28_76.15.html 10816616 IN Mandangad Mandangad 415203 4.71 http://en.wikipedia.org/wiki/Mandangad http://www.geonames.org/maps/google_17.983333333333334_73.25.html null IN Mhasla Mhasla 402105 3.57 http://it.wikipedia.org/wiki/Mhasla http://www.geonames.org/maps/google_18.13_73.12.html 10705494 IN Murbad Murbad 421401 1.04 http://it.wikipedia.org/wiki/Murbad http://www.geonames.org/maps/google_19.25_73.4.html null IN Narrawada Narrawada 524222 1.00 http://en.wikipedia.org/wiki/Narrawada http://www.geonames.org/maps/google_14_79.html 11203609 IN Naspur Naspur 504302 1.12 http://it.wikipedia.org/wiki/Naspur http://www.geonames.org/maps/google_18.860402_79.484882.html null IN Nekkonda Nekkonda 506122 1.92 http://en.wikipedia.org/wiki/Nekkonda http://www.geonames.org/maps/google_16.783333333333335_78.23333333333333.html null IN Nijhar Nijhar 394370 1.14 http://en.wikipedia.org/wiki/Nijhar http://www.geonames.org/maps/google_21.47_74.19.html null IN Peravali Peravali 534328 1.15 http://en.wikipedia.org/wiki/Peravali http://www.geonames.org/maps/google_16.1775_80.7425.html 10769174 IN Pothukurru Pothukurru 533577 1.67 http://en.wikipedia.org/wiki/Pothukurru http://www.geonames.org/maps/google_16.62195_82.02665.html null IN Purli Purli 532440 7.21 http://en.wikipedia.org/wiki/Purli http://www.geonames.org/maps/google_18.85_76.53333333333333.html null IN Raiganj Raiganj 733134 2.67 http://it.wikipedia.org/wiki/Raiganj http://www.geonames.org/maps/google_25.62_88.12.html null IN Ramanujganj Ramanujganj 497220 1.03 http://it.wikipedia.org/wiki/Ramanujganj http://www.geonames.org/maps/google_23.8_83.7.html null IN Ratwara Ratwara 843333 8.73 http://en.wikipedia.org/wiki/Ratwara http://www.geonames.org/maps/google_25.016666666666666_76.95.html null IN Rebarthy Rebarthy 506367 1.46 http://en.wikipedia.org/wiki/Rebarthy http://www.geonames.org/maps/google_18.8492_78.6261.html null IN Reoli Reoli 274602 7.41 http://en.wikipedia.org/wiki/Reoli http://www.geonames.org/maps/google_29.016666666666666_77.06666666666666.html 10671931 IN Sabalpur Sabalpur 841101 5.55 http://es.wikipedia.org/wiki/Sabalpur http://www.geonames.org/maps/google_27.176049_79.42012.html null IN Saraspur Saraspur 380018 8.31 http://en.wikipedia.org/wiki/Saraspur http://www.geonames.org/maps/google_28.366666666666667_79.16666666666667.html null IN Saripalli Saripalli 533213 1.74 http://en.wikipedia.org/wiki/Saripalli http://www.geonames.org/maps/google_18.131666666666668_83.47944444444444.html null IN Savlaj Savlaj 416311 4.02 http://en.wikipedia.org/wiki/Savlaj http://www.geonames.org/maps/google_17.1_74.78.html null IN Sevni Sevni 394320 4.74 http://en.wikipedia.org/wiki/Sevni http://www.geonames.org/maps/google_24.666666666666668_76.36666666666666.html null IN Shelu Shelu 410101 1.10 http://en.wikipedia.org/wiki/Shelu http://www.geonames.org/maps/google_19.0659_73.3199.html null IN Shey Shey 194201 2.07 http://es.wikipedia.org/wiki/Shey http://www.geonames.org/maps/google_34.0731818_77.6392939.html null IN Sonkatch Sonkatch 465669 1.37 http://it.wikipedia.org/wiki/Sonkatch http://www.geonames.org/maps/google_22.973333333333333_76.3536111111111.html null IN Spituk Spituk 194101 1.94 http://es.wikipedia.org/wiki/Spituk http://www.geonames.org/maps/google_34.1330348_77.5146453.html null IN Tarauli Tarauli 281406 2.42 http://en.wikipedia.org/wiki/Tarauli http://www.geonames.org/maps/google_26.75_79.84.html null IN Tundri Tundri 495695 1.36 http://en.wikipedia.org/wiki/Tundri http://www.geonames.org/maps/google_22.65935_82.0831.html 1254068 IN Umaria Umaria 484661 2.34 http://it.wikipedia.org/wiki/Umaria http://www.geonames.org/maps/google_23.42_78.63.html 1253862 IN Vadia Vadia 365480 6.61 http://it.wikipedia.org/wiki/Vadia http://www.geonames.org/maps/google_27.7587844_73.1286015.html null IN Vasundhra Vasundhra 201012 2.32 http://en.wikipedia.org/wiki/Vasundhra http://www.geonames.org/maps/google_28.61_79.799.html null IN Yanam Yanam 533464 5.42 http://it.wikipedia.org/wiki/Yanam http://www.geonames.org/maps/google_16.7333333_82.2166667.html null