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

(-)a/C4/Circulation.pm (-3 / +5 lines)
Lines 3975-3980 sub GetTopIssues { Link Here
3975
3975
3976
    my $dbh = C4::Context->dbh;
3976
    my $dbh = C4::Context->dbh;
3977
    my $query = q{
3977
    my $query = q{
3978
        SELECT * FROM (
3978
        SELECT b.biblionumber, b.title, b.author, bi.itemtype, bi.publishercode,
3979
        SELECT b.biblionumber, b.title, b.author, bi.itemtype, bi.publishercode,
3979
          bi.place, bi.publicationyear, b.copyrightdate, bi.pages, bi.size,
3980
          bi.place, bi.publicationyear, b.copyrightdate, bi.pages, bi.size,
3980
          i.ccode, SUM(i.issues) AS count
3981
          i.ccode, SUM(i.issues) AS count
Lines 4012-4022 sub GetTopIssues { Link Here
4012
    }
4013
    }
4013
4014
4014
    $query .= q{
4015
    $query .= q{
4015
        GROUP BY b.biblionumber
4016
        GROUP BY b.biblionumber, b.title, b.author, bi.itemtype, bi.publishercode,
4016
        HAVING count > 0
4017
          bi.place, bi.publicationyear, b.copyrightdate, bi.pages, bi.size,
4018
          i.ccode
4017
        ORDER BY count DESC
4019
        ORDER BY count DESC
4018
    };
4020
    };
4019
4021
4022
    $query .= q{ ) xxx WHERE count > 0 };
4020
    $count = int($count);
4023
    $count = int($count);
4021
    if ($count > 0) {
4024
    if ($count > 0) {
4022
        $query .= "LIMIT $count";
4025
        $query .= "LIMIT $count";
4023
- 

Return to bug 20144