projects
/
google-map-tiles.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
f421bc6
)
require point to have city or country to end up in geo_count
author
Dobrica Pavlinusic
<dpavlin@rot13.org>
Sun, 3 Apr 2011 18:22:36 +0000
(20:22 +0200)
committer
Dobrica Pavlinusic
<dpavlin@rot13.org>
Sun, 3 Apr 2011 18:22:36 +0000
(20:22 +0200)
koha-import.pl
patch
|
blob
|
history
diff --git
a/koha-import.pl
b/koha-import.pl
index
9040fb9
..
d251ef7
100755
(executable)
--- a/
koha-import.pl
+++ b/
koha-import.pl
@@
-178,6
+178,7
@@
select
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
order by count(biblionumber) desc