Delete all drafts?

draft is not a post_type, it’s a post_status. So you should use your second block of code with that substitution:

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_status="draft"

Related Posts:

  1. Delete post revisions only for a single post
  2. How Can I Always Display A Particular Post First Using WP_Query?
  3. Change permalinks in posts via SQL
  4. When is the ‘post_content_filtered’ column in database cleared by WordPress?
  5. How can I safely increase the character limit for post passwords?
  6. How to Group Posts by the First Letter or Number?
  7. Restore contents of deleted user
  8. How are terms connected with posts in database?
  9. Using $wpdb to query posts with meta value containing current post_id
  10. Query posts from current year
  11. I have over 4000 posts, will querying some of them cause performance issues?
  12. Custom Taxonomies Incorrectly Counting Revisions?
  13. How to add posts to wp_query result?
  14. Order post by year DESC and month ASC
  15. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  16. How can I display a specific user’s first published post?
  17. database columns: post_title vs post_name
  18. Sanitizing `wp_editor();` Values for Database, Edit, and Display
  19. wp_enqueue_media() slows down my WP site
  20. Importing New Posts from Live Site into Local Dev Site
  21. Sorting posts alphabetical that have single digits
  22. Query posts from different categories in multisite
  23. posts_per_page doesnt work
  24. Sorting posts according to view counts not working
  25. Manually removing revision post types
  26. How much of my site can I recover from public_html?
  27. Improving WP_Query for performance when random posts are ordered
  28. Multiples Empty Posts were created and cannot delete them
  29. Get posts by name and taxonomy term
  30. Get Posts that are in the current month or later
  31. How to delete all the content of a wordpress site without deleting the Post and pages?
  32. do_shortcode within post query
  33. Extracting post categories
  34. Get Meta Key Value While Saving Post
  35. Most liked page not displaying posts
  36. Query get post,how to add comment box
  37. How can I setup a relationship using categories in WordPress?
  38. Can’t update old posts 3.5.2
  39. Copy post to separate database with “add_action(….)”
  40. How i can limit period of post publication?
  41. When open add new post or page WordPress add post with ID=0 continuously [closed]
  42. Anyone know why wordpress converts some html entities to their numeric equivalents?
  43. How to setup a query to output posts by groups of five?
  44. What do these phpMyAdmin errors mean on my WordPress databaes?
  45. Exclude current custom post on single post
  46. why there are so many posts whoes post_type is revision? will these records waste too much database space?
  47. First x post with another template then the others
  48. Why Query is returning empty array?
  49. Wrap every month posts in div
  50. Why my wp_posts data is so huge?
  51. Why posts array is empty?
  52. Move posts from a non-wordpress site to wordpress
  53. wp_posts table extremely large
  54. Display post by click on the link
  55. Queries take 120+ seconds on my large WordPress site
  56. Related Posts function not working
  57. WordPress loop not working on static front page
  58. How to display only one category in a custom post type?
  59. why the posts queried from sql is more than those showed on the page?
  60. Export all posts to import as product items
  61. Anyone know a php snippet for showing the first 200 characters of the most recent post?
  62. Get current taxonomy and display query accordingly
  63. Is there a function to get post info for any publish_status by post ID?
  64. Prevent duplicate pages from being added
  65. Show 10 latest posts only from users with contributors role
  66. Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
  67. How can I globally italicize list of texts in the UI database or Posts? [closed]
  68. Return records between two meta datetimes saved as strings
  69. Check if almost 10 year old – working code is up to date
  70. My website is showing today’s date instead of published date since db migration to a new wordpress
  71. Query custom post type custom meta key
  72. Bulk find & replace on WordPress posts/pages (minus image paths)
  73. How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
  74. filter posts based on menu_order
  75. Count posts for pagination
  76. I need some explanation on global $post [duplicate]
  77. how i show manual data in a post
  78. Clean up customize_changeset in DB
  79. How to delete all posts with dead image urls?
  80. Querying posts from current category, using a variable as array argument
  81. How do I get a certain set of posts from the database?
  82. Maximum number of posts per page before affecting performance?
  83. Surrogate ID for posts, is there an alternative field in the posts table?
  84. wp query custom orderby not custom field
  85. Query post by meta key of another table
  86. Expired Post with More Recent Time Stamp?
  87. Query post category & remove any post id
  88. Converting Posts to Pages
  89. Why I obtain this WP_Query strange behavior trying to select posts having a specific tag?
  90. How to change the publishing date of each posts?
  91. Removing a post from the results of a WP Query
  92. Extra field in wp_post instead of postmeta
  93. Voting System, database connections?
  94. Query posts from a specific category and selected tag
  95. Creating pages and getting their values from the database table
  96. How to limit post query to only return a total count of items with certain post statuses?
  97. Load posts from external source if not found in database
  98. The page that displays Posts on homepage
  99. query_post or single-[cpt].php?
  100. Need to show birthday of custom post type(Famous people in this case) in elementor. Date of birth set in custom fields