@@ -, +, @@ --- circ/pendingreserves.pl | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) --- a/circ/pendingreserves.pl +++ a/circ/pendingreserves.pl @@ -139,7 +139,8 @@ if ( $run_report ) { reserves.found IS NULL $sqldatewhere AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) - AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) + AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL) + AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found IS NOT NULL) AND issues.itemnumber IS NULL AND reserves.priority <> 0 AND reserves.suspend = 0 --