# Mysterious entries in topic\_users table

**URL:** <https://meta.discourse.org/t/mysterious-entries-in-topic-users-table/44080>\
**Category:** Bug\
**Created:** [11 Maggio 2016, 8:17pm 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:** 1

<div class="post-metadata">

**Author:** ![fefrei](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/fefrei/32/119538_2.png) [@fefrei](https://meta.discourse.org/u/fefrei)\
**Post date:** [11 Maggio 2016, 8:17pm UTC](https://meta.discourse.org/t/mysterious-entries-in-topic-users-table/44080/1 "2016-05-11T20:17:39Z")

</div>

I’m running a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query to see which users read a specific post:

```plaintext
-- [params]
-- integer :topic = 0

SELECT *, total_msecs_viewed / (1000 * 60) as mins_read
FROM topic_users
WHERE topic_id = :topic
ORDER BY total_msecs_viewed DESC

```

The results look plausible, except for a mysterious nonexisting user:

 ![](https://global.discourse-cdn.com/meta/original/3X/3/6/36c463d9b149df7d732d2edd0788b10800af85eb.png)

This is the result for topic `200`. The user id `200` is not used in my installation (I have fewer users).  
The same thing is happening for all other topics, there is always an entry for a “user” whose id matches the topic id.

Am I overlooking a very obvious bug in my SQL code? Is this entry really there? Should it be?

---

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