The following line of codes will let you get rid of unused post revisions in WordPress.
1 2 3 4 5 6 | DELETE a,b,c FROM wp_posts a WHERE a.post_type = 'revision' LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id); |
Snippet Source/Credit: WPRecipes.com