fix biblionumber master
authorDobrica Pavlinusic <dpavlin@rot13.org>
Mon, 4 Apr 2011 13:38:39 +0000 (15:38 +0200)
committerDobrica Pavlinusic <dpavlin@rot13.org>
Mon, 4 Apr 2011 13:38:39 +0000 (15:38 +0200)
koha.pl

diff --git a/koha.pl b/koha.pl
index e5f981a..7e34821 100755 (executable)
--- a/koha.pl
+++ b/koha.pl
@@ -66,7 +66,7 @@ limit 1
 
        my $sth = $dbh->prepare(qq{
 select
-       author, title, max(bi.biblionumber), count(title)
+       author, title, max(bi.biblionumber) as biblionumber, count(title)
 from geo_city c
 join geo_biblioitems bi on bi.city = c.city_koha
 join biblio b on b.biblionumber = bi.biblionumber