From ff4bfb7644cfa4c9d7171c09850707cdd5f61c2d Mon Sep 17 00:00:00 2001
From: Katrin Fischer <katrin.fischer.83@web.de>
Date: Mon, 30 Jan 2017 16:47:23 +0100
Subject: [PATCH] Bug 17902: Follow-up fixing SQL statement

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Mirko Tietgen <mirko@abunchofthings.net>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit 40cb8e3b7579987d0d461e8da6e350228722727c)
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
(cherry picked from commit dea3bc855d011b47541ed664566940c08ca52ceb)
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
---
 C4/Serials.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Serials.pm b/C4/Serials.pm
index 519a14fc41..fcd2a13567 100644
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -743,7 +743,7 @@ sub GetSerials2 {
                  FROM     serial 
                  WHERE    subscriptionid=?
             |
-            . q| AND status IN (| . join( ",", ('?') x @$statuses ) . ")" . q|)|
+            . q| AND status IN (| . join( ",", ('?') x @$statuses ) . q|)|
             . q|
                  ORDER BY publisheddate,serialid DESC
     |;
-- 
2.39.5