{dede:sql sql="select a.id as aid,a.typeid,a.title,a.pubdate,d.id as did,d.downloads from 58pic_archives

 as a,58pic_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}