# 平均每个主题的会员回复数（不包括工作人员）

**URL:** <https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618>\
**Category:** Data & reporting\
**Created:** [2024年一月5日 11:35 UTC](https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618 "2024-01-05T11:35:24Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [2024年一月10日 16:10 UTC](https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618/7 "2024-01-10T16:10:29Z")

</div>

Personally, I really want a `group_id` parameter lookup just like the `user_id` one 🤞 🙂 - [Param dropdown for group\_id in data explorer query](https://meta.discourse.org/t/wishlist-param-dropdown-for-data-explorer-query/253883)

But until that dream comes true I use the json of the groups page to find it out eg. [https://meta.discourse.org/g.json](https://meta.discourse.org/g.json)

 ![group_id from groups json](https://global.discourse-cdn.com/meta/original/4X/d/4/9/d49a23a5d7721d7e9acf379614ec1a2b3dac396c.png)

You can do a group look-up within the query itself so it works on group names, which may be a more user-friendly way of doing it. So something like:

```sql
-- [params]
-- string :group_name

SELECT user_id, true as is_staff
    FROM group_users
    WHERE group_id = (SELECT id FROM groups WHERE name = LOWER(:group_name))

```

(or the hard-coded version if you didn’t want a parameter:)

```sql
SELECT user_id, true as is_staff
    FROM group_users
    WHERE group_id = (SELECT id FROM groups WHERE name = 'admins')

```

---

_[View the full topic](https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618)._