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:
Registration Email Allowed In Our Database : Yahoo * Gmail * Hotmail * Outlook * yandex * live * are allowed to register in our database. [ We Will Approve Manually After Review It ]
Tips & Guides Soft delete all moderated posts (queries)
Useful for clearing out a backlog of moderated posts when you don't want to permanently delete them.