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:
8a58703
)
import just new cities
author
Dobrica Pavlinusic
<dpavlin@rot13.org>
Sun, 3 Apr 2011 15:38:44 +0000
(17:38 +0200)
committer
Dobrica Pavlinusic
<dpavlin@rot13.org>
Sun, 3 Apr 2011 15:38:44 +0000
(17:38 +0200)
koha-import.pl
patch
|
blob
|
history
diff --git
a/koha-import.pl
b/koha-import.pl
index
21ba1b4
..
6729adc
100755
(executable)
--- a/
koha-import.pl
+++ b/
koha-import.pl
@@
-142,7
+142,7
@@
create table geo_city (
my $sth_insert = $g_dbh->prepare(qq{insert into geo_city values (?,?,?,?,?,?,?,?)});
my $sth = $g_dbh->prepare(qq{
-select count(*),city from geo_biblioitems group by city order by count(city) desc
+select count(*),city from geo_biblioitems
where city not in (select city_koha from geo_city)
group by city order by count(city) desc
});
$sth->execute;