From f6e8c81086a7bc4b0af0e8a6cd7f290fb194a106 Mon Sep 17 00:00:00 2001
From: Katrin Fischer <katrin.fischer.83@web.de>
Date: Mon, 24 Jul 2017 23:26:04 +0200
Subject: [PATCH] Bug 18931 - Follow up - Typo fix in SQL statement

Fixes the table alias in the SQL statement for items and
adds items to the if clause for showing data problems.

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit c3dca8c24b53aa63838687f536a5509855ccc21c)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
(cherry picked from commit 62529a83e9398e3ee23bbca7b8b6bd6fb3b509df)
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
---
 about.pl | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/about.pl b/about.pl
index 1e7bd8f66f..5fcf94aead 100755
--- a/about.pl
+++ b/about.pl
@@ -297,7 +297,7 @@ if (  C4::Context->preference('WebBasedSelfCheck')
         { Slice => {} }
     );
     my $items = $dbh->selectall_arrayref(
-        q|select i.itemnumber from items b join deleteditems di on i.itemnumber=di.itemnumber|,
+        q|select i.itemnumber from items i join deleteditems di on i.itemnumber=di.itemnumber|,
         { Slice => {} }
     );
     my $checkouts = $dbh->selectall_arrayref(
@@ -308,7 +308,7 @@ if (  C4::Context->preference('WebBasedSelfCheck')
         q|select r.reserve_id from reserves r join old_reserves o on r.reserve_id=o.reserve_id|,
         { Slice => {} }
     );
-    if ( @$patrons or @$biblios or @$checkouts or @$holds ) {
+    if ( @$patrons or @$biblios or @$items or @$checkouts or @$holds ) {
         $template->param(
             has_ai_issues => 1,
             ai_patrons    => $patrons,
-- 
2.39.5