As the user list does not currently allow bulk actions, I’d like a little guidance to work from the SQL side of things if this is possible.
- Find all accounts older than 2 months without any posts (and remove them)
- Order accounts by most viewed - most posted (so I can either ban or clear an account)
- Etc. Already these two would save a lot of time dealing with 500+ suspicious accounts
What SQL requests or strategies did you come up with dealing with spam on your instance?