# Established users with trust-level locked to 0 or 1

**URL:** https://meta.discourse.org/t/established-users-with-trust-level-locked-to-0-or-1/275037
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [10월 22, 2018, 12:19오후 UTC](https://meta.discourse.org/t/established-users-with-trust-level-locked-to-0-or-1/275037 "2018-10-22T12:19:40Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![ChrisBeach](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/chrisbeach/32/214628_2.png) [@ChrisBeach](https://meta.discourse.org/u/ChrisBeach)
#### Post date: [10월 22, 2018, 12:19오후 UTC](https://meta.discourse.org/t/established-users-with-trust-level-locked-to-0-or-1/275037/1 "2018-10-22T12:19:40Z")

</div>

Established users with trust-level locked to 0 or 1:

```sql
-- [params]
-- int :min_visited_days = 30
-- int :min_posts = 1

SELECT 
    id AS user_id,
    manual_locked_trust_level,
    days_visited,
    post_count
FROM 
    users u JOIN
        user_stats us ON u.id = us.user_id
WHERE 
    manual_locked_trust_level IN (0,1) AND
    days_visited >= :min_visited_days AND
    post_count >= :min_posts AND
    (silenced_till IS NULL OR silenced_till < NOW()) AND
    (suspended_till IS NULL OR suspended_till < NOW())
ORDER BY 
    days_visited DESC

```