# How to find my replies that didn't get a reply?

**URL:** <https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361>\
**Category:** Support\
**Created:** [18 يوليو 2017، 7:20ص UTC](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361 "2017-07-18T07:20:31Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![cpradio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cpradio/32/4970_2.png) [@cpradio](https://meta.discourse.org/u/cpradio)\
**Post date:** [18 يوليو 2017، 12:00م UTC](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361/6 "2017-07-18T12:00:56Z")

</div>

Oh, that would have to be done via the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) Plugin.

This might get you there (replace my username with your own).

```plaintext
SELECT u.username, t.id, t.posts_count, p.post_number FROM topics AS t 
  LEFT JOIN posts AS p ON t.id = p.topic_id AND t.posts_count = p.post_number
  LEFT JOIN users AS u ON p.user_id = u.id
  WHERE u.username = 'cpradio'

```

It is grabbing the posts that have a post\_number the same value as the posts\_count for the topic (thus the last post), and then checking that the username on that post is ‘cpradio’

[last-reply.dcquery.json](https://global.discourse-cdn.com/meta/original/3X/6/1/61541f0280ba662b454f80a95559b05a80cbe091.json) (363 Bytes)

---

_[View the full topic](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361)._