Skip to content

Instantly share code, notes, and snippets.

@underdown

underdown/wp-post-revisions.sql

Created December 12, 2019 18:13
Show Gist options
  • Save underdown/6ec1cf6e19da66cd4ae4883be42cb0be to your computer and use it in GitHub Desktop.
Save underdown/6ec1cf6e19da66cd4ae4883be42cb0be to your computer and use it in GitHub Desktop.
Download ZIP
Grab revisions from a wordpress post/page
Raw
wp-post-revisions.sql
# Find the initial post id by looking at a revision and then seeing what the post parent is. CHandler is 814
SELECT * FROM `wp_posts` WHERE `post_parent` = "814" ORDER BY ID DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment