//查询评论最多的前几条数据
$data=
$this->bbscomments->alias(
'a')
->join(
'LEFT JOIN __BBS__ b on b.bbs_id = a.bbs_id')
->field(
"count(*) as count,a.bbs_id,b.topic")
->group(
"bbs_id")->order(
'count desc')->limit(
0,
3)->select();