Bug 3316 - Improve last 3 issues displayed on OPAC detail page

Signed-off-by: Galen Charlton <galen.charlton@liblime.com>

diff --git a/C4/Serials.pm b/C4/Serials.pm
index 7d81586..2de4ab3 100644 (file)
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -831,7 +831,7 @@ sub GetLatestSerials {
                         FROM     serial
                         WHERE    subscriptionid = ?
                         AND      (status =2 or status=4)
-                        ORDER BY planneddate DESC LIMIT 0,$limit
+                        ORDER BY publisheddate DESC LIMIT 0,$limit
                 ";
     my $sth = $dbh->prepare($strsth);
     $sth->execute($subscriptionid);