X-Git-Url: http://git.rot13.org/?p=google-map-tiles.git;a=blobdiff_plain;f=koha-import.pl;h=b2ba4d1a91b9ea158e41a4d0c3ac8b0e64bc8232;hp=5a1921f4b0f306ecb94c166d21770e652b6b67c9;hb=HEAD;hpb=0b75d839e56b3275475122db7ba7edc886e38108

diff --git a/koha-import.pl b/koha-import.pl
index 5a1921f..b2ba4d1 100755
--- 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
 
 });