我想获取昨日点赞或者浏览量，前10的帖子，有什么办法可以得到吗,似乎数据库存储的都是累计值，谢谢

没有启用呢，是不是需要启用才会记录更详细的数据

You should enable it, then you’ll be able to make specific queries scoped to the past day (yesterday). Query for Top 10 Posts by Likes from Yesterday -- Top 10 Posts by Likes from Yesterday WITH yesterday_actions AS ( SELECT post_id, COUNT(*) AS like_count FROM post_actions WHERE …

Get yesterday's top 10 posts by likes or views

Поддержка

ondrej 17.Сентябрь.2025 07:56:34 2

Hey

Do you have the Discourse Data Explorer plugin enabled on your site?

Тема		Ответов	Просм.
Get last :heart: via API Development	2	1702	04.09.2017
API - Get count of latest Support	3	1387	03.08.2018
Recently Read Topics by User Data & reporting sql-query	0	158	04.05.2016
How to get top 3 topic which have most active replies in last 30 days Development	0	370	30.01.2023
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	155	31.12.2019

Get yesterday's top 10 posts by likes or views

Связанные темы