number of errors=11
number of warnings=0
country=AU
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='AU' order by title
[{key=AU,number=11}]
AU=http://auspost.com.au/apps/postcode.html
countrycode title placename code dist url wpurl geonameid AU Alice Springs Alice Springs 0870 1.60 http://sv.wikipedia.org/wiki/Alice_Springs http://www.geonames.org/maps/google_-23.702222_133.876667.html null AU Alice Springs Alice Springs 0871 1.60 http://sv.wikipedia.org/wiki/Alice_Springs http://www.geonames.org/maps/google_-23.702222_133.876667.html null AU Alice Springs Alice Springs 0872 1.67 http://sv.wikipedia.org/wiki/Alice_Springs http://www.geonames.org/maps/google_-23.702222_133.876667.html null AU Anna Bay Anna Bay 2316 4.17 http://sv.wikipedia.org/wiki/Anna_Bay http://www.geonames.org/maps/google_-28.831666666666667_153.43444444444444.html 2177860 AU Bedourie Bedourie 4829 1.51 http://nl.wikipedia.org/wiki/Bedourie http://www.geonames.org/maps/google_-24.359564_139.470399.html null AU Birdsville Birdsville 4482 7.31 http://fr.wikipedia.org/wiki/Birdsville http://www.geonames.org/maps/google_-25.898289_139.353578.html null AU Borroloola Borroloola 0854 3.75 http://nl.wikipedia.org/wiki/Borroloola http://www.geonames.org/maps/google_-16.0704_136.30722222222224.html null AU Cameron Corner Cameron Corner 2880 2.36 http://en.wikipedia.org/wiki/Cameron_Corner http://www.geonames.org/maps/google_-28.999083333333335_140.9994722222222.html null AU Eromanga Eromanga 4480 1.23 http://nl.wikipedia.org/wiki/Eromanga http://www.geonames.org/maps/google_-27.22348_144.367981.html 2167246 AU Kaltukatjara Kaltukatjara 0872 4.86 http://es.wikipedia.org/wiki/Kaltukatjara http://www.geonames.org/maps/google_-24.87436_129.08255.html 8219785 AU Wandiligong Wandiligong 3744 1.07 http://en.wikipedia.org/wiki/Wandiligong http://www.geonames.org/maps/google_-36.11694444444444_146.15083333333334.html 2144799