上传之星SQL代码

SELECT users.username AS '发种人', COUNT(*) AS '发种数', SUM(torrents.size)/1073741824 AS '发种量'
FROM users, torrents
WHERE users.id = torrents.owner
AND torrents.added BETWEEN '2012-11-16 00:00:00' AND '2012-11-22 23:59:59'
GROUP BY torrents.owner
ORDER BY `发种量` DESC, `发种数` DESC