https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24741
--- Comment #3 from Jonathan Druart <jonathan.dru...@bugs.koha-community.org> --- (In reply to David Gustafsson from comment #1) > 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); This query looks correct to me. Could you submit a patch? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/