How can I see how many topics a category consist of?
Does this Data Explorer query work for your needs? It will show you a count of topics and posts in each category:
SELECT category_id, stats.topic_count, stats.post_count FROM categories ccc LEFT JOIN (SELECT topics.category_id, Count(*) topic_count, SUM(topics.posts_count) post_count FROM topics WHERE ( "topics"."deleted_at" IS NULL ) AND ( topics.id NOT IN (SELECT cc.topic_id FROM categories cc WHERE topic_id IS NOT NULL) ) AND "topics"."visible" = true GROUP BY topics.category_id ) stats ON stats.category_id = ccc.id
Awesome, thanks @rishabh
Isn’t this possible by visiting the categories page? Categories - Discourse Meta
Yeah, it is. I don’t know how I missed that.
Now I know - it shows it on meta, but not on our community since we are using the boxes layout (and it doesn’t have the count apparently)
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.