How To Get Rid Of Unused Post Revisions In WordPress

The following line of codes will let you get rid of unused post revisions in WordPress.

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);

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

Related posts: