上传之星SQL代码

来源:互联网 发布:超级妖孽软件 编辑:程序博客网 时间:2024/05/21 06:37
SELECT users.username AS '发种人', COUNT(*) AS '发种数', SUM(torrents.size)/1073741824 AS '发种量'FROM users, torrentsWHERE users.id = torrents.ownerAND torrents.added BETWEEN '2012-11-16 00:00:00' AND '2012-11-22 23:59:59'GROUP BY torrents.ownerORDER BY `发种量` DESC, `发种数` DESC

原创粉丝点击