number of errors=4
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=4}]
AU=http://auspost.com.au/apps/postcode.html
countrycode title placename code dist url wpurl geonameid AU Alice Springs Alice Springs 0872 1.20 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 Eromanga Eromanga 4480 1.27 http://nl.wikipedia.org/wiki/Eromanga http://www.geonames.org/maps/google_-27.22348_144.367981.html null AU Wandiligong Wandiligong 3744 1.06 http://en.wikipedia.org/wiki/Wandiligong http://www.geonames.org/maps/google_-36.11694444444444_146.15083333333334.html 2144799