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 |
- |
|
|