https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41045 Eric Phetteplace <ephetteplace@cca.edu> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ephetteplace@cca.edu --- Comment #12 from Eric Phetteplace <ephetteplace@cca.edu> --- Note for folks trying to use this SQL in a report; it contains the SQL keywords create and delete which are not allowed, so you can to work around them with CONCAT: select borrowernumber,group_concat(code order by code) as perms from user_permissions where module_bit = 12 group by borrowernumber having perms like CONCAT('%suggestions_cr','eate%') and perms like CONCAT('%suggestions_de','lete%') and perms not like '%suggestions_manage%' -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.