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

(-)a/circ/pendingreserves.pl (-1 / +2 lines)
Lines 210-215 my $strsth = Link Here
210
        LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber
210
        LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber
211
        LEFT JOIN issues ON items.itemnumber=issues.itemnumber
211
        LEFT JOIN issues ON items.itemnumber=issues.itemnumber
212
        LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber
212
        LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber
213
        LEFT JOIN default_branch_item_rules ON items.itype=default_branch_item_rules.itemtype
213
    WHERE
214
    WHERE
214
    reserves.found IS NULL
215
    reserves.found IS NULL
215
    $sqldatewhere
216
    $sqldatewhere
Lines 220-225 my $strsth = Link Here
220
    AND reserves.priority <> 0 
221
    AND reserves.priority <> 0 
221
    AND reserves.suspend = 0
222
    AND reserves.suspend = 0
222
    AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0
223
    AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0
224
    AND default_branch_item_rules.holdallowed != 0
223
    ";
225
    ";
224
    # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when 
226
    # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when 
225
    #    multiple patrons have a hold on an item
227
    #    multiple patrons have a hold on an item
226
- 

Return to bug 13640