li
public List<Object[]> caculateTopTopic(){ //各个的topic的回复数 回复数占比重为 20 点击数占1 String sql = " select count(post.f_id)*15+topic.f_clicks ss,topic.f_id topicId,forum.f_id forumId,topic.f_subject topicSubject" + " from t_post post inner join t_topic topic" + " on post.f_topic_id = topic.f_id" + " inner join t_forum forum" + " on topic.f_blog_id = forum.f_id" + " group by topic.f_id " + " order by ss desc limit 0, 20 "; return manager.findByNativeSql(sql, null, null); }