用户列表循环 member标签按评论次数最多的排序输出
迅睿框架 更新 2023-09-09 17:25:58
求知若渴虚心若愚
求知若渴虚心若愚
{php $sql=urlencode('SELECT * FROM `dr_member` JOIN (select uid, count(*) as comment_num from dr_1_bbs_comment group by uid) comments ON dr_member.id=comments.uid order by comment_num desc');} {sql sql='$sql'} 累计评论数：{$t.comment_num} {/sql} {$debug}