将以下代码加到首页模板里面
<table>
[e:loop={'SELECT news . * FROM phome_enewsmember member INNER JOIN (SELECT userid, username, COUNT( userid ) AS total FROM phome_ecms_news WHERE ismember =1 GROUP BY userid)news WHERE member.userid = news.userid order by news.total desc',10,24,0}]
<tr>
<td><?=$bqno?></td>
<td><?=$bqr[username]?></td>
<td><?=$bqr[total]?></td>
</tr>
[/e:loop]
</table>
注:调用的是会员组id为1的会员发布的新闻数据表数量排序