Lines 104-110
if ($order eq "biblio") {
Link Here
|
104 |
$sqlorderby = " ORDER BY reservecount DESC "; |
104 |
$sqlorderby = " ORDER BY reservecount DESC "; |
105 |
} |
105 |
} |
106 |
|
106 |
|
107 |
my $on_order_sql = ( $include_on_order_items ) ? "+ aqorders.quantity" : ""; |
107 |
my $on_order_sql1 = ( $include_on_order_items ) ? "+ COALESCE(aqorders.quantity, 0)" : q{}; |
|
|
108 |
my $on_order_sql2 = ( $include_on_order_items ) ? "LEFT JOIN aqorders ON reserves.biblionumber=aqorders.biblionumber" : q{}; |
108 |
my $not_for_loan_comparison = ( $include_will_be_available ) ? "<=" : "="; |
109 |
my $not_for_loan_comparison = ( $include_will_be_available ) ? "<=" : "="; |
109 |
|
110 |
|
110 |
my $strsth = |
111 |
my $strsth = |
Lines 128-138
my $strsth =
Link Here
|
128 |
biblio.title, |
129 |
biblio.title, |
129 |
biblio.author, |
130 |
biblio.author, |
130 |
count(DISTINCT reserves.borrowernumber) as reservecount, |
131 |
count(DISTINCT reserves.borrowernumber) as reservecount, |
131 |
count(DISTINCT items.itemnumber) $on_order_sql as itemcount |
132 |
count(DISTINCT items.itemnumber) $on_order_sql1 as itemcount |
132 |
FROM reserves |
133 |
FROM reserves |
133 |
LEFT JOIN items ON items.biblionumber=reserves.biblionumber |
134 |
LEFT JOIN items ON items.biblionumber=reserves.biblionumber |
134 |
LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber |
135 |
LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber |
135 |
LEFT JOIN aqorders ON reserves.biblionumber=aqorders.biblionumber |
136 |
$on_order_sql2 |
136 |
WHERE |
137 |
WHERE |
137 |
notforloan $not_for_loan_comparison 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0 |
138 |
notforloan $not_for_loan_comparison 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0 |
138 |
$sqldatewhere |
139 |
$sqldatewhere |
139 |
- |
|
|