DELETE a,b,c
2.FROM wp_posts a
3.LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
4.LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
5.WHERE a.post_type = ‘revision’
DELETE a,b,c
2.FROM wp_posts a
3.LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
4.LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
5.WHERE a.post_type = ‘revision’
