How to deal with spam?

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.

  1. Find all accounts older than 2 months without any posts (and remove them)
  2. Order accounts by most viewed - most posted (so I can either ban or clear an account)
  3. Etc. Already these two would save a lot of time dealing with 500+ suspicious accounts :slight_smile:

What SQL requests or strategies did you come up with dealing with spam on your instance?