Lines 249-255
sub calculate {
Link Here
|
249 |
my $strcalc ; |
249 |
my $strcalc ; |
250 |
|
250 |
|
251 |
# Processing average loanperiods |
251 |
# Processing average loanperiods |
252 |
$strcalc .= "SELECT CONCAT_WS('', borrowers.surname , \",\\t\", borrowers.firstname), COUNT(*) AS RANK, borrowers.borrowernumber AS ID"; |
252 |
$strcalc .= "SELECT CONCAT_WS('', borrowers.surname , \",\\t\", borrowers.firstname), COUNT(*) AS `RANK`, borrowers.borrowernumber AS ID"; |
253 |
$strcalc .= " , $colfield " if ($colfield); |
253 |
$strcalc .= " , $colfield " if ($colfield); |
254 |
$strcalc .= " FROM `old_issues` |
254 |
$strcalc .= " FROM `old_issues` |
255 |
LEFT JOIN borrowers USING(borrowernumber) |
255 |
LEFT JOIN borrowers USING(borrowernumber) |
Lines 274-280
sub calculate {
Link Here
|
274 |
} |
274 |
} |
275 |
$strcalc .= " GROUP BY borrowers.borrowernumber"; |
275 |
$strcalc .= " GROUP BY borrowers.borrowernumber"; |
276 |
$strcalc .= ", $colfield" if ($column); |
276 |
$strcalc .= ", $colfield" if ($column); |
277 |
$strcalc .= " ORDER BY RANK DESC"; |
277 |
$strcalc .= " ORDER BY `RANK` DESC"; |
278 |
$strcalc .= ",$colfield " if ($colfield); |
278 |
$strcalc .= ",$colfield " if ($colfield); |
279 |
$strcalc .= " LIMIT $limit" if ($limit); |
279 |
$strcalc .= " LIMIT $limit" if ($limit); |
280 |
|
280 |
|
281 |
- |
|
|