# Balises : comment un administrateur peut-il voir qui suit quelles balises ?

**URL:** https://meta.discourse.org/t/tags-how-can-admin-see-who-is-following-what-tags/83445
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [Mars 21, 2018, 12:13 UTC](https://meta.discourse.org/t/tags-how-can-admin-see-who-is-following-what-tags/83445 "2018-03-21T00:13:12Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![brendand](https://avatars.discourse-cdn.com/v4/letter/b/eada6e/32.png) [@brendand](https://meta.discourse.org/u/brendand)
#### Post date: [Mars 21, 2018, 12:13 UTC](https://meta.discourse.org/t/tags-how-can-admin-see-who-is-following-what-tags/83445/1 "2018-03-21T00:13:13Z")

</div>

We use tags and are wondering how we can see which tags our members have chosen to follow (whether “watching”, “following”, etc.) specific tags?

We are looking to bulk delete some tags but first want to understand how many of our users are potentially following / care about each tag.

Thanks for your insight!

Brendan

---

<div class="post-metadata">

### Author: ![ChrisBeach](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/chrisbeach/32/214628_2.png) [@ChrisBeach](https://meta.discourse.org/u/ChrisBeach)
#### Post date: [Mars 21, 2018, 12:16 UTC](https://meta.discourse.org/t/tags-how-can-admin-see-who-is-following-what-tags/83445/2 "2018-03-21T00:16:02Z")

</div>

A [data explorer](https://meta.discourse.org/t/data-explorer-plugin/32566) query will do it:

```
SELECT 
    name, 
    user_id, 
    notification_level 
FROM tag_users tu 
    JOIN tags t ON tu.tag_id = t.id

```

---

<div class="post-metadata">

### Author: ![SidV](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sidv/32/119460_2.png) [@SidV](https://meta.discourse.org/u/SidV)
#### Post date: [Avril 3, 2018, 6:09 UTC](https://meta.discourse.org/t/tags-how-can-admin-see-who-is-following-what-tags/83445/3 "2018-04-03T18:09:15Z")

</div>

Excellent @ChrisBeach ! 👏  
I added your query to **[the list](https://github.com/SidVal/discourse-data-explorer/blob/queries/querys.md)**.

A doubt here, I see that are four notification levels, can you tell me the levels?  
I mean, watching = 1? or 2 level? Muted = 4?

---

<div class="post-metadata">

### Author: ![neil](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/neil/32/102150_2.png) [@neil](https://meta.discourse.org/u/neil)
#### Post date: [Avril 3, 2018, 6:12 UTC](https://meta.discourse.org/t/tags-how-can-admin-see-who-is-following-what-tags/83445/4 "2018-04-03T18:12:34Z")

</div>

The notification levels are listed here:

> <https://github.com/discourse/discourse/blob/main/lib/notification_levels.rb#L3-L7>

---

<div class="post-metadata">

### Author: ![Drew-ART](https://avatars.discourse-cdn.com/v4/letter/d/8edcca/32.png) [@Drew-ART](https://meta.discourse.org/u/Drew-ART)
#### Post date: [Janvier 27, 2020, 2:30 UTC](https://meta.discourse.org/t/tags-how-can-admin-see-who-is-following-what-tags/83445/5 "2020-01-27T14:30:44Z")

</div>

Ce serait cool de voir cela ajouté à la page des statistiques. Davantage d’options pour aider à optimiser la façon dont les utilisateurs utilisent le site.