From ef8690cbf2d9586c0f350c5f1b70ebffdc87461c Mon Sep 17 00:00:00 2001
From: kados <kados>
Date: Fri, 7 Jul 2006 21:26:24 +0000
Subject: [PATCH] don't hide items that have notforloan < 0

---
 C4/SearchMarc.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/SearchMarc.pm b/C4/SearchMarc.pm
index c4e89ecf89..dee0ff7b1e 100644
--- a/C4/SearchMarc.pm
+++ b/C4/SearchMarc.pm
@@ -396,7 +396,7 @@ if (C4::Context->preference("sortbynonfiling")) {
 		$sth_itemCN = $dbh->prepare("
   SELECT items.holdingbranch, items.location, items.itemcallnumber, count(*) AS cnt, items.itemnumber, items.notforloan
   FROM items 
-  WHERE biblionumber=? AND (itemlost = 0 OR itemlost IS NULL) AND (notforloan = 0 OR notforloan IS NULL)
+  WHERE biblionumber=? AND (itemlost = 0 OR itemlost IS NULL) AND (notforloan < 1 OR notforloan IS NULL)
   GROUP BY items.holdingbranch, items.location, items.itemcallnumber
   ORDER BY homebranch");
 	} else {
-- 
2.39.5