24-08-2007, 02:56 PM
Tiens c'est ce que j'utilise peu etre que sa pourra t'aider
SELECT alliances.nom_alliance, sum(membres.points) as points_alliance FROM `alliances` LEFT JOIN `membres` ON membres.id_alliance = alliances.id_alliance GROUP BY alliances.id_alliance ORDER BY points_alliance DESC LIMIT 0 , 30"
SELECT alliances.nom_alliance, sum(membres.points) as points_alliance FROM `alliances` LEFT JOIN `membres` ON membres.id_alliance = alliances.id_alliance GROUP BY alliances.id_alliance ORDER BY points_alliance DESC LIMIT 0 , 30"