Title: Plugin to remove duplicate posts
Last modified: August 19, 2016

---

# Plugin to remove duplicate posts

 *  [Mayur Somani](https://wordpress.org/support/users/mayur-somani/)
 * (@mayur-somani)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/plugin-to-remove-duplicate-posts/)
 * Is there any plugin that can be used to remove duplicate posts from my wordpress
   2.7 blog?
 * Thank you for your time.

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Thread Starter [Mayur Somani](https://wordpress.org/support/users/mayur-somani/)
 * (@mayur-somani)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/plugin-to-remove-duplicate-posts/#post-961699)
 * never mind, solved the issue 🙂
 *  [ddlblogdotcom](https://wordpress.org/support/users/ddlblogdotcom/)
 * (@ddlblogdotcom)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/plugin-to-remove-duplicate-posts/#post-962040)
 * 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
 *  [bandicootmarketing](https://wordpress.org/support/users/tinkerpriest/)
 * (@tinkerpriest)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/plugin-to-remove-duplicate-posts/#post-962049)
 * [http://bavotasan.com/downloads/delete-duplicate-posts-wordpress-plugin/](http://bavotasan.com/downloads/delete-duplicate-posts-wordpress-plugin/)
 *  [boris_yo](https://wordpress.org/support/users/boris_yo/)
 * (@boris_yo)
 * [16 years, 8 months ago](https://wordpress.org/support/topic/plugin-to-remove-duplicate-posts/#post-962063)
 * Try [this one](http://webscripts.softpedia.com/scriptDownload/Delete-Duplicate-Posts-Download-53814.html)–
   it’s free.
 *  [pf69.com](https://wordpress.org/support/users/pf69com/)
 * (@pf69com)
 * [16 years, 6 months ago](https://wordpress.org/support/topic/plugin-to-remove-duplicate-posts/#post-962097)
 * 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

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Plugin to remove duplicate posts’ is closed to new replies.

 * 5 replies
 * 5 participants
 * Last reply from: [pf69.com](https://wordpress.org/support/users/pf69com/)
 * Last activity: [16 years, 6 months ago](https://wordpress.org/support/topic/plugin-to-remove-duplicate-posts/#post-962097)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics