View | Details | Raw Unified | Return to bug 25726
Collapse All | Expand All

(-)a/circ/pendingreserves.pl (-2 / +1 lines)
Lines 223-229 my $strsth = Link Here
223
    $sqldatewhere
223
    $sqldatewhere
224
    AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber)
224
    AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber)
225
    AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
225
    AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
226
    AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL)
226
    AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL AND itemnumber IS NOT NULL)
227
    AND issues.itemnumber IS NULL
227
    AND issues.itemnumber IS NULL
228
    AND reserves.priority <> 0 
228
    AND reserves.priority <> 0 
229
    AND reserves.suspend = 0
229
    AND reserves.suspend = 0
230
- 

Return to bug 25726