WordPress.org

Ideas

How To Detect Duplicate Posts?

  1. webhub
    Member

    What can I do to detect duplicate blogs in my website? There are many URL generated for a single blog post. Suggest me the best plugin or the process to detect them all and demolish the redundancy.

    Posted: 1 week ago #
  2. Ipstenu (Mika Epstein)
    Lead Plugin Wrangler

    This is taken care of via the rel=canonical

    https://yoast.com/rel-canonical/

    Posted: 1 week ago #
  3. John Petser
    Member

    You can also do it via Copyscape Plagiarism Checker website, add website and check which is duplicate post or articles.

    Posted: 3 days ago #
  4. carlaluisa
    Member

    search for duplicate entries in the database. For example with the following SQL query.

    SELECT a.ID, a.post_title, a.post_type, a.post_status
    FROM wp_posts AS a
    INNER JOIN (
    SELECT post_title, MIN( id ) AS min_id
    FROM wp_posts
    WHERE post_type = 'post'
    AND post_status = 'publish'
    GROUP BY post_title
    HAVING COUNT( * ) > 1
    ) AS b ON b.post_title = a.post_title
    AND b.min_id <> a.id
    AND a.post_type = 'post'
    AND a.post_status = 'publish'

    Posted: 1 day ago #

RSS feed for this topic

Reply

You must log in to post.

  • Rating

    12345
    0 Votes
  • Status

    This idea is under consideration