# 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 Julho , 2017 07: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:** 8
**Page:** 1
### Author:  [@Sujan](https://meta.discourse.org/u/Sujan)
#### Post date: [18 Julho , 2017 07:20 UTC](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361/1 "2017-07-18T07:20:31Z")
Is there a way to get my replies (answers to posts) that didn’t get a reply after that?
As moderator in a dev (support) forum, I am sometimes more a triage bot that asks people for clarification, missing data, etc. Now some people seem to think it is ok to just ignore these and I want to see how many there are.
Is there a way to find my replies that I wrote in topics and that didn’t get a reply?
Maybe even with an additional filter of “2 posts in topic” to get those where only the initial topic post and mine exist?
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [18 Julho , 2017 08:23 UTC](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361/2 "2017-07-18T08:23:27Z")
Check out the [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin.
---
### Author:  [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [18 Julho , 2017 10:32 UTC](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361/3 "2017-07-18T10:32:28Z")
You can use the ?max\_posts=1 query too.
Example:
[Discourse Meta](https://meta.discourse.org/?max_posts=1)
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [18 Julho , 2017 10:47 UTC](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361/4 "2017-07-18T10:47:25Z")
Aha! I looked too quickly on the advanced search page. I now see “min post count”, which might have been enough for me to infer your solution.
---
### Author:  [@Sujan](https://meta.discourse.org/u/Sujan)
#### Post date: [18 Julho , 2017 11:45 UTC](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361/5 "2017-07-18T11:45:09Z")
Sorry, seems my title and question were not clear enough. I edited both
`max_posts` works great to find posts that didn’t get any or enough replies.
I am really looking for a way to find my posts where I replied to someone, and this reply is the last post in the topic.
---
### Author:  [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [18 Julho , 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")
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)
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [30 Junho , 2019 19:52 UTC](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361/7 "2019-06-30T19:52:12Z")
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [30 Julho , 2019 19:52 UTC](https://meta.discourse.org/t/how-to-find-my-replies-that-didnt-get-a-reply/66361/8 "2019-07-30T19:52:16Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.