# Data Explorer query to identify trust level change dates

**URL:** <https://meta.discourse.org/t/data-explorer-query-to-identify-trust-level-change-dates/164037>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [September 14, 2020, 9:11pm UTC](https://meta.discourse.org/t/data-explorer-query-to-identify-trust-level-change-dates/164037 "2020-09-14T21:11:26Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Randy\_Hulett](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/randy_hulett/32/182177_2.png) [@Randy\_Hulett](https://meta.discourse.org/u/Randy_Hulett)\
**Post date:** [October 28, 2022, 8:25pm UTC](https://meta.discourse.org/t/data-explorer-query-to-identify-trust-level-change-dates/164037/5 "2022-10-28T20:25:03Z")

</div>

If you join on the `groups` and `group_users` tables as @simon showed, you can add something like this to your WHERE clause:

```plaintext
WHERE gu.created_at::date >= :since
    AND g.name = 'trust_level_3'
    AND u.admin = false

```

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-query-to-identify-trust-level-change-dates/164037)._