From 682299ed931b60cee808a94ad47dd031245026d6 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Tue, 28 Apr 2009 23:10:12 +0200 Subject: [PATCH] pending reserves, improve perfs (not related to new_acq) --- circ/pendingreserves.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index 7fc02a132b..74cd4dfb8d 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 "; -- 2.39.2