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

(-)a/reports/bor_issues_top.pl (-2 / +1 lines)
Lines 279-285 sub calculate { Link Here
279
    my $strcalc ;
279
    my $strcalc ;
280
280
281
# Processing average loanperiods
281
# Processing average loanperiods
282
    $strcalc .= "SELECT  CONCAT(borrowers.surname , \",\\t\",borrowers.firstname),  COUNT(*) AS RANK, borrowers.borrowernumber AS ID";
282
    $strcalc .= "SELECT  CONCAT_WS('', borrowers.surname , \",\\t\", borrowers.firstname),  COUNT(*) AS RANK, borrowers.borrowernumber AS ID";
283
    $strcalc .= " , $colfield " if ($colfield);
283
    $strcalc .= " , $colfield " if ($colfield);
284
    $strcalc .= " FROM `old_issues`
284
    $strcalc .= " FROM `old_issues`
285
                  LEFT JOIN  borrowers  USING(borrowernumber)
285
                  LEFT JOIN  borrowers  USING(borrowernumber)
286
- 

Return to bug 1750