Title: Deleting Duplicate Comments in SQL or Plugin
Last modified: August 20, 2016

---

# Deleting Duplicate Comments in SQL or Plugin

 *  [xbiboy](https://wordpress.org/support/users/xbiboy/)
 * (@xbiboy)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/deleting-duplicate-comments-in-sql-or-plugin/)
 * hi, we had this issue where some of our post had duplicated comments not sure
   if it was an error but our comments went upto 100k and some of them are duplicated
   is there a way to delete the duplicate comments using a plugin or running a sql
   query thanks

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

 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [14 years, 1 month ago](https://wordpress.org/support/topic/deleting-duplicate-comments-in-sql-or-plugin/#post-2744259)
 * You could probably do an SQL query, but you’d have to know exactly what comments
   to delete. 100k? Wow.
 *  Thread Starter [xbiboy](https://wordpress.org/support/users/xbiboy/)
 * (@xbiboy)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/deleting-duplicate-comments-in-sql-or-plugin/#post-2744304)
 * what kind of sql query can I execute
 *  Thread Starter [xbiboy](https://wordpress.org/support/users/xbiboy/)
 * (@xbiboy)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/deleting-duplicate-comments-in-sql-or-plugin/#post-2744320)
 * this [image ](http://prntscr.com/96mvr)shows whats happening on the comment, 
   when I deleted all the comments in the database it’s still coming back and generates
   it where do I check this ?
 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [14 years, 1 month ago](https://wordpress.org/support/topic/deleting-duplicate-comments-in-sql-or-plugin/#post-2744403)
 * If you delete them via WP or the DB and they’re coming back then you have three
   options.
 * 1) Bad theme
    2) Bad plugin 3) Bad user
 * Turn on Akismet for starters.
 *  Thread Starter [xbiboy](https://wordpress.org/support/users/xbiboy/)
 * (@xbiboy)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/deleting-duplicate-comments-in-sql-or-plugin/#post-2744409)
 * yes , I think it’s the plugins SEO Facebook Comment is causing it because it 
   generates the comments that are coming from facebook it will loop until finds
   the comments and store it in the wordpress database , I think it made some infinite
   loop or something that cause it 100k comments, I just emptied our wp_comments
   table and disabled the plugin and it worked our fine 🙂 and basically I used 
   the basic facebook comment code and it on the theme,
 * SEO Facebook comment is quite good because it stores it on the database and converts
   it into a wordpress comment
 * will contact the developer to report the bug

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

The topic ‘Deleting Duplicate Comments in SQL or Plugin’ is closed to new replies.

## Tags

 * [Comments](https://wordpress.org/support/topic-tag/comments/)
 * [duplicate](https://wordpress.org/support/topic-tag/duplicate/)
 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [SEO facebook comment](https://wordpress.org/support/topic-tag/seo-facebook-comment/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 5 replies
 * 2 participants
 * Last reply from: [xbiboy](https://wordpress.org/support/users/xbiboy/)
 * Last activity: [14 years, 1 month ago](https://wordpress.org/support/topic/deleting-duplicate-comments-in-sql-or-plugin/#post-2744409)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics