# How to show non-staff posts with zero replies

**URL:** https://meta.discourse.org/t/how-to-show-non-staff-posts-with-zero-replies/245797
**Category:** Support
**Created:** [November 16, 2022, 5:16pm UTC](https://meta.discourse.org/t/how-to-show-non-staff-posts-with-zero-replies/245797 "2022-11-16T17:16:31Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![ondrej](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ondrej/32/198804_2.png) [@ondrej](https://meta.discourse.org/u/ondrej)
#### Post date: [November 16, 2022, 6:52pm UTC](https://meta.discourse.org/t/how-to-show-non-staff-posts-with-zero-replies/245797/2 "2022-11-16T18:52:20Z")

</div>

Something like this?

> [@Data explorer query: find posts without replies](https://meta.discourse.org/t/data-explorer-query-find-posts-without-replies/179767):
>
> Following the topic: [How to find topics without a reply from someone other than the topic owner?](https://meta.discourse.org/t/how-to-find-posts-not-first-posts-and-not-topics-without-a-reply/179760) I created this query, but in my case there is a problem. PG::UndefinedTable: ERROR: missing FROM-clause entry for table "t" LINE 31: AND t.category\_id = ANY ('{48,23}'::int[]) Here is the query’ code: -- [params] -- int :months\_ago = 1 WITH query\_period as ( SELECT date\_trunc('month', CURRENT\_DATE) - INTERVAL ':months\_ago months' as period\_start, date\_trunc('month', CURRE…

I’d recommend this plugin

> [@Discourse Data Explorer](https://meta.discourse.org/t/discourse-data-explorer/32566):
>
> discourse2Summary Discourse [Data Explorer](https://meta.discourse.org/t/32566?silent=true) allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately.information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #Data & reporting category under the #sql-query tag. If there’s not one to suit your pa…

---

_[View the full topic](https://meta.discourse.org/t/how-to-show-non-staff-posts-with-zero-replies/245797)._