# Data explorer query for all active users (Lurkers + Posters)

**URL:** <https://meta.discourse.org/t/data-explorer-query-for-all-active-users-lurkers-posters/188343>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [April 28, 2021, 10:15am UTC](https://meta.discourse.org/t/data-explorer-query-for-all-active-users-lurkers-posters/188343 "2021-04-28T10:15:08Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![satonotdead](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/satonotdead/32/447830_2.png) [@satonotdead](https://meta.discourse.org/u/satonotdead)\
**Post date:** [November 24, 2024, 9:01pm UTC](https://meta.discourse.org/t/data-explorer-query-for-all-active-users-lurkers-posters/188343/5 "2024-11-24T21:01:51Z")

</div>

Thanks for sharing this. I tried to use it and also a very similar code on badge querys but I get this error:

```plaintext
Contract violation:
Query does not return a 'granted_at' column

```

I’m missing something on the code in order to use this query on badge system? My usecase is automate the ‘lurkers’ group 🙂

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-query-for-all-active-users-lurkers-posters/188343)._