number of errors=3
number of warnings=0
country=IT
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='IT' order by title
[{key=IT,number=3}]
IT=http://poste.it/online/cercacap/home.do
countrycode title placename code dist url wpurl geonameid IT Mattinata Mattinata 71030 1.00 http://pt.wikipedia.org/wiki/Mattinata http://www.geonames.org/maps/google_41.71667_16.05.html 3173699 IT Pantelleria Pantelleria 91017 1.40 http://sv.wikipedia.org/wiki/Pantelleria http://www.geonames.org/maps/google_36.83333_11.95.html 2523890 IT Ustica Ustica 90010 1.06 http://nl.wikipedia.org/wiki/Ustica http://www.geonames.org/maps/google_38.71667_13.18333.html 2522818