From 930dcb1baf6864ef8ab15ca004d9870ec4ec7664 Mon Sep 17 00:00:00 2001
From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Date: Wed, 14 Mar 2018 13:22:46 +0100
Subject: [PATCH] Bug 19454: (QA follow-up) Fix selection on categorycode

A follow-up on a preceding report introduced a join instead of a
subquery. This made the categorycode ambiguous.

Test plan:
See former patches.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
---
 misc/maintenance/borrowers-force-messaging-defaults.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/misc/maintenance/borrowers-force-messaging-defaults.pl b/misc/maintenance/borrowers-force-messaging-defaults.pl
index e327834..d88d387 100755
--- a/misc/maintenance/borrowers-force-messaging-defaults.pl
+++ b/misc/maintenance/borrowers-force-messaging-defaults.pl
@@ -57,7 +57,7 @@ WHERE bo.dateenrolled >= ?|;
     if( $no_overwrite ) {
         $sql .= " AND mp.borrowernumber IS NULL";
     }
-    $sql .= " AND categorycode = ?" if $category;
+    $sql .= " AND bo.categorycode = ?" if $category;
     my $sth = $dbh->prepare($sql);
     $sth->execute($since, $category || () );
     my $cnt = 0;
-- 
2.1.4