|
Lines 225-231
my $strsth =
Link Here
|
| 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) |
| 227 |
AND issues.itemnumber IS NULL |
227 |
AND issues.itemnumber IS NULL |
| 228 |
AND reserves.priority <> 0 |
228 |
AND reserves.priority = 1 |
| 229 |
AND reserves.suspend = 0 |
229 |
AND reserves.suspend = 0 |
| 230 |
AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0 |
230 |
AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0 |
| 231 |
AND ( circulation_rules.rule_value IS NULL OR circulation_rules.rule_value != 0 ) |
231 |
AND ( circulation_rules.rule_value IS NULL OR circulation_rules.rule_value != 0 ) |
| 232 |
- |
|
|