12Next >
dujun0618 | 发表于:11-12-14 17:02 11楼 [回复] #Top# |
---|---|
![]() ![]() ![]() |
<ul class="list rank-list">
{king:sql cmd="select top 20 listname,listpath,arthits,artcount,listid1 from (SELECT kingart_list.listid1,kingart_list.listname,kingart_list.listpath,sum(arthit) as arthits,count(*) as artcount FROM kingart_list INNER JOIN kingart ON kingart_list.listid = kingart.listid group by kingart_list.listname, kingart_list.listpath,kingart_list.listid1) where listid1=[currentlistid/] order by arthits desc,listname;"} <li><em class="ranknum rankred">(king:++/)</em><a href="(king:listpath/)" class="fl">(king:listname/)</a><span class="linum">(点击:(king:arthits/) 文章:(king:artcount/))</span></li> {/king} </ul> |
2678389407 | 发表于:11-12-19 17:10 12楼 [回复] #Top# |
---|---|
![]() ![]() ![]() ![]() |
跟这学习了。谢谢
|
12Next >