From dcb490c29faafaef86de58b376cf88808a32790f Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 26 Jul 2005 17:51:25 +0000 Subject: [PATCH] arg... cnp error -- one last time git-svn-id: svn://svn.open-ils.org/ILS/trunk@1501 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 be94397723..59b344c224 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 cp.owning_lib, count(cp.id) as avail, 0 as tot + SELECT cn.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 cp.owning_lib, 0 as avail, count(cp.id) as tot + SELECT cn.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