Ces classements font le cumul des points, victoires et défaites de chaque dresseur.
Ce classement fait le cumul des points, victoires et défaites de tous les dresseurs de chaque clan.
[ - ]
SELECT c.`nom`, c.`id` as idclan, COUNT(DISTINCT(u.`id`)) as nbm, SUM(u.`el_points_mois`) as spoints, SUM(u.`el_victoires_mois`) as svictoire, SUM(u.`el_defaites_mois`) as sdefaite FROM `punbb_users` as u LEFT JOIN `elevage_clans` as c ON u.`el_id_clan` = c.`id` WHERE (u.`el_id_clan` > 0) AND (u.`id` IN (SELECT `id_membre` FROM `elevage_pokemon`)) GROUP BY u.`el_id_clan` ORDER BY spoints DESC, svictoire DESC, sdefaite ASC LIMIT 0,100