大部分網(wǎng)上提供的織夢(mèng)下載排行都只能針對(duì)一個(gè)軟件只有一個(gè)下載地址的情況，
如果一個(gè)軟件里有多個(gè)下載地址就不行了，以下sql語(yǔ)句可以解決這個(gè)問(wèn)題：
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