From 832abb163b0fff1e54a5834a63ddc3fdea138014 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 26 Jul 2005 17:49:30 +0000 Subject: [PATCH] arg... cnp error git-svn-id: svn://svn.open-ils.org/ILS/trunk@1500 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../perlmods/OpenILS/Application/Storage/Publisher/biblio.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm index caaf4c012f..be94397723 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm @@ -198,7 +198,7 @@ sub global_record_copy_count { SELECT owning_lib, sum(avail), sum(tot) FROM ( - SELECT owning_lib, count(cp.id) as avail, 0 as tot + SELECT cp.owning_lib, count(cp.id) as avail, 0 as tot FROM $cn_table cn JOIN $cp_table cp ON (cn.id = cp.call_number) JOIN $cs_table cs ON (cs.id = cp.status) @@ -208,7 +208,7 @@ sub global_record_copy_count { $copies_visible GROUP BY 1 UNION - SELECT owning_lib, 0 as avail, count(cp.id) as tot + SELECT cp.owning_lib, 0 as avail, count(cp.id) as tot FROM $cn_table cn JOIN $cp_table cp ON (cn.id = cp.call_number) JOIN $cs_table cs ON (cs.id = cp.status) -- 2.43.2