How to show non-staff posts with zero replies

[ondrej]

Something like this?

Data explorer query: find posts without replies

Following the topic: How to find topics without a reply from someone other than the topic owner? 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 Plugin

Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. Repository Link https://github.com/discourse/discourse-data-explorer Install Guide How to install plugins in Discourse 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 t…