# 카테고리 목록에 주제 수 표시

**URL:** https://meta.discourse.org/t/show-topic-count-in-category-list/160857
**Category:** Support
**Created:** [8월 14, 2020, 11:22오전 UTC](https://meta.discourse.org/t/show-topic-count-in-category-list/160857 "2020-08-14T11:22:19Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![rishabh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rishabh/32/179446_2.png) [@rishabh](https://meta.discourse.org/u/rishabh)
#### Post date: [9월 14, 2020, 11:42오전 UTC](https://meta.discourse.org/t/show-topic-count-in-category-list/160857/2 "2020-09-14T11:42:14Z")

</div>

UI 어디에도 표시되지 않지만, 숫자를 확인해야 한다면 다음 [Data Explorer](https://meta.discourse.org/t/32566?silent=true) 쿼리를 사용해 볼 수 있습니다:

> [@카테고리별 주제 수](https://meta.discourse.org/t/number-of-topics-in-a-category/163952/2?u=rishabh):
>
> 토니, 안녕하세요. 이 [Data Explorer](https://meta.discourse.org/t/32566?silent=true) 쿼리가 필요하신 조건에 맞을까요? 각 카테고리별 주제(topic)와 게시글(post)의 개수를 표시해 줍니다: [image] 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 ) …

---

_[View the full topic](https://meta.discourse.org/t/show-topic-count-in-category-list/160857)._
