# Trouver les utilisateurs qui ont lu des sujets spécifiques

**URL:** <https://meta.discourse.org/t/find-users-who-read-specific-topics/100657>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [Octobre 28, 2018, 4:04 UTC](https://meta.discourse.org/t/find-users-who-read-specific-topics/100657 "2018-10-28T04:04:16Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)\
**Post date:** [Octobre 28, 2018, 10:50 UTC](https://meta.discourse.org/t/find-users-who-read-specific-topics/100657/2 "2018-10-28T22:50:13Z")

</div>

For the users having read a certain topic, you need to join on the “`topic_user`” table.

For the categories, you need to filter the topics of said categories 😉

---

_[View the full topic](https://meta.discourse.org/t/find-users-who-read-specific-topics/100657)._