Hi Guest,
18:58 Day
Username :
Password :
By PKM  |  By Trainer  |  By Clan By PKM  |  By Trainer  |  By Clan

This rankings shows the total points, wins and losses of each trainer.



Ce classement fait le cumul des points, victoires et défaites de chaque dresseur.

[ - ]


SELECT u.`username`, p.`id_membre`, u.`el_points_mois` as spoints, u.`el_victoires_mois` as svictoire, u.`el_defaites_mois` as sdefaite, COUNT(*) as nb FROM `elevage_pokemon` as p LEFT JOIN `punbb_users` as u ON p.`id_membre`=u.`id` GROUP BY u.`id` ORDER BY spoints DESC, svictoire DESC, sdefaite ASC LIMIT 0,100;