fix biblionumber

[google-map-tiles.git] / koha-import.pl

diff --git a/koha-import.pl b/koha-import.pl
index 5a1921f..b2ba4d1 100755 (executable)
--- a/koha-import.pl
+++ b/koha-import.pl
@@ -172,13 +172,15 @@ $g_dbh->do(qq{
 
 select
        count(biblionumber)
-       ,point(avg(lat),avg(lng))
+       ,point(lat,lng)
        ,geo_city.city
-       ,min(country) as country
+       ,geo_city.city_koha
+       ,country
 into geo_count
 from geo_biblioitems
 join geo_city on city_koha = geo_biblioitems.city
-group by geo_city.city
+where length(geo_city.city) > 1
+group by geo_city.city, country, lat, lng, city_koha
 order by count(biblionumber) desc
 
 });