From 9f0cc47e1aa5667dc0959bd5a8b115bd8289ce3b Mon Sep 17 00:00:00 2001 From: Michael Hafen Date: Wed, 10 Sep 2008 13:12:56 -0600 Subject: [PATCH] bug: query squashes issues.timestamp which circulation.pl needs to sort todaysissues Little change to the query so we get the right timestamp to sort on. Signed-off-by: Galen Charlton --- C4/Members.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Members.pm b/C4/Members.pm index 6c66dd9626..8a30ca636a 100644 --- a/C4/Members.pm +++ b/C4/Members.pm @@ -998,7 +998,7 @@ sub GetPendingIssues { my $dbh = C4::Context->dbh; my $sth = $dbh->prepare( - "SELECT * FROM issues + "SELECT *,issues.timestamp as timestamp FROM issues LEFT JOIN items ON issues.itemnumber=items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber -- 2.39.5