Deleting all revisions in WordPress Multisite without unintentional data loss. Original source this code is bassed on: http://www.ambrosite.com/blog/clean-up-wordpress-revisions-using-a-mysql-multi-table-delete

revisionsMS.sql

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 )
LEFT JOIN wp_#_term_taxonomy d ON ( b.term_taxonomy_id = d.term_taxonomy_id)
WHERE a.post_type = 'revision'
AND d.taxonomy != 'link_category';