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

diff --git a/koha-import.pl b/koha-import.pl
index 9040fb9..b2ba4d1 100755
--- a/koha-import.pl
+++ b/koha-import.pl
@@ -174,11 +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
-group by geo_city.city, country, lat, lng
+where length(geo_city.city) > 1
+group by geo_city.city, country, lat, lng, city_koha
 order by count(biblionumber) desc
 
 });