projects
/
google-map-tiles.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
fix typo
[google-map-tiles.git]
/
koha-import.pl
diff --git
a/koha-import.pl
b/koha-import.pl
index
d251ef7
..
b2ba4d1
100755
(executable)
--- a/
koha-import.pl
+++ b/
koha-import.pl
@@
-174,12
+174,13
@@
select
count(biblionumber)
,point(lat,lng)
,geo_city.city
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
,country
into geo_count
from geo_biblioitems
join geo_city on city_koha = geo_biblioitems.city
-where length(geo_city.city) > 1
or length(country) > 1
-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
});
order by count(biblionumber) desc
});