bennybennet

DELETE a,b,c  
 FROM wp_posts a 
  LEFT JOIN wp_term_relationships b 
   ON (a.ID = b.object_id)
  LEFT JOIN wp_postmeta c 
   ON (a.ID = c.post_id) 
  INNER JOIN (SELECT * FROM wp_posts WHERE post_status = 'publish') d
   ON a.post_parent = d.ID 
  WHERE a.post_type = 'revision'