Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure22 Secret

Created Apr 24, 2014
Embed
What would you like to do?
scorebot_production=# select t.name as team, count(*) as total
from captures c, redemptions r, teams t, tokens k, instances i
where c.redemption_id = r.id and i.team_id = t.id and r.token_id = k.id
and k.instance_id = i.id
group by t.name
order by total desc;
team | total
---------------------------+-------
men in black hats | 5666
blue lotus | 3740
Alternatives | 3105
9447 | 2751
more smoked leet chicken | 2707
shellphish | 2648
APT8 | 2483
pwnies | 2099
raon_ASRT | 2051
pwningyeti | 1949
The European Nopsled Team | 1895
Samurai | 1879
[Technopandas] | 1837
WOWHacker-BI0S | 1825
clgt | 1465
Robot Mafia | 1456
routards | 1402
PPP | 1347
sutegoma2 | 1336
shell corp | 1039
(20 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment