Hey @patrice!
Thanks for all the work you do on this. I appreciate it's a never-ending task and key if we're not all to drown in the tide of over-posting!
I'm self taught with SQL but I've got to grips pretty well with it now. If there are any particular queries you want designed I'd be happy to help out.
Also would it help to have something automated? Not automated flags but just something that lists up certain types of behaviour and refreshes every now and again for you to then investigate? e.g.
- Posting more than 24 times a day.
- High / significant self-vote levels on own comments (being made close to end of 7 day period)
- etc
I think that this is something we could facilitate through utopian given the range of skills here, although only if it's useful obviously. Let me know what you think.
Great work here!
I hope @patrice gets back to you because I think you've already done much of the graft on the SQL side.