From 316485b1c4bb1cfa4c0de19e857e692d34351234 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@biblibre.com>
Date: Wed, 25 Feb 2015 10:44:00 +0100
Subject: [PATCH] Bug 13740: Fix null vs not null in the query

The previous patch did not work, only patrons *with* guanrantees were
deleted!

Signed-off-by: Koha Team AMU <koha.aixmarseille@gmail.com>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
---
 C4/Members.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Members.pm b/C4/Members.pm
index 7c3f9f6772..4ca83b9b2b 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -2124,7 +2124,7 @@ sub GetBorrowersToExpunge {
         LEFT JOIN old_issues USING (borrowernumber)
         LEFT JOIN issues USING (borrowernumber) 
         WHERE  category_type <> 'S'
-        AND tmp.guarantorid IS NOT NULL
+        AND tmp.guarantorid IS NULL
    |;
 
     my @query_params;
-- 
2.39.5