Query:
SELECT SQL_CALC_FOUND_ROWS `username`, `usergroup`, `regdate`, count(torrent.`user`) AS `torrents` FROM `user` LEFT OUTER JOIN `torrent` ON (user.`id` = torrent.`user`) GROUP BY `uid` ORDER BY field(`usergroup`, 4, 3, 6, 10, 9, 8, 2), `torrents` DESC, `username` LIMIT 0, 50
SQL Error:
1054(Unknown column 'uid' in 'group statement')
Slave ID:
0
Session Closed