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

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

Return to bug 9320