Delete post revisions and disable revisions
This WordPress plugin allows you delete all post revisions and disable post revisions.
1. After activation plugin settings available on Del-Post-Rev settings page
2. To just delete the current post revisions, click the button "Delete post revisions and Save"
3. To disable revisions, check the checkbox "Disable post revisions"
The SQL query that is used to delete post revisions:
FROM $wpdb->posts p
LEFT JOIN $wpdb->term_relationships tr ON p.ID = tr.object_id
LEFT JOIN $wpdb->postmeta pm ON p.ID = pm.post_id
WHERE p.post_type = 'revision'