# Can I generate a report of users who have NOT posted in a given topic?

**URL:** <https://meta.discourse.org/t/can-i-generate-a-report-of-users-who-have-not-posted-in-a-given-topic/111425>\
**Category:** Product Support\
**Created:** [March 12, 2019, 9:08pm UTC](https://meta.discourse.org/t/can-i-generate-a-report-of-users-who-have-not-posted-in-a-given-topic/111425 "2019-03-12T21:08:35Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [March 12, 2019, 10:00pm UTC](https://meta.discourse.org/t/can-i-generate-a-report-of-users-who-have-not-posted-in-a-given-topic/111425/5 "2019-03-12T22:00:46Z")

</div>

What about something like this? 🤔

```sql
-- [params]
-- int :cat_id = 4
-- int :limit = 10

SELECT id, username
FROM users u
WHERE u.id NOT IN 
(SELECT user_id FROM categories WHERE id=:cat_id)
LIMIT :limit

```

---

_[View the full topic](https://meta.discourse.org/t/can-i-generate-a-report-of-users-who-have-not-posted-in-a-given-topic/111425)._