WordPress Find Duplicate Post By Content

Try to use the following SQL query to fetch duplicate posts:

SELECT p2.* 
  FROM wp_posts AS p1
  LEFT JOIN wp_posts AS p2 ON p1.post_content = p2.post_content 
   AND p2.ID < p1.ID 
   AND p1.post_type = p2.post_type 
   AND p1.post_status = p2.post_status
 WHERE p1.post_type="post" AND p2.ID IS NOT NULL

Related Posts:

  1. How to Optimize WP site for millions of posts
  2. Get Terms by IDs with IDs order
  3. wpdb get posts by taxonomy SQL
  4. How to List Events by Year and Month Using Advanced Custom Fields?
  5. Is there any difference between hooks posts_where with posts_join and posts_search performance wise?
  6. How many WordPress SQL Queries per page?
  7. Slow wp_enqueue_media()
  8. Advanced Custom Fields – Query Efficiency
  9. How to display lastest post date in the homepage?
  10. Show recent products first but “sold out last” in query
  11. How to tell if $query_var isset?
  12. Sorting Grids with Essential Grid and Events Manger
  13. The use of including upgrade.php when building custom queries
  14. Get the timout value of a saved transient?
  15. Help with wordpress custom query and advanced custom fields plugin
  16. Does meta_query work within get_posts array?
  17. Mysql / WordPress killing my server with 80k users [closed]
  18. Query all posts and not repeat the same tag
  19. Slow meta_query with about 4 milion record on wp_postmeta
  20. How to show more than 5 posts?
  21. How many queries are normal to execute on a WP site?
  22. How to optimize my query filtering out unwanted data?
  23. Remove posts from query for events whose start date has passed
  24. Insert static element only once in query archive
  25. How to run a mysql query when admin updates user role?
  26. Error when using setup_postdata()
  27. pre_get_posts : ‘post__not_in’ doesn’t work with global variable
  28. MySQL variable in query
  29. Getting post data from private page
  30. Missing posts in a query
  31. Alter a specific query on WordPress
  32. Only show upcoming event or current events
  33. SQL query to select posts from multiple categories
  34. Protect sequence of pages with same password for each of two groups of users
  35. How is it possible to get top comment from all children?
  36. How to orderby multiple meta fields with another meta query
  37. Select Query demand excesive resources [closed]
  38. Create Indexes for Slow Queries
  39. Query to get number of posts last week
  40. Query posts using meta_key
  41. Modify users.php query with multiple taxonomies
  42. I want to create a filter for the query string is this possible?
  43. Exclude categories from the_category();
  44. How can i show all categories using wp query?
  45. All in One Calendar Plugin Custom Post Type Query [closed]
  46. Get Posts from Last 24 hours and Sort them via GD Star Rating
  47. How to change the amount of posts previewed on a page?
  48. Query returning same results even though the ID changes
  49. How to get events using multiple custom meta fields?
  50. Why my query ‘REPLACE INTO…’ does not work?
  51. Restrict query to last day with posts
  52. Custom query object with Simple-Fields custom date field
  53. How to read the value of a WordPress $query associative array (hash) key
  54. Random Page Rewrite
  55. Query posts based on previous query
  56. Waypoints + infinite scroll with custom query
  57. Customizing the_tags output?
  58. Querying with WP query using meta key price
  59. How to pull posts into two columns with different image sizes using $counter variable?
  60. Re-sort get_posts query results
  61. How do I get all results from my query
  62. Taxonomy filter under Polylang
  63. Select column name dynamically mySQL Query
  64. How to create an overview of posts with the same tag?
  65. create a link to a random post within the current category
  66. Pagination not working on custom post types with rewrite slug
  67. JetEngine Query Builder – order by value from repeater
  68. Change pure SQL database query to WordPress post query?
  69. Filter orders by modify date
  70. How to add url parameter to every search query in SearchWp?
  71. Order posts ascending from posts in array
  72. Display data from phpMyAdmin with WordPress
  73. Heavy meta query causing SQL crash
  74. Sort by postmeta on when searching
  75. Pulling an ACF into a query
  76. Speed up search query that searches in post meta?
  77. Category_in return empty
  78. Using cron for multiple queries
  79. very slow wordpress query with default query
  80. About WP’s save_post action
  81. $wpdb: how to use a query as a base for another query?
  82. Custom Query problem access the values
  83. Set posts per page for parent category and it’s all children
  84. Exclude sticky posts from query
  85. list or get meta_key where meta_value is ‘something’
  86. If more than 1 image show post link?
  87. Rewrite Query_Var URL Parameter with Slug
  88. How to query different categories on index?
  89. How to specify what kind of is_single post?
  90. Can’t See Media Queries with Inspect Tool [closed]
  91. Print data from wordpress sql query
  92. What is the best way to cache pages and queries in WordPress?
  93. Can I create my own query in wordpress with traditional methods?
  94. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
  95. update $wpdb one query
  96. Admin Post List table Query filtering “WHERE” for custom post type
  97. Ascending & descending posts on same page with IF statement
  98. Prevent executing query for wp_global_styles
  99. How to use a dynamic term id for the query block
  100. Meta Query compare with LIKE pulls similar post types: 55 and 155, and 1,155