# Número de tópicos em uma categoria

**URL:** https://meta.discourse.org/t/number-of-topics-in-a-category/163952
**Category:** Support
**Created:** [14 Setembro , 2020 11:20 UTC](https://meta.discourse.org/t/number-of-topics-in-a-category/163952 "2020-09-14T11:20:48Z")
**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: [14 Setembro , 2020 11:40 UTC](https://meta.discourse.org/t/number-of-topics-in-a-category/163952/2 "2020-09-14T11:40:23Z")

</div>

Olá, Toni,

Essa consulta do [Data Explorer](https://meta.discourse.org/t/32566?silent=true) atende às suas necessidades? Ela mostrará a contagem de tópicos e posts em cada categoria:

![image](https://global.discourse-cdn.com/meta/original/3X/2/6/26c76ecbb8dfa5cd5c1bd8c22c3aac9adca7194b.png)

```plaintext
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

```

---

_[View the full topic](https://meta.discourse.org/t/number-of-topics-in-a-category/163952)._