Some sick MySQL query

GetClanRank.sql

SELECT sb.rang
FROM (
    SELECT sq.clan, (@num := @num +1) as rang FROM (
        SELECT 
            mcm.cname AS clan, 
            SUM(ms.trophies) AS trophies 
         FROM MuxClanMembers AS mcm 
         LEFT JOIN MuxUser AS ms 
         ON mcm.uuid = ms.uuid 
         WHERE mcm.eingeladen = 0 
         GROUP BY mcm.cname
         ORDER BY trophies DESC
    ) AS sq 
) AS sb
WHERE clan = 'Brutalos'