Find and Delete Duplicate Post WordPress From PHPMyAdmin

Judulnya rada ke-Enggris2-an ….. 😀

Pertama temukan dahulu Duplicate Post tersebut dengan perintah seperti dibawah ini :

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'

Setelah ditemukan Duplicate post tersebut langsung lakukan perintah untuk menghapusnya :

DELETE a.*
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'

source : http://wpkrauts.com/2013/find-and-delete-duplicate-posts-in-wordpress/