Title: Draft revisions?
Last modified: August 21, 2016

---

# Draft revisions?

 *  Resolved [billc108](https://wordpress.org/support/users/billc108/)
 * (@billc108)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/draft-revisions/)
 * Just checking… Will TOR delete revisions on drafts as well (no matter the age),
   or does in leave them until after the post has been published.
 * Thanks.
 * [https://wordpress.org/plugins/thin-out-revisions/](https://wordpress.org/plugins/thin-out-revisions/)

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [blogger323](https://wordpress.org/support/users/blogger323/)
 * (@blogger323)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/draft-revisions/#post-5135657)
 * (I assume you enable ‘Delete all revisions on initial publication’ option. This
   is enabled by default.)
 * TOR deletes draft revisions just when you publish it for the first time. In other
   words, you can use draft revisions while you keep it as a draft.
 *  Plugin Author [blogger323](https://wordpress.org/support/users/blogger323/)
 * (@blogger323)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/draft-revisions/#post-5135658)
 * Correction though you might not mind it.
 * ‘Delete all revisions on initial publication’ option is OFF by default. You should
   turn it on if you like this behavior.
 *  Thread Starter [billc108](https://wordpress.org/support/users/billc108/)
 * (@billc108)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/draft-revisions/#post-5135699)
 * No, I left “delete all revisions on initial publication off.
 * My test on a backup db showed that it DID delete.
 * SELECT *
    FROM `wp_posts` WHERE `post_status` = ‘draft’ AND `post_type` = ‘revision’
 * showed several posts matching. Then ran your plugin, ran that query again, and
   got no matches.
 * Is there a way to keep all revisions for drafts, no matter how old?
 *  Plugin Author [blogger323](https://wordpress.org/support/users/blogger323/)
 * (@blogger323)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/draft-revisions/#post-5135722)
 * Your SQL is wrong. Post_status of revisions is ‘inherit’. Try SQL below.
 *     ```
       select p1.ID
       from wp_posts p1, wp_posts p2
       where p1.post_status = 'inherit'
       and p1.post_type = 'revision'
       and p1.post_parent = p2.ID
       and p2.post_status = 'draft';
       ```
   
 *  Thread Starter [billc108](https://wordpress.org/support/users/billc108/)
 * (@billc108)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/draft-revisions/#post-5135783)
 * Ah. Ok, will test out like that.
 * Thanks.
 *  Plugin Author [blogger323](https://wordpress.org/support/users/blogger323/)
 * (@blogger323)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/draft-revisions/#post-5135842)
 * I think this topic can be closed because no additional negative response so far.
   I marked it as resolved.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Draft revisions?’ is closed to new replies.

 * ![](https://ps.w.org/thin-out-revisions/assets/icon-256x256.png?rev=983543)
 * [Thin Out Revisions](https://wordpress.org/plugins/thin-out-revisions/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/thin-out-revisions/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/thin-out-revisions/)
 * [Active Topics](https://wordpress.org/support/plugin/thin-out-revisions/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/thin-out-revisions/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/thin-out-revisions/reviews/)

## Tags

 * [drafts](https://wordpress.org/support/topic-tag/drafts/)

 * 6 replies
 * 2 participants
 * Last reply from: [blogger323](https://wordpress.org/support/users/blogger323/)
 * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/draft-revisions/#post-5135842)
 * Status: resolved