|
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 |
- |
|
|