Skip to content

Instantly share code, notes, and snippets.

@ogabrielsantos

ogabrielsantos/fb_10160848624995160.sql

Last active June 30, 2018 17:44
Show Gist options
  • Save ogabrielsantos/64bf7599d3d9032fd63b60a781a94362 to your computer and use it in GitHub Desktop.
Save ogabrielsantos/64bf7599d3d9032fd63b60a781a94362 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fb_10160848624995160.sql
SELECT user.user_id, guild.name AS guild_name, guild.guild_id, user.gender, user.name, user.locale, user.level, user.honor
FROM user
INNER JOIN guild ON guild.guild_id = user.guild_id
ORDER BY user.honor DESC, user.level DESC, user.name DESC, user.user_id DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment