Klánok verseny

SELECT azon, (select sum(pont) from pont where userid=klan.azon) as klantp,(SELECT sum(pont) as p FROM pont as p2 WHERE p2.userid in (select azon from user where lower(klanazon)=lower(klan.azon))) as egyeni, (select sum(pont) from pont where userid=klan.azon) +(SELECT sum(pont) as p FROM pont as p2 WHERE p2.userid in (select azon from user where lower(klanazon)=lower(klan.azon))) FROM `klan` where azon<>'KX' order by 4 desc

A klánok versenyének jelenlegi állása: