我正在使用 mybb，如何找到当前读者最多的前 5 个主题？

发布于 2024-11-25 11:54:18 字数 440 浏览 1 评论 0原文

我正在使用 MyBB，我想在我的网站主页上显示当前拥有最多读者的主题强>。

我假设我必须查询会话表，但我不知道该怎么做

我需要的 mysql 结果应该类似于：

-------------------------
|title          | count |
-------------------------
|thread a title | 1234  |
|thread b title | 913   |
|thread c title | 678   |
|another  title | 593   |
|different title| 550   |
-------------------------

谢谢:)

原文

I'm using MyBB, I want to show on my website homepage the threads that has the most readers currently.

I'm assuming I have to query the session table but I'm not sure how should I do it

The mysql result I need, should look something like:

-------------------------
|title          | count |
-------------------------
|thread a title | 1234  |
|thread b title | 913   |
|thread c title | 678   |
|another  title | 593   |
|different title| 550   |
-------------------------

Thank you :)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

森林迷了鹿 2024-12-02 11:54:18

我刚刚在我的板上进行了测试，我认为这就是您所需要的：

SELECT COUNT(*) as count, subject as title
FROM `mybb_sessions`,`mybb_threads`
WHERE location1 = tid
GROUP BY `location1`
ORDER BY COUNT(*) DESC
LIMIT 10

I've just tested that on my board, I think this is what you need:

SELECT COUNT(*) as count, subject as title
FROM `mybb_sessions`,`mybb_threads`
WHERE location1 = tid
GROUP BY `location1`
ORDER BY COUNT(*) DESC
LIMIT 10

回复收藏 0 原文

~没有更多了~