# Comment afficher les publications non-staff sans réponses
**URL:** https://meta.discourse.org/t/how-to-show-non-staff-posts-with-zero-replies/245797
**Category:** Support
**Created:** [Novembre 16, 2022, 5:16 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:** 4
**Page:** 1
### Author:  [@Vikteur](https://meta.discourse.org/u/Vikteur)
#### Post date: [Novembre 16, 2022, 5:16 UTC](https://meta.discourse.org/t/how-to-show-non-staff-posts-with-zero-replies/245797/1 "2022-11-16T17:16:31Z")
Salut !
Je cherche un moyen d’afficher tous les messages des membres non-staff qui n’ont pas encore reçu de réponse. Est-ce qu’il y a un moyen de faire ça ?
---
### Author:  [@ondrej](https://meta.discourse.org/u/ondrej)
#### Post date: [Novembre 16, 2022, 6:52 UTC](https://meta.discourse.org/t/how-to-show-non-staff-posts-with-zero-replies/245797/2 "2022-11-16T18:52:20Z")
Quelque chose comme ça ?
> [@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…
Je recommanderais ce 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…
---
### Author:  [@Benjamin\_D](https://meta.discourse.org/u/Benjamin_D)
#### Post date: [Novembre 16, 2022, 7:06 UTC](https://meta.discourse.org/t/how-to-show-non-staff-posts-with-zero-replies/245797/3 "2022-11-16T19:06:06Z")
`search?q=max_posts%3A1` est possible mais n’accepte malheureusement pas `@somegroup` comme paramètre, seulement `@anyuser`.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [Décembre 16, 2022, 7:06 UTC](https://meta.discourse.org/t/how-to-show-non-staff-posts-with-zero-replies/245797/4 "2022-12-16T19:06:14Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.