# 是否有办法查看某个分类的关注者数量？

**URL:** <https://meta.discourse.org/t/is-there-a-way-to-see-the-number-of-watchers-for-a-category/159696>\
**Category:** Product Support\
**Created:** [2020 年8 月 3 日 18:49 UTC](https://meta.discourse.org/t/is-there-a-way-to-see-the-number-of-watchers-for-a-category/159696 "2020-08-03T18:49:58Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

作者： ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)\
发布日期： [2020 年8 月 3 日 21:47 UTC](https://meta.discourse.org/t/is-there-a-way-to-see-the-number-of-watchers-for-a-category/159696/3 "2020-08-03T21:47:37Z")

</div>

尝试：

```plaintext
SELECT c.id AS ID,
c.name AS NAME, 
cu.notification_level AS NOTIFICATION_LEVEL,
CASE cu.notification_level
WHEN 0 THEN '已静音' 
WHEN 1 THEN '常规' 
WHEN 2 THEN '跟踪' 
WHEN 3 THEN '关注' 
WHEN 4 THEN '关注首帖' END AS NOTIFICATION_LEVEL_DESC,
COUNT(cu.id) AS COUNT_OF_TYPE
FROM category_users cu
JOIN categories c ON cu.category_id = c.id
GROUP BY c.id, c.name, cu.notification_level, NOTIFICATION_LEVEL_DESC
ORDER BY c.name, cu.notification_level

```

---

_[View the full topic](https://meta.discourse.org/t/is-there-a-way-to-see-the-number-of-watchers-for-a-category/159696)._