# Silencing users with \<1m read time

**URL:** <https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830>\
**Category:** Product Support\
**Created:** [28 במרץ,‏ 2019,‏ 4:29pm UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830 "2019-03-28T16:29:52Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![slackmoehrle](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/slackmoehrle/32/82215_2.png) [@slackmoehrle](https://meta.discourse.org/u/slackmoehrle)\
**Post date:** [28 במרץ,‏ 2019,‏ 4:29pm UTC](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830/1 "2019-03-28T16:29:52Z")

</div>

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.

```sql
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

```

---

_[View the full topic](https://meta.discourse.org/t/silencing-users-with-1m-read-time/112830)._
