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

(-)a/reports/bor_issues_top.pl (-3 / +2 lines)
Lines 240-246 sub calculate { Link Here
240
    my $strcalc ;
240
    my $strcalc ;
241
241
242
# Processing average loanperiods
242
# Processing average loanperiods
243
    $strcalc .= "SELECT  CONCAT_WS('', borrowers.surname , \",\\t\", borrowers.firstname),  COUNT(*) AS RANK, borrowers.borrowernumber AS ID";
243
    $strcalc .= "SELECT  CONCAT_WS('', borrowers.surname , \",\\t\", borrowers.firstname),  COUNT(*) AS `RANK`, borrowers.borrowernumber AS ID";
244
    $strcalc .= " , $colfield " if ($colfield);
244
    $strcalc .= " , $colfield " if ($colfield);
245
    $strcalc .= " FROM `old_issues`
245
    $strcalc .= " FROM `old_issues`
246
                  LEFT JOIN  borrowers  USING(borrowernumber)
246
                  LEFT JOIN  borrowers  USING(borrowernumber)
Lines 265-271 sub calculate { Link Here
265
	}
265
	}
266
    $strcalc .= " GROUP BY borrowers.borrowernumber";
266
    $strcalc .= " GROUP BY borrowers.borrowernumber";
267
    $strcalc .= ", $colfield" if ($column);
267
    $strcalc .= ", $colfield" if ($column);
268
    $strcalc .= " ORDER BY RANK DESC";
268
    $strcalc .= " ORDER BY `RANK` DESC";
269
    $strcalc .= ",$colfield " if ($colfield);
269
    $strcalc .= ",$colfield " if ($colfield);
270
    $strcalc .= " LIMIT $limit" if ($limit);
270
    $strcalc .= " LIMIT $limit" if ($limit);
271
271
272
- 

Return to bug 28523