From 2892f6e69b063d5a9b4b83c098a5e057a5b25873 Mon Sep 17 00:00:00 2001
From: Michael Hafen <mdhafen@tech.washk12.org>
Date: Wed, 1 Oct 2008 14:14:56 -0600
Subject: [PATCH] bugfix: Sort previous borrowers descending in Items.pm for
 moredetail.pl

The list of previous borrowers on moredetail.pl shows the three oldest
rather than the three most recent as I expected.  This changes the sql
to order descending so we get the three most recent.

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

diff --git a/C4/Items.pm b/C4/Items.pm
index 1f92491a93..3aef697c5b 100644
--- a/C4/Items.pm
+++ b/C4/Items.pm
@@ -1295,6 +1295,7 @@ sub GetItemsInfo {
         my $sth2 = $dbh->prepare("SELECT * FROM old_issues,borrowers
                                     WHERE itemnumber = ?
                                     AND old_issues.borrowernumber = borrowers.borrowernumber
+                                    ORDER BY returndate DESC
                                     LIMIT 3");
         $sth2->execute($data->{'itemnumber'});
         my $ii = 0;
-- 
2.39.5