kito2
www.masteria.net
Hey there, I have been trying to do somehow to get the top fragger and the top noob of a war, showing like
Top Fragger: Player Name (Frags/Deaths)
Top Noob: Player Name (Frags/Deaths)
But it is really complex since it has a lot of inner join and left join and couldn't manage how to do it... Could any one help on this?
PS: Here I could get all the deaths of a war:
Top Fragger: Player Name (Frags/Deaths)
Top Noob: Player Name (Frags/Deaths)
But it is really complex since it has a lot of inner join and left join and couldn't manage how to do it... Could any one help on this?
PS: Here I could get all the deaths of a war:
Code:
SELECT * FROM `players` WHERE players.id in (select player_deaths.player_id from player_deaths inner join guild_kills on guild_kills.death_id = player_deaths.id inner join guild_wars on guild_wars.id = guild_kills.war_id where guild_wars.id = 52)
