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
上传之星SQL代码
最新推荐文章于 2024-09-03 17:11:34 发布