From ce015d0e470a76e3d714358f07cd7e6eb2012c2e Mon Sep 17 00:00:00 2001
From: "Meenakshi.R" <meenakshi.r@osslabs.biz>
Date: Wed, 23 May 2012 10:37:19 +0530
Subject: [PATCH] Bug 6655 - Sorting order of serial issues in OPAC

Works as advertised.

Signed-off-by: Elliott Davis <elliott@bywatersolutions.com>
Signed-off-by: Paul Poulain <paul.poulain@biblibre.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
---
 C4/Serials.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Serials.pm b/C4/Serials.pm
index 42e9e30d3d..f6e743db9c 100644
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -741,7 +741,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.5