Lines 1115-1121
sub GetAllIssues {
Link Here
|
1115 |
LEFT JOIN items on items.itemnumber=old_issues.itemnumber |
1115 |
LEFT JOIN items on items.itemnumber=old_issues.itemnumber |
1116 |
LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber |
1116 |
LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber |
1117 |
LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber |
1117 |
LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber |
1118 |
WHERE borrowernumber=? |
1118 |
WHERE borrowernumber=? AND old_issues.itemnumber IS NOT NULL |
1119 |
order by $order"; |
1119 |
order by $order"; |
1120 |
if ( $limit != 0 ) { |
1120 |
if ( $limit != 0 ) { |
1121 |
$query .= " limit $limit"; |
1121 |
$query .= " limit $limit"; |
1122 |
- |
|
|