以下可以调用下载次数最高的10篇文章,如果你的表不是dede开头,请更改下: {dede:sql sql="select a.id as aid,a.typeid,a.title,a.pubdate,d.id as did,d.downloads from dede_archives as a,dede_downloads as d where a.id = d.id order by d.downloads desc limit 0,10;"} <li> <a title="[field:title /]" href="[field:aid function=GetinfoUrl(@me,10) /]"> [field:title function='cn_substr(@me,26)'/] </a> -下载数:<font color='red'>[field:downloads/]</font> </li> {/dede:sql} (责任编辑:迷城网络科技) |