From: Paul Poulain <[email protected]>
---
circ/pendingreserves.pl | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl
index 1c866eb..b18d17b 100755
--- a/circ/pendingreserves.pl
+++ b/circ/pendingreserves.pl
@@ -143,11 +143,12 @@ my $strsth =
LEFT JOIN items ON items.biblionumber=reserves.biblionumber
LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber
+ LEFT JOIN issues ON items.itemnumber=issues.itemnumber
WHERE
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 issues.itemnumber IS NULL
AND reserves.priority <> 0
AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0
";
--
1.6.0.4
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
