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

(-)a/circ/pendingreserves.pl (-2 / +2 lines)
Lines 139-145 if ( $run_report ) { Link Here
139
    reserves.found IS NULL
139
    reserves.found IS NULL
140
    $sqldatewhere
140
    $sqldatewhere
141
    AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber)
141
    AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber)
142
    AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
142
    AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL)
143
    AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found IS NOT NULL)
143
    AND issues.itemnumber IS NULL
144
    AND issues.itemnumber IS NULL
144
    AND reserves.priority <> 0 
145
    AND reserves.priority <> 0 
145
    AND reserves.suspend = 0
146
    AND reserves.suspend = 0
146
- 

Return to bug 9786