gistfile1.txt

SELECT
users.name,
chars.*,
guild.name as 'guild_name'
FROM
char_wstats as chars
JOIN pvpm_data as users ON chars.char_id = users.id
JOIN guild ON chars.char_id = guild.char_id
ORDER BY
chars.kill_count DESC
LIMIT 50