From 0cfdad7d9183e3b2618d01e93775fce828bec121 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 1 Apr 2011 16:28:37 -0400 Subject: [PATCH] remove these as well, to prevent errors creating items --- Open-ILS/src/sql/Pg/999.functions.global.sql | 2 -- 1 file changed, 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql index 82cb509afd..0026b20ef4 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -1193,8 +1193,6 @@ BEGIN JOIN asset.copy_location cl ON (cp.location = cl.id) JOIN config.copy_status cs ON (cp.status = cs.id) WHERE NOT cp.deleted - AND NOT cn.deleted - AND NOT b.deleted AND cs.opac_visible AND cl.opac_visible AND cp.opac_visible -- 2.11.0