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

diff --git a/koha-import.pl b/koha-import.pl
index 6729adc..b2ba4d1 100755
--- a/koha-import.pl
+++ b/koha-import.pl
@@ -166,3 +166,21 @@ while( my $row = $sth->fetchrow_hashref ) {
 		, dump($location)
 	);
 }
+
+eval { $g_dbh->do(qq{ drop table geo_count }) };
+$g_dbh->do(qq{
+
+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, city_koha
+order by count(biblionumber) desc
+
+});