# Mysterious entries in topic\_users table

**URL:** <https://meta.discourse.org/t/mysterious-entries-in-topic-users-table/44080>\
**Category:** Bug\
**Created:** [11.Май.2016 20:17:39 UTC](https://meta.discourse.org/t/mysterious-entries-in-topic-users-table/44080 "2016-05-11T20:17:39Z")\
**Posts on this page:** 1\
**Showing post:** 20

<div class="post-metadata">

**Author:** ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)\
**Post date:** [14.Май.2016 15:25:42 UTC](https://meta.discourse.org/t/mysterious-entries-in-topic-users-table/44080/20 "2016-05-14T15:25:42Z")

</div>

I was thinking of that too

First thought would be  
WHERE topic\_id = user\_id  
except there may be cases where an actual member with the same id as a topic should be there

Adding `notification_level = 1` (assigned as the default) and

```plaintext
last_read_post_number IS NULL 
highest_seen_post_number IS NULL

```

would only falsely delete members that had set the category as Normal via the category drop-down which seems like that would be very rare, but is possible I guess.

The safest would be

````plaintext
topic_id > MAX(users.id)
```. 
but depending on how many members there are could leave quite a few.
````

---

_[View the full topic](https://meta.discourse.org/t/mysterious-entries-in-topic-users-table/44080)._