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

(-)a/circ/pendingreserves.pl (-2 / +1 lines)
Lines 214-220 my $strsth = Link Here
214
        LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber
214
        LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber
215
        LEFT JOIN issues ON items.itemnumber=issues.itemnumber
215
        LEFT JOIN issues ON items.itemnumber=issues.itemnumber
216
        LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber
216
        LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber
217
        LEFT JOIN circulation_rules ON items.itype=circulation_rules.itemtype AND rule_name = 'holdallowed' AND circulation_rules.branchcode IS NULL AND circulation_rules.categorycode IS NULL
217
        LEFT JOIN circulation_rules ON ( items.itype=circulation_rules.itemtype AND rule_name = 'holdallowed' AND circulation_rules.branchcode IS NULL AND circulation_rules.categorycode IS NULL )
218
    WHERE
218
    WHERE
219
    reserves.found IS NULL
219
    reserves.found IS NULL
220
    $sqldatewhere
220
    $sqldatewhere
221
- 

Return to bug 23484