From ec0c0ba3e017771818c67a2dc2219683e5fbfe74 Mon Sep 17 00:00:00 2001
From: Galen Charlton <galen.charlton@liblime.com>
Date: Fri, 14 Mar 2008 16:39:43 -0500
Subject: [PATCH] bug 1742: don't include items on loan in pending holds report

Signed-off-by: Joshua Ferraro <jmf@liblime.com>
---
 circ/pendingreserves.pl | 1 +
 1 file changed, 1 insertion(+)

diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl
index d05c8cfe5f..b454644f55 100755
--- a/circ/pendingreserves.pl
+++ b/circ/pendingreserves.pl
@@ -107,6 +107,7 @@ my $strsth =
  LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
  WHERE reserves.found is NULL 
  $sqldatewhere
+ AND items.itemnumber NOT IN (SELECT itemnumber FROM issues)
  AND reserves.itemnumber is NULL";
 
 if (C4::Context->preference('IndependantBranches')){
-- 
2.20.1