按日期查看主题阅读数

我本想看看某个特定话题的讨论热度随时间的变化趋势,于是编写了一个查询,用于获取该话题按日期统计的阅读次数。

但问题是,查询返回的计数值比 UI 上显示的话题总阅读量要少。

请问我可能漏掉了什么?

-- [参数]
-- integer :tema = 1
select topic_id, viewed_at as fecha, count(1) as vistas from topic_views 
group by topic_id, viewed_at 
having topic_id = :tema
order by fecha asc
1 个赞