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

Summary 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 Features After installing the plugin, head to /admin/plugins . [de1] Click on the “Settings” button, and turn on data explorer enabled, then return and reload the pa…