[Koha-patches] [PATCH] Patch to pending reservres for weird case where item numbers

[Darrell Ulm]

---
 circ/pendingreserves.pl |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl
index 0a6fa2f..3f4fe06 100755
--- a/circ/pendingreserves.pl
+++ b/circ/pendingreserves.pl
@@ -147,7 +147,7 @@ my $strsth =
 reserves.found IS NULL
  $sqldatewhere
 AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
-AND items.itemnumber NOT IN (SELECT itemnumber FROM issues)
+AND items.itemnumber NOT IN (SELECT itemnumber FROM issues WHERE itemnumber IS NOT NULL)
 AND reserves.priority <> 0 
 AND reserves.itemnumber is NULL
 AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0
-- 
1.5.3.7