# Feature request: PM status, Read/unread indication

**URL:** <https://meta.discourse.org/t/feature-request-pm-status-read-unread-indication/53908>\
**Category:** Feature\
**Created:** [December 7, 2016, 9:04am UTC](https://meta.discourse.org/t/feature-request-pm-status-read-unread-indication/53908 "2016-12-07T09:04:22Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [December 7, 2016, 10:07am UTC](https://meta.discourse.org/t/feature-request-pm-status-read-unread-indication/53908/2 "2016-12-07T10:07:44Z")

</div>

I’m sure it could be improved and customized with some tweaking, but this query works OK using the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin

```plaintext
WITH unread_messages AS (SELECT topic_users.user_id AS tuui
    , topic_users.topic_id AS tuti
    FROM topic_users 
    WHERE topic_users.last_read_post_number IS NULL 
    AND topic_users.highest_seen_post_number IS NULL 
    AND topic_users.notifications_reason_id = 2
    )
SELECT unread_messages.tuui
     , users.username
     , unread_messages.tuti
FROM unread_messages, topics, users 
WHERE topics.archetype LIKE 'private_message'
AND topics.subtype LIKE 'system_message'
AND topics.id = unread_messages.tuti
AND users.active 
AND ( users.suspended_till IS NULL
   OR users.suspended_till < NOW() )
AND NOT users.admin
AND NOT users.moderator
AND users.id = unread_messages.tuui 
ORDER BY unread_messages.tuui

```

```plaintext
tuui username tuti
15 TrollGuy1 55
15 TrollGuy1 54
15 TrollGuy1 115
21 PersecutorGuy1 109

```

---

_[View the full topic](https://meta.discourse.org/t/feature-request-pm-status-read-unread-indication/53908)._