From f380d243f205e1b84f717162cdad3739e5bfc4db Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 26 Jun 2014 14:55:50 -0400 Subject: [PATCH] Bug 9011 [QA Followup] Signed-off-by: Nick Clemens http://bugs.koha-community.org/show_bug.cgi?id=6473 --- C4/Circulation.pm | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/C4/Circulation.pm b/C4/Circulation.pm index 21c40de..6914b03 100644 --- a/C4/Circulation.pm +++ b/C4/Circulation.pm @@ -3104,7 +3104,8 @@ sub AnonymiseIssueHistory { } if ( C4::Context->preference('StoreLastBorrower') ) { - $query .= " AND issue_id IN ( SELECT issue_id FROM old_issues GROUP BY itemnumber ORDER BY issue_id DESC ) "; + # Do not delete the newest old_issue for any itemnumber + $query .= " AND issue_id NOT IN ( SELECT issue_id FROM ( SELECT * FROM old_issues ORDER BY issue_id DESC ) AS oi GROUP BY itemnumber ) "; } my $sth = $dbh->prepare($query); -- 1.7.2.5