Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure21 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 r.team_id = t.id and r.token_id = k.id
and k.instance_id = i.id and r.team_id != i.team_id
group by t.name
order by total desc;
team | total
---------------------------+-------
PPP | 12845
raon_ASRT | 6241
men in black hats | 5115
more smoked leet chicken | 3656
shellphish | 1477
Alternatives | 1181
blue lotus | 1104
sutegoma2 | 1041
9447 | 1005
pwnies | 832
The European Nopsled Team | 777
routards | 776
pwningyeti | 702
Samurai | 674
shell corp | 606
WOWHacker-BI0S | 423
[Technopandas] | 370
clgt | 274
Robot Mafia | 99
APT8 | 67
(20 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment