From da2ba2759c4b48032386971011c09741b9453dc9 Mon Sep 17 00:00:00 2001
From: Nahuel ANGELINETTI <nahuel.angelinetti@biblibre.com>
Date: Wed, 30 Dec 2009 16:50:46 +0100
Subject: [PATCH] [followup](bug #3667) don't delete if member is guarantor

this fix cleanborrowers to don't delete guanrantors.
---
 C4/Members.pm | 1 +
 1 file changed, 1 insertion(+)

diff --git a/C4/Members.pm b/C4/Members.pm
index 7c5355e6e1..c7220d5214 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -1846,6 +1846,7 @@ sub GetBorrowersWhoHaveNotBorrowedSince {
         LEFT JOIN old_issues USING (borrowernumber)
         LEFT JOIN issues USING (borrowernumber) 
         WHERE  category_type <> 'S'
+        AND borrowernumber NOT IN (SELECT guarantorid FROM borrowers WHERE guarantorid IS NOT NULL AND guarantorid <> 0) 
    ";
     my @query_params;
     if ($filterbranch && $filterbranch ne ""){ 
-- 
2.39.5