From d4f6022e436056f9b32e7ab2456c3256044faf8f Mon Sep 17 00:00:00 2001
From: =?utf8?q?Fr=C3=A9d=C3=A9ric=20Demians?= <f.demians@tamil.fr>
Date: Tue, 9 Jun 2009 10:17:07 +0200
Subject: [PATCH] Bug 3316 - Improve last 3 issues displayed on OPAC detail
 page

Signed-off-by: Galen Charlton <galen.charlton@liblime.com>
---
 C4/Serials.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Serials.pm b/C4/Serials.pm
index 7d81586c66..2de4ab324c 100644
--- 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);
-- 
2.39.2