Skip to content

Instantly share code, notes, and snippets.

@adis-io

adis-io/delete_old_wp_posts.sql

Last active September 24, 2016 05:59
Show Gist options
  • Save adis-io/797ca964b7ee07a9220680676b5c61ec to your computer and use it in GitHub Desktop.
Save adis-io/797ca964b7ee07a9220680676b5c61ec to your computer and use it in GitHub Desktop.
Download ZIP
Delete all old posts which published 600 days ago
Raw
delete_old_wp_posts.sql
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_type = 'post' AND DATEDIFF(NOW(),
a.post_date) > 600
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment