Je možnost to nějak zjistit? Napadá mě pouze COUNT(*) AS rows.

Zeptal jsem se kamaráda a ten mi poradil tento subsyntax.

"SELECT *, (SELECT SUM(points) FROM cmsg_playerstats WHERE cmsg_playerstats.player = cmsg_playersactivity.user) AS total_points FROM cmsg_playersactivity ORDER BY total_points"

Jdu to tedy vyzkoušet a dám vědět :)