Plugin to remove duplicate posts (6 posts)

  1. Mayur Somani
    Posted 7 years ago #

    Is there any plugin that can be used to remove duplicate posts from my wordpress 2.7 blog?

    Thank you for your time.

  2. Mayur Somani
    Posted 7 years ago #

    never mind, solved the issue :)

  3. ddlblogdotcom
    Posted 7 years ago #

    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

  4. c.bavota
    Posted 7 years ago #

  5. Boris_yo
    Posted 6 years ago #

    Try this one - it's free.

  6. pf69.com
    Posted 6 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.