https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40324 --- Comment #1 from Joe Koop <joek@churchrenewal.com> --- I've done some more poking around. 0 of my 2150 unrestricted patrons[1] have this issue. 257 of my 827 restricted patrons[2] have this issue. ----- [1]: SELECT borrowers.borrowernumber, borrowers.cardnumber, borrowers.surname, borrowers.firstname, borrowers.debarred, borrowers.debarredcomment FROM borrowers WHERE borrowers.debarred IS NULL AND NOT EXISTS ( SELECT 1 FROM borrower_debarments WHERE borrower_debarments.borrowernumber = borrowers.borrowernumber ) ORDER BY borrowers.cardnumber [2]: SELECT borrowers.borrowernumber, borrowers.cardnumber, borrowers.surname, borrowers.firstname, borrowers.debarred, borrowers.debarredcomment FROM borrowers WHERE borrowers.debarred IS NOT NULL OR EXISTS ( SELECT 1 FROM borrower_debarments WHERE borrower_debarments.borrowernumber = borrowers.borrowernumber ) ORDER BY borrowers.cardnumber -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.