chris strafplanet on Nostr: For those who like #sql, here's an sql that looks for the currently used spam-images ...

For those who like #sql, here's an sql that looks for the currently used spam-images per instance, limited by the last 3 hours and at least 10 hits.
I’ll use this as a blocklist for now. #mastoadmin #spam
Edit to clarify: It looks for a hash of the blurred pictures created by mastodon, so it actually looks for the pictures in a way, not hashtags.

https://gist.github.com/strafplanet/cfdd10c3a999ac2d14a73cc5d9eae6a9#file-mastospam_sql_1-md