大部分網(wǎng)上提供的織夢下載排行都只能針對一個軟件只有一個下載地址的情況，
如果一個軟件里有多個下載地址就不行了，以下sql語句可以解決這個問題：
select a.id as aid,a.title,a.shorttitle,a.litpic,d.id as did,sum(d.downloads) as downloads from dede_archives as a,dede_downloads as d where a.id = d.id and a.arcrank=0 group by d.id order by downloads desc limit 10