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

(-)a/circ/pendingreserves.pl (-2 / +1 lines)
Lines 140-146 if ( $run_report ) { Link Here
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='W')
143
    AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found IS NOT NULL)
144
    AND issues.itemnumber IS NULL
144
    AND issues.itemnumber IS NULL
145
    AND reserves.priority <> 0 
145
    AND reserves.priority <> 0 
146
    AND reserves.suspend = 0
146
    AND reserves.suspend = 0
147
- 

Return to bug 9786