Soft delete all moderated posts (queries) (version 1.x) - Useful for clearing out a backlog of moderated posts when you don't want to permanently delete them.
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, delete_user_id, delete_username, delete_reason) SELECT content_type, content_id, UNIX_TIMESTAMP(), 1, 'admin', 'manually...