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