https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24741 David Gustafsson <glasklas@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |glasklas@gmail.com --- Comment #1 from David Gustafsson <glasklas@gmail.com> --- I'm not 100%, but think a correct query to remove duplicates could be written like: DELETE FROM library_groups WHERE id NOT IN ( SELECT MIN(id) FROM ( SELECT * FROM library_groups ) AS lg GROUP BY parent_id, branchcode ) AND NOT(parent_id IS NULL OR branchcode IS NULL); -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.