1
2
3
4
5
6
7
//CHANGE wp TO the prefix you chose FOR your DATABASE

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