# 正在查询某类别的总浏览量
**URL:** https://meta.discourse.org/t/working-on-querying-total-view-of-a-category/92964
**Category:** Support
**Created:** [2018年七月23日 21:21 UTC](https://meta.discourse.org/t/working-on-querying-total-view-of-a-category/92964 "2018-07-23T21:21:53Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@jerdog](https://meta.discourse.org/u/jerdog)
#### Post date: [2018年七月23日 21:21 UTC](https://meta.discourse.org/t/working-on-querying-total-view-of-a-category/92964/1 "2018-07-23T21:21:53Z")
So we’re wanting to measure the number of views a specific category gets and so I have done a query for it:
```
SELECT date_part('month', created_at) as Mth,
sum(views) as FAQViews
FROM topics
WHERE category_id = '11'
GROUP BY Mth
```
and its returning values grouped by the month, but the values are like 1/100th what the category listing shows… Not sure what I am missing here
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [2018年七月23日 23:57 UTC](https://meta.discourse.org/t/working-on-querying-total-view-of-a-category/92964/2 "2018-07-23T23:57:27Z")
Looks more or less right except that you are not including year and you are including deleted content. Maybe your category\_id is wrong…
---
### Author:  [@jerdog](https://meta.discourse.org/u/jerdog)
#### Post date: [2018年七月24日 14:26 UTC](https://meta.discourse.org/t/working-on-querying-total-view-of-a-category/92964/3 "2018-07-24T14:26:08Z")
Yeah - had the wrong category and need to also ignore deleted
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [2018年八月23日 14:26 UTC](https://meta.discourse.org/t/working-on-querying-total-view-of-a-category/92964/4 "2018-08-23T14:26:18Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.