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:
INSERT INTO xf_deletion_log (content_type, content_id, delete_date...