From 2e3139d42c1a6a72108739efb4300803fa71ebc7 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Sat, 9 Feb 2013 13:15:31 +1300 Subject: [PATCH] Follow up fixing the case of SQL --- circ/pendingreserves.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index 089339668e..604b84fa30 100755 --- a/circ/pendingreserves.pl +++ b/circ/pendingreserves.pl @@ -140,8 +140,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 reserves where found='W') + AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL) + AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found='W') AND issues.itemnumber IS NULL AND reserves.priority <> 0 AND reserves.suspend = 0 -- 2.39.5