Skip to content

Instantly share code, notes, and snippets.

@ctfaddict
Created April 24, 2014 05:48
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 ctfaddict/e9f1d633aafc8bc88c62 to your computer and use it in GitHub Desktop.
Save ctfaddict/e9f1d633aafc8bc88c62 to your computer and use it in GitHub Desktop.
scorebot_production=# select rt.name as team, count(*) steals
from redemptions r, instances i, teams rt, tokens t
where r.token_id = t.id and t.instance_id = i.id and rt.id = r.team_id
and r.team_id != i.team_id
group by rt.name
order by count(*) desc;
team | steals
---------------------------+--------
PPP | 2525
raon_ASRT | 1725
more smoked leet chicken | 1680
men in black hats | 1594
shellphish | 1222
blue lotus | 1100
Alternatives | 1095
routards | 951
pwningyeti | 841
Samurai | 785
9447 | 757
The European Nopsled Team | 731
shell corp | 688
sutegoma2 | 661
[Technopandas] | 541
pwnies | 536
WOWHacker-BI0S | 442
clgt | 386
Robot Mafia | 171
APT8 | 36
(20 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment