From 6d6c62c0f4b40e4571d725f580f0d4a6caf0df64 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 26 Jul 2005 17:48:12 +0000 Subject: [PATCH] arg... cnp error git-svn-id: svn://svn.open-ils.org/ILS/trunk@1499 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 2613387435..caaf4c012f 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm @@ -202,7 +202,7 @@ sub global_record_copy_count { FROM $cn_table cn JOIN $cp_table cp ON (cn.id = cp.call_number) JOIN $cs_table cs ON (cs.id = cp.status) - JOIN $cl_table cs ON (cl.id = cp.location) + JOIN $cl_table cl ON (cl.id = cp.location) WHERE cn.record = ? AND cp.status = 0 $copies_visible @@ -212,7 +212,7 @@ sub global_record_copy_count { FROM $cn_table cn JOIN $cp_table cp ON (cn.id = cp.call_number) JOIN $cs_table cs ON (cs.id = cp.status) - JOIN $cl_table cs ON (cl.id = cp.location) + JOIN $cl_table cl ON (cl.id = cp.location) WHERE cn.record = ? $copies_visible GROUP BY 1 -- 2.43.2