X-Git-Url: http://git.rot13.org/?p=google-map-tiles.git;a=blobdiff_plain;f=koha.pl;h=7e3482190fde7072e000129d402cd69221483580;hp=e5f981abddb128bb6fc01652c8b588fd840ebe0e;hb=HEAD;hpb=a3949f09f09d9cde97c7146f617c8e03341fa3bc 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