SQL Query for getting all posts in their latest revised state

Thanks to @AhmedMahdi’s comment I figured out the following works for my situation:

select * from wp_posts
where post_status="publish"
order by post_modified desc;

The where condition is necessary to remove all the draft or private posts that I am not concerned with.

Related Posts:

  1. Manually removing revision post types
  2. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  3. MySQL Query to Retrieve Category from wp_posts
  4. Any way to create a revision of a post ONLY with a new button in the Meta Box?
  5. Search & Remove Specific Shortcode From All Posts
  6. Manually delete post from database
  7. how to enable different number of revisions for different blogs when using WPMU?
  8. How to force update all posts after import
  9. Get the author of the latest revision
  10. Query All users that has post
  11. Can’t publish new posts
  12. Adding a cancel button to edit post screen
  13. How do I batch create revisions of all posts?
  14. Are posts updated or built from revisions + autosaves?
  15. Reset/Reorder posts ID in the MySQL wp_posts table
  16. Enable post revisions for a specific post
  17. How do I find which articles are missing a featured image in The WordPress database?
  18. Tags to Post-ID mysql query. Tag Search
  19. Define a wordpress constant through plugin functions?
  20. Post revisions disappeared (for some posts)
  21. wp_insert_post – duration
  22. How to hide html tags on revision comparison pages?
  23. Get user categories with most posts in it
  24. MySql query to get posts with all meta and terms
  25. Visual (non-HTML) display of post revisions [closed]
  26. Custom order for Mysql array
  27. List authors with the last post title and order by last post date
  28. How to Mysql select a list of posts with meta_values AND all relevant categories?
  29. Remove a shortcode from all WordPress posts
  30. Order posts alphabetically: how to set order=asc in mysql query?
  31. What do these phpMyAdmin errors mean on my WordPress databaes?
  32. why there are so many posts whoes post_type is revision? will these records waste too much database space?
  33. Display post changelog in post
  34. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  35. Why my wp_posts data is so huge?
  36. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  37. update image path with words starting uppercase to lowercase chars
  38. Delete post revisions only for a single post
  39. Queries take 120+ seconds on my large WordPress site
  40. Database hacked – random posts are modified
  41. Need to change all links in page content but not in post content
  42. Can’t update WordPress Page if post_content is Empty
  43. Restore woocommerce orders
  44. How to select particular month post from table and update the post status using MySQL?
  45. How do post IDs work in WordPress?
  46. Get author posts count after excluding a category
  47. get last post’s link with SQL query
  48. query for filtering published posts?
  49. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  50. Deleting post tags removes categories
  51. Return records between two meta datetimes saved as strings
  52. WP query taxonomy optimization
  53. How can I change the date format of the revision list?
  54. MYSQL: Create SQL query to search for string and replace
  55. Query to fetch custom taxonomy along with post title
  56. Mysql update menu_order problem
  57. Bulk find & replace on WordPress posts/pages (minus image paths)
  58. WordPress MySQL Search and replace with wildcard?
  59. Add postmeta to all blog posts
  60. ‘posts’ table should not store the absolute image path
  61. Dev and prod on the same database- dev version active for IOS
  62. load post data into mysql
  63. Clean up customize_changeset in DB
  64. SQL trigger failes with post_content
  65. Converting Posts to Pages
  66. How to change the publishing date of each posts?
  67. SQL query to remove first image in all posts
  68. Delete junk text from all the post using my sql command
  69. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  70. How to create a post based on data in a table?
  71. If meta_key exists then don’t select this post?
  72. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  73. How to manually delete post from database without causing conflicts?
  74. display all posts in wordpress admin
  75. Disallow Same Post Title
  76. How can I see a list of pages and post where my custom Gutenberg block is used?
  77. Verify if tag is used on posts
  78. Adding a div class or id inside the_content()
  79. getting video dimensions
  80. $post->ID displays wrong ID
  81. how to display post content without post image?
  82. How to allow slashes in single posts when i click in the edit permalink button
  83. Load post content into div with ajax
  84. Why does `url_to_postid` return 0 when testing `page_for_posts` Page?
  85. deleting terms programmatically
  86. wp_enqueue_media() slows down my WP site
  87. Edit menu item title from edit page/post
  88. Don’t post or draft if post already exists
  89. Archive Page for Custom Post Type is not Working
  90. how to remove dash (-) post status from post title on posts listing page wordpress
  91. Static page does not show my posts
  92. Get latest posts from WordPress site without header, menu and sidebar
  93. How can I schedule a PAGE to go live at a future date/time?
  94. Most liked page not displaying posts
  95. How can I replace WordPress standard process of editing posts with making WordPress use a custom page? [duplicate]
  96. Post’s “Read More” redirects to wrong post
  97. How can I fixe the article title problem?
  98. Automatically select category based on user role
  99. Comment section appearing over right hand side of all posts
  100. Hide page title on dedicated posts page

Leave a Comment