You can run these queries to soft delete all moderated posts. You need to change the red pieces to attribute these deletions to a user_id and username, as well as give the reason. These things are recorded in the deletion log:
Rich (BB code):
INSERT INTO xf_deletion_log (content_type, content_id, delete_date, delete_user_id...
You do not have permission to view the full content of this resource. Log in or register now.