X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=koha-import.pl;h=b2ba4d1a91b9ea158e41a4d0c3ac8b0e64bc8232;hb=4649b288cf5b5821683d8686d5eab2a496e3f2bf;hp=aa7805bc4c1bb4109c26a723101126d9175165a1;hpb=ee3e882503afede57ed4050159888adf33f9ef64;p=google-map-tiles.git

diff --git a/koha-import.pl b/koha-import.pl
index aa7805b..b2ba4d1 100755
--- a/koha-import.pl
+++ b/koha-import.pl
@@ -174,12 +174,13 @@ select
 	count(biblionumber)
 	,point(lat,lng)
 	,geo_city.city
+	,geo_city.city_koha
 	,country
 into geo_count
 from geo_biblioitems
 join geo_city on city_koha = geo_biblioitems.city
 where length(geo_city.city) > 1
-group by geo_city.city, country, lat, lng
+group by geo_city.city, country, lat, lng, city_koha
 order by count(biblionumber) desc
 
 });