ppypp伦理天堂,91手机在线视频,免费在线观看黄色毛片,夜夜穞天天穞狠狠穞AV美女按摩

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

{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}