Skip to content

Instantly share code, notes, and snippets.

@juniorb2ss

juniorb2ss/gist:e4643ae9518484ca0654

Last active January 6, 2016 16:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save juniorb2ss/e4643ae9518484ca0654 to your computer and use it in GitHub Desktop.
Save juniorb2ss/e4643ae9518484ca0654 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment