织梦DedeCMS调用软件下载排行的方法

{dede:sql sql="select a.id as aid,a.typeid,a.title,a.pubdate,d.id as did,d.downloads from mo_archives 
as a,mo_downloads as d where a.id = d.id and a.arcrank=0 and a.typeid!= 15 and a.typeid != 
44 and (UNIX_TIMESTAMP()-a.pubdate)/3600/24 BETWEEN 0 AND 15 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}