You have to write a query that would find duplicates, and then decide (disable or delete) how to handle the duplicates. There's no way for us to know from which table you'd want to delete things.

You can use standard join syntax to find out which rows in which tables might be duplicates.