How do I combat SPAM?

Thanks you all for this thread. It’s really useful.

I compiled all the sql-snippets in a wiki-page here to keep working together on them:

Feel free to modify or extend.