Lines 142-147
if ( $run_report ) {
Link Here
|
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 issues.itemnumber IS NULL |
143 |
AND issues.itemnumber IS NULL |
144 |
AND reserves.priority <> 0 |
144 |
AND reserves.priority <> 0 |
|
|
145 |
AND reserves.suspend = 0 |
145 |
AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0 |
146 |
AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0 |
146 |
"; |
147 |
"; |
147 |
# GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when |
148 |
# GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when |