number of errors=3
number of warnings=0
country=FR
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='FR' order by title
[{key=FR,number=3}]
FR=http://www.laposte.fr/Particulier/Utiliser-nos-outils-pratiques/Outils-et-documents/Trouvez-un-code-postal
countrycode title placename code dist url wpurl geonameid FR Sainte-Marie-de-Gosse Sainte-Marie-de-Gosse 40390 1.00 http://sv.wikipedia.org/wiki/Sainte-Marie-de-Gosse http://www.geonames.org/maps/google_43.5575_-1.2369.html 2980430 FR Saint-Jean-le-Blanc Saint-Jean-le-Blanc 45650 2.77 http://pt.wikipedia.org/wiki/Saint-Jean-le-Blanc http://www.geonames.org/maps/google_48.935556_-0.653611.html 2979226 FR Vieux Vieux 14930 5.61 http://pt.wikipedia.org/wiki/Vieux http://www.geonames.org/maps/google_43.9942_1.8733.html 2969237