# Het aantal kijkers weten

**URL:** https://meta.discourse.org/t/knowing-the-number-of-watchers/190941
**Category:** Feature
**Tags:** data-explorer, sql-query
**Created:** [19 mei 2021 om 16:37 UTC](https://meta.discourse.org/t/knowing-the-number-of-watchers/190941 "2021-05-19T16:37:40Z")
**Posts on this page:** 1
**Showing post:** 7

<div class="post-metadata">

### Author: ![MarkDoerr](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/markdoerr/32/549630_2.png) [@MarkDoerr](https://meta.discourse.org/u/MarkDoerr)
#### Post date: [22 juni 2022 om 21:23 UTC](https://meta.discourse.org/t/knowing-the-number-of-watchers/190941/7 "2022-06-22T21:23:15Z")

</div>

Hi Tom,

This has not been added as a default DE report. However I found a topic that provides a basic DE query to pull this information, maybe that will be helpful:

> [@Finding out how many users are watching or tracking?](https://meta.discourse.org/t/finding-out-how-many-users-are-watching-or-tracking/56900/2):
>
> There are “\_user” tables. category\_users, topic\_users, group\_users and tag\_users Each has a notification\_level field where the integer indicates a members preference - 0 Muted, 1 Normal, 2 Tracked, 3 Watched So a query something like this should work SELECT COUNT(id) FROM category\_users WHERE notification\_level = 3 GROUP BY category\_id to give you how many are Watching each category.

---

_[View the full topic](https://meta.discourse.org/t/knowing-the-number-of-watchers/190941)._