免费观看又色又爽又黄的忠诚|免费看黄a级毛片成人片|免费看三级片久久|免费鲁丝无码一级|免费全部黄A片免费播放|免费人成视频在线

我想查詢用戶組為5，并且在dr_member_data 表中的qxmc字段值是zx和xbj字段值是1的用戶的score總數(shù)進(jìn)行排行，需要怎么寫呢？下面這樣寫好像不行

{member num=30 order=score groupid=5 sql="SELECT m.* FROM dr_member m LEFT JOIN dr_member_data d ON m.id=d.id WHERE d.qxmc='zx' AND d.xbj='1'"}

<div class="aui-flex b-line">

<div class="aui-ranking-text one">

<div class="number_top_circle"><strong>{$key+1}</strong></div>

</div>

<div class="aui-ranking-name aui-flex-box">

<h2><strong>{$t.name}</strong></h2>

</div>

<div class="aui-ranking-num"><strong>{$t.score}</strong>&nbsp;&nbsp;</div>

<div class="aui-ranking-icon">

<img src="/images/小紅花.png" alt="" style="width:26px;">

</div>

</div>

{/member}