Plugin to remove duplicate posts

never mind, solved the issue ??

can u plz tell me how u solve this problem…………i have tons of duplicate post in my blog.total 10000 post where minimum 2000 duplicate…………..plz help me

https://bavotasan.com/downloads/delete-duplicate-posts-wordpress-plugin/

Try this one – it’s free.

you can run this SQL QUERY on your MySQL admin panel (such as phpMyAdmin) -> faster and safer – don’t forget to back up your DB in case anything goes wrong -> assuming that your WP tables are called wp_ (if it is something different all you have to do is replace that part on the query for the proper tables name)

DELETE bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MIN(id) as min_id
from wp_posts
group by post_title
having count(*) > 1
) as good_rows on good_rows.post_title = bad_rows.post_title
and good_rows.min_id <> bad_rows.id