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

(-)a/circ/pendingreserves.pl (-2 / +1 lines)
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
- 

Return to bug 24301