projects
/
google-map-tiles.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
use Directory instead of Location to allow vhost overlay
[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)
select
count(biblionumber)
- ,point(
avg(lat),avg(lng)
)
+ ,point(
lat,lng
)
,geo_city.city
,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
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
});
order by count(biblionumber) desc
});