Skip to content

Instantly share code, notes, and snippets.

@tacensi

tacensi/WP empty trash sql query

Created April 4, 2019 18:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tacensi/78ac2f9efcede7c4208869564748089e to your computer and use it in GitHub Desktop.
Save tacensi/78ac2f9efcede7c4208869564748089e to your computer and use it in GitHub Desktop.
Download ZIP
WP empty trash sql query
Raw
WP empty trash sql query
DELETE wp_posts,wp_term_relationships,wp_postmeta,wp_term_taxonomy
FROM wp_posts
LEFT JOIN wp_term_relationships ON ( wp_posts.ID = wp_term_relationships.object_id )
LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
LEFT JOIN wp_term_taxonomy ON ( wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
WHERE wp_posts.post_status='trash';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment