blog开发

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);
	}