Super post cleaner, could this be category specific?

Your code is flawed. You should never delete posts by issuing SQL directly to the DB. Use WP_Query to find the posts that are duplicates and wp_delete_post to delete them.

Your current method might generate a lot of garbage in the DB.

Side Note: Best way to prevent duplication is not to allow them to be created in the first place.

Related Posts:

  1. How do I check if I linked to a post before I delete it?
  2. disable password protected page for logged users
  3. Dynamically update post title in admin page
  4. How do I use inline SVG in WordPress
  5. duplicate posts when trying to update a post using the wp_insert_post.
  6. Add custom field to all posts in specific category
  7. Hiding by default specific post status on backend list?
  8. “Uncaught SyntaxError: Unexpected token
  9. Displaying Page Title on index.php
  10. Detect Post Type when publish_post is ran
  11. WP_Query in functions.php overrides global $post object, even with wp_reset_query()
  12. Pull posts from another wordpress install on same server
  13. How can I get all posts data from within a paginated search result?
  14. Syndicated Posts when Updated Lose HTML tags
  15. How to insert current date/time in the content of a post?
  16. How to automate filing a form as a user
  17. I want to query posts in monthly basis
  18. Encrypt / Decrypt Post Title and Details
  19. White Blank Page when Updating and Publishing Page/Post
  20. Full Width Main Post
  21. Posts vs. Pages
  22. Limiting the number of posts in WP_Query leads to unexpected result
  23. how to set beforsend option in wordpress ajax methods
  24. Plain permalinks not working!
  25. Guest Author – How to display posts on /author/ archive page
  26. How to add pagination in between post and comments?
  27. Posts not showing on page
  28. How can I find out what items a user has purchased? [closed]
  29. Nothing Found error when creating new posts – how to correct this?
  30. Redirection not working in this front end post submission form?
  31. Add Word Limit to Posts
  32. Display multiple custom taxonomy values on single custom post types page?
  33. How to Programmatically add an empty Block to every post on wordpress site?
  34. Underscores Theme Unit Testing – Catching Untitled Posts
  35. How to do set post permalinks using 6 digit random unique function?
  36. Encountering “Wrong nonce. Action prohibitied.” when trying to alter User Role and unable to Post via WP Admin
  37. Pulling in post category and children within category
  38. Is Hfeed class for all pages needed
  39. get query() without post content?
  40. Issue where WP Featured Image will not display
  41. Custom order for Mysql array
  42. posts_per_page option limits the number of Gallery items
  43. show custom post type category dropdown sorting result on same page
  44. Display post category in foreach loop
  45. Single.php – Get Current Parent Category
  46. insert a warning message into post-new.php
  47. WP text editor change html markup
  48. how can i allow users to view their own pending posts in a front-end page
  49. How to make different custom post layouts?
  50. Number of displayed posts
  51. Modifying the following code to displaying the title and the content of static page Posts page?
  52. Saving Post Data in Another Database
  53. singular posts using archive styling
  54. How can I tell if a post has been published at least once?
  55. Un-highlight Blog Menu Item when Category Menu Item is Selected
  56. How to get the form code from the edit page of a specific post?
  57. Send email for pending post
  58. Add simple field column to the posts screen
  59. WP_Query custom field pass the post id
  60. Get the post id from a plugin
  61. change the post time on multiple posts
  62. Making posts permalinks consistent numbers
  63. How to show category based post in home page?
  64. Regarding Posts
  65. Locally change the font family [closed]
  66. WordPress single.php different layouts projects / posts
  67. WordPress Post via e-mail writes a random string for the post body
  68. Add text and change style to post programmatically depending on category
  69. Permanently deleted posts still exist
  70. WP_Query outputs wrong post in custom post type
  71. Export post another site
  72. Order by meta_key field in WordPress not meta_value field value
  73. Deleted page still shows and is showing posts archive
  74. How to show post views shortcode data for each post on Posts List Page?
  75. Need to display a Jan 1st post as the site’s front page on Jan 1st, and Jan 2nd post as front page on Jan 2nd etc
  76. Related Customs posts
  77. Blog featured images disappeared on my homepage
  78. Creating a frontend blog post form for logged in users only
  79. How to hide meta from search result only on pages?
  80. How do I display posts ordered by a date custom field?
  81. How to create frontend Post filter using meta query
  82. How to test if user is filtering post list in dashboard
  83. Post Format problem
  84. Post title to show all characters after having it limited for preview
  85. Custom Select Query pagination not working properly
  86. Some comment box wordpress in 1 post [closed]
  87. Template Body to posts
  88. wordpress paginate, link to the right page
  89. How to get posts from network blog
  90. Get current user array with post string
  91. how to change the permalink to a specific location?
  92. get next/previous post name
  93. Get image paths from RSS feeds
  94. How do I display the next 3 posts in the sidebar?
  95. 2 tick boxes appearing below comments
  96. How can to use the players from the Media Widgets in the body of a post to play audio and video files
  97. How can I display these posts in ascending order?
  98. Is there any point to using wp_unique_post_slug?
  99. Polylang – display one post into 3 categories with different lang [closed]
  100. WordPress + Polylang – Error 404 when trying to preview draft post on different language
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduseduedusedueduseduseduseduedu