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

(-)a/reports/bor_issues_top.pl (-3 / +2 lines)
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
- 

Return to bug 28523