https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25875 --- Comment #2 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 106284 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=106284&action=edit Bug 25875: Move check for module_bit and code to the JOIN If we limit the JOIN to rows with the correct subpermission we won't duplicate the returned patrons To test: 1 - Give a patron full acquisitions permissions 2 - Also give them several subpermissions on other areas 3 - Go to Acquisitions 4 - Edit a fund 5 - Add a user to the fund 6 - Search for user above 7 - They return multiple times in results 8 - Apply patch 9 - Restart all the things 10 - Repeat search 11 - Patron appears once -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.