我本想看看某个特定话题的讨论热度随时间的变化趋势,于是编写了一个查询,用于获取该话题按日期统计的阅读次数。
但问题是,查询返回的计数值比 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