I have a large number of suspect users I want to delete. They were migrated from our previous vbb forum and they have been sitting on our forum as suspect users for some time. Many of these have profile link spam.
My criteria are to delete any user meeting the following criteria:
- users that were last seen say more than 3 years ago
- users that have no posts
- users that have not read any posts
- (maybe users that have a web profile url)
I am able to select these using sql, but now want to bulk delete them.
How do I go about this?