From c75406fc0566fc14eda5033029f3768e7609b8c2 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Mon, 4 Apr 2011 15:38:39 +0200 Subject: [PATCH] fix biblionumber --- koha.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/koha.pl b/koha.pl index e5f981a..7e34821 100755 --- 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 -- 2.20.1