I’m still fighting SPAM. Many hundreds of fake accounts being created. All with <1m read time. The users try to post a spam topic, but I do require post approval for new users until they reach a certain trust level.
I want to run a query that will silence users with <1m read time but where is it stored? I don’t see it in the user table. What is the best way to do this?
I started with this silence users that hadn’t posted since 2017.
UPDATE users SET silenced_till = '3019-02-01 13:00:00' WHERE last_seen_at >= '2013-01-01' AND last_seen_at <= '2017-12-31' RETURNING id, username_lower