Skip to content

Instantly share code, notes, and snippets.

@maddyblue
Created March 13, 2018 09:09
Show Gist options
  • Save maddyblue/921edf7ab4607637f656550126e8aac3 to your computer and use it in GitHub Desktop.
Save maddyblue/921edf7ab4607637f656550126e8aac3 to your computer and use it in GitHub Desktop.
explain select g.game, g.blizzid, g.winner from (select game, blizzid from players where build=68 and mode=1 and hero_level >= 5) p join players g on p.game = g.game and p.blizzid = g.blizzid where g.skill > 25000000;
set experimental_force_lookup_join = true;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment