[Koha-patches] [PATCH 56/78] pending reserves, improve perfs (not related to new_acq)

[paul.poulain at biblibre.com]

From: Paul Poulain <paul.poulain at biblibre.com>

---
 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