From 55e477aca734cab79449a5b6ded3a0783719503e 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] [PASSED QA] 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>
---
 C4/Members.pm |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/C4/Members.pm b/C4/Members.pm
index c1b4b1e..23b489f 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -2126,7 +2126,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;
-- 
1.7.2.5