# 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:** 3

<div class="post-metadata">

**Author:** ![nathank](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/nathank/32/290039_2.png) [@nathank](https://meta.discourse.org/u/nathank)\
**Post date:** [April 30, 2021, 9:07pm UTC](https://meta.discourse.org/t/data-explorer-query-for-all-active-users-lurkers-posters/188343/3 "2021-04-30T21:07:18Z")

</div>

> [@Heddson](#):
>
> You provided great info and references in your question! I only had to pick the right stuff and combine them.

Thanks! I do believe in making it easy for others to help where possible.

`UNION` - that was the hole in my SQL knowledge. All sorted now thank you! I’ll post my final query here after it is more refined.

---

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