-
-
Save ctfaddict/49c14aeee70f3b2ef762 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
scorebot_production=# select rt.name as attacker, it.name as victim, count(*) as steals | |
from redemptions r, instances i, teams rt, teams it, tokens t | |
where r.token_id = t.id and t.instance_id = i.id and r.team_id = rt.id | |
and i.team_id = it.id and r.team_id != i.team_id | |
group by rt.name, it.name | |
order by rt.name asc, count(*) desc; | |
attacker | victim | steals | |
---------------------------+---------------------------+-------- | |
9447 | pwnies | 134 | |
9447 | APT8 | 132 | |
9447 | Samurai | 79 | |
9447 | shell corp | 65 | |
9447 | Alternatives | 50 | |
9447 | Robot Mafia | 48 | |
9447 | blue lotus | 46 | |
9447 | shellphish | 40 | |
9447 | WOWHacker-BI0S | 34 | |
9447 | clgt | 33 | |
9447 | raon_ASRT | 21 | |
9447 | The European Nopsled Team | 18 | |
9447 | men in black hats | 17 | |
9447 | more smoked leet chicken | 16 | |
9447 | [Technopandas] | 12 | |
9447 | routards | 9 | |
9447 | pwningyeti | 3 | |
Alternatives | APT8 | 273 | |
Alternatives | pwnies | 147 | |
Alternatives | shell corp | 98 | |
Alternatives | clgt | 94 | |
Alternatives | Samurai | 83 | |
Alternatives | Robot Mafia | 75 | |
Alternatives | blue lotus | 59 | |
Alternatives | 9447 | 58 | |
Alternatives | WOWHacker-BI0S | 50 | |
Alternatives | more smoked leet chicken | 32 | |
Alternatives | PPP | 25 | |
Alternatives | pwningyeti | 24 | |
Alternatives | shellphish | 24 | |
Alternatives | raon_ASRT | 22 | |
Alternatives | [Technopandas] | 19 | |
Alternatives | The European Nopsled Team | 9 | |
Alternatives | men in black hats | 2 | |
Alternatives | routards | 1 | |
APT8 | [Technopandas] | 16 | |
APT8 | shell corp | 12 | |
APT8 | pwnies | 8 | |
blue lotus | APT8 | 280 | |
blue lotus | pwnies | 155 | |
blue lotus | shell corp | 106 | |
blue lotus | clgt | 93 | |
blue lotus | Samurai | 92 | |
blue lotus | Robot Mafia | 77 | |
blue lotus | 9447 | 69 | |
blue lotus | Alternatives | 46 | |
blue lotus | WOWHacker-BI0S | 42 | |
blue lotus | more smoked leet chicken | 27 | |
blue lotus | raon_ASRT | 26 | |
blue lotus | shellphish | 22 | |
blue lotus | [Technopandas] | 19 | |
blue lotus | pwningyeti | 18 | |
blue lotus | PPP | 13 | |
blue lotus | The European Nopsled Team | 11 | |
blue lotus | routards | 4 | |
clgt | APT8 | 174 | |
clgt | pwnies | 84 | |
clgt | Samurai | 51 | |
clgt | Robot Mafia | 21 | |
clgt | WOWHacker-BI0S | 19 | |
clgt | shell corp | 11 | |
clgt | [Technopandas] | 10 | |
clgt | Alternatives | 6 | |
clgt | raon_ASRT | 4 | |
clgt | pwningyeti | 3 | |
clgt | PPP | 2 | |
clgt | blue lotus | 1 | |
men in black hats | APT8 | 260 | |
men in black hats | pwnies | 195 | |
men in black hats | WOWHacker-BI0S | 127 | |
men in black hats | [Technopandas] | 121 | |
men in black hats | Robot Mafia | 109 | |
men in black hats | Samurai | 103 | |
men in black hats | clgt | 96 | |
men in black hats | blue lotus | 86 | |
men in black hats | Alternatives | 80 | |
men in black hats | shell corp | 77 | |
men in black hats | shellphish | 57 | |
men in black hats | pwningyeti | 50 | |
men in black hats | more smoked leet chicken | 45 | |
men in black hats | raon_ASRT | 43 | |
men in black hats | routards | 39 | |
men in black hats | PPP | 36 | |
men in black hats | 9447 | 31 | |
men in black hats | sutegoma2 | 30 | |
men in black hats | The European Nopsled Team | 9 | |
more smoked leet chicken | APT8 | 302 | |
more smoked leet chicken | pwnies | 201 | |
more smoked leet chicken | shell corp | 119 | |
more smoked leet chicken | Robot Mafia | 118 | |
more smoked leet chicken | WOWHacker-BI0S | 109 | |
more smoked leet chicken | Samurai | 108 | |
more smoked leet chicken | clgt | 106 | |
more smoked leet chicken | blue lotus | 94 | |
more smoked leet chicken | Alternatives | 92 | |
more smoked leet chicken | [Technopandas] | 90 | |
more smoked leet chicken | 9447 | 79 | |
more smoked leet chicken | shellphish | 66 | |
more smoked leet chicken | PPP | 50 | |
more smoked leet chicken | routards | 40 | |
more smoked leet chicken | pwningyeti | 38 | |
more smoked leet chicken | The European Nopsled Team | 22 | |
more smoked leet chicken | raon_ASRT | 21 | |
more smoked leet chicken | men in black hats | 16 | |
more smoked leet chicken | sutegoma2 | 9 | |
PPP | APT8 | 341 | |
PPP | pwnies | 307 | |
PPP | [Technopandas] | 242 | |
PPP | WOWHacker-BI0S | 197 | |
PPP | blue lotus | 178 | |
PPP | shell corp | 162 | |
PPP | clgt | 148 | |
PPP | Robot Mafia | 136 | |
PPP | Alternatives | 121 | |
PPP | 9447 | 120 | |
PPP | Samurai | 97 | |
PPP | The European Nopsled Team | 81 | |
PPP | shellphish | 80 | |
PPP | more smoked leet chicken | 71 | |
PPP | pwningyeti | 63 | |
PPP | raon_ASRT | 55 | |
PPP | sutegoma2 | 55 | |
PPP | routards | 46 | |
PPP | men in black hats | 25 | |
pwnies | APT8 | 75 | |
pwnies | Samurai | 57 | |
pwnies | 9447 | 51 | |
pwnies | Alternatives | 48 | |
pwnies | Robot Mafia | 44 | |
pwnies | blue lotus | 37 | |
pwnies | WOWHacker-BI0S | 34 | |
pwnies | shell corp | 33 | |
pwnies | clgt | 27 | |
pwnies | shellphish | 27 | |
pwnies | raon_ASRT | 22 | |
pwnies | [Technopandas] | 19 | |
pwnies | The European Nopsled Team | 18 | |
pwnies | more smoked leet chicken | 18 | |
pwnies | men in black hats | 11 | |
pwnies | pwningyeti | 6 | |
pwnies | routards | 6 | |
pwnies | PPP | 3 | |
pwningyeti | APT8 | 237 | |
pwningyeti | pwnies | 138 | |
pwningyeti | Samurai | 79 | |
pwningyeti | shell corp | 68 | |
pwningyeti | clgt | 51 | |
pwningyeti | Robot Mafia | 47 | |
pwningyeti | 9447 | 40 | |
pwningyeti | Alternatives | 35 | |
pwningyeti | blue lotus | 34 | |
pwningyeti | WOWHacker-BI0S | 32 | |
pwningyeti | shellphish | 23 | |
pwningyeti | raon_ASRT | 17 | |
pwningyeti | [Technopandas] | 11 | |
pwningyeti | The European Nopsled Team | 9 | |
pwningyeti | routards | 8 | |
pwningyeti | PPP | 8 | |
pwningyeti | more smoked leet chicken | 4 | |
raon_ASRT | APT8 | 352 | |
raon_ASRT | pwnies | 206 | |
raon_ASRT | shell corp | 130 | |
raon_ASRT | clgt | 124 | |
raon_ASRT | WOWHacker-BI0S | 115 | |
raon_ASRT | Samurai | 108 | |
raon_ASRT | Alternatives | 96 | |
raon_ASRT | [Technopandas] | 94 | |
raon_ASRT | blue lotus | 82 | |
raon_ASRT | Robot Mafia | 64 | |
raon_ASRT | PPP | 61 | |
raon_ASRT | shellphish | 58 | |
raon_ASRT | more smoked leet chicken | 54 | |
raon_ASRT | 9447 | 45 | |
raon_ASRT | routards | 44 | |
raon_ASRT | pwningyeti | 42 | |
raon_ASRT | The European Nopsled Team | 18 | |
raon_ASRT | men in black hats | 16 | |
raon_ASRT | sutegoma2 | 16 | |
Robot Mafia | APT8 | 68 | |
Robot Mafia | pwnies | 44 | |
Robot Mafia | WOWHacker-BI0S | 19 | |
Robot Mafia | clgt | 18 | |
Robot Mafia | Samurai | 10 | |
Robot Mafia | [Technopandas] | 6 | |
Robot Mafia | Alternatives | 3 | |
Robot Mafia | pwningyeti | 2 | |
Robot Mafia | shell corp | 1 | |
routards | APT8 | 301 | |
routards | pwnies | 191 | |
routards | clgt | 94 | |
routards | WOWHacker-BI0S | 85 | |
routards | Samurai | 78 | |
routards | [Technopandas] | 63 | |
routards | Robot Mafia | 52 | |
routards | shell corp | 28 | |
routards | Alternatives | 21 | |
routards | blue lotus | 12 | |
routards | 9447 | 12 | |
routards | raon_ASRT | 9 | |
routards | pwningyeti | 3 | |
routards | The European Nopsled Team | 1 | |
routards | more smoked leet chicken | 1 | |
Samurai | APT8 | 243 | |
Samurai | pwnies | 153 | |
Samurai | [Technopandas] | 83 | |
Samurai | WOWHacker-BI0S | 61 | |
Samurai | shell corp | 44 | |
Samurai | clgt | 43 | |
Samurai | blue lotus | 33 | |
Samurai | pwningyeti | 31 | |
Samurai | PPP | 24 | |
Samurai | Robot Mafia | 21 | |
Samurai | more smoked leet chicken | 16 | |
Samurai | Alternatives | 12 | |
Samurai | raon_ASRT | 9 | |
Samurai | 9447 | 5 | |
Samurai | men in black hats | 3 | |
Samurai | shellphish | 3 | |
Samurai | The European Nopsled Team | 1 | |
shell corp | APT8 | 196 | |
shell corp | pwnies | 136 | |
shell corp | Samurai | 68 | |
shell corp | clgt | 59 | |
shell corp | Robot Mafia | 52 | |
shell corp | WOWHacker-BI0S | 35 | |
shell corp | Alternatives | 32 | |
shell corp | 9447 | 26 | |
shell corp | raon_ASRT | 17 | |
shell corp | [Technopandas] | 16 | |
shell corp | pwningyeti | 15 | |
shell corp | blue lotus | 13 | |
shell corp | shellphish | 8 | |
shell corp | more smoked leet chicken | 6 | |
shell corp | routards | 4 | |
shell corp | men in black hats | 2 | |
shell corp | PPP | 2 | |
shell corp | The European Nopsled Team | 1 | |
shellphish | APT8 | 261 | |
shellphish | pwnies | 193 | |
shellphish | Samurai | 90 | |
shellphish | shell corp | 79 | |
shellphish | blue lotus | 71 | |
shellphish | clgt | 65 | |
shellphish | [Technopandas] | 63 | |
shellphish | WOWHacker-BI0S | 62 | |
shellphish | Robot Mafia | 59 | |
shellphish | Alternatives | 59 | |
shellphish | 9447 | 57 | |
shellphish | pwningyeti | 35 | |
shellphish | more smoked leet chicken | 29 | |
shellphish | raon_ASRT | 26 | |
shellphish | PPP | 22 | |
shellphish | The European Nopsled Team | 21 | |
shellphish | routards | 17 | |
shellphish | men in black hats | 13 | |
sutegoma2 | pwnies | 113 | |
sutegoma2 | APT8 | 92 | |
sutegoma2 | Samurai | 75 | |
sutegoma2 | 9447 | 53 | |
sutegoma2 | Alternatives | 47 | |
sutegoma2 | Robot Mafia | 42 | |
sutegoma2 | shell corp | 41 | |
sutegoma2 | shellphish | 39 | |
sutegoma2 | WOWHacker-BI0S | 34 | |
sutegoma2 | clgt | 27 | |
sutegoma2 | The European Nopsled Team | 20 | |
sutegoma2 | raon_ASRT | 20 | |
sutegoma2 | more smoked leet chicken | 18 | |
sutegoma2 | men in black hats | 14 | |
sutegoma2 | [Technopandas] | 13 | |
sutegoma2 | routards | 9 | |
sutegoma2 | pwningyeti | 4 | |
[Technopandas] | pwnies | 140 | |
[Technopandas] | APT8 | 130 | |
[Technopandas] | Samurai | 80 | |
[Technopandas] | shell corp | 55 | |
[Technopandas] | clgt | 32 | |
[Technopandas] | WOWHacker-BI0S | 30 | |
[Technopandas] | 9447 | 23 | |
[Technopandas] | Alternatives | 21 | |
[Technopandas] | raon_ASRT | 14 | |
[Technopandas] | blue lotus | 6 | |
[Technopandas] | shellphish | 5 | |
[Technopandas] | pwningyeti | 3 | |
[Technopandas] | The European Nopsled Team | 2 | |
The European Nopsled Team | APT8 | 150 | |
The European Nopsled Team | pwnies | 135 | |
The European Nopsled Team | Samurai | 89 | |
The European Nopsled Team | shell corp | 50 | |
The European Nopsled Team | WOWHacker-BI0S | 44 | |
The European Nopsled Team | Robot Mafia | 43 | |
The European Nopsled Team | clgt | 42 | |
The European Nopsled Team | Alternatives | 35 | |
The European Nopsled Team | 9447 | 30 | |
The European Nopsled Team | raon_ASRT | 21 | |
The European Nopsled Team | [Technopandas] | 21 | |
The European Nopsled Team | blue lotus | 15 | |
The European Nopsled Team | PPP | 13 | |
The European Nopsled Team | more smoked leet chicken | 11 | |
The European Nopsled Team | routards | 11 | |
The European Nopsled Team | pwningyeti | 10 | |
The European Nopsled Team | shellphish | 8 | |
The European Nopsled Team | men in black hats | 3 | |
WOWHacker-BI0S | APT8 | 131 | |
WOWHacker-BI0S | pwnies | 67 | |
WOWHacker-BI0S | Samurai | 53 | |
WOWHacker-BI0S | clgt | 44 | |
WOWHacker-BI0S | Robot Mafia | 37 | |
WOWHacker-BI0S | blue lotus | 21 | |
WOWHacker-BI0S | PPP | 20 | |
WOWHacker-BI0S | Alternatives | 17 | |
WOWHacker-BI0S | pwningyeti | 15 | |
WOWHacker-BI0S | raon_ASRT | 11 | |
WOWHacker-BI0S | shell corp | 8 | |
WOWHacker-BI0S | [Technopandas] | 8 | |
WOWHacker-BI0S | routards | 5 | |
WOWHacker-BI0S | more smoked leet chicken | 4 | |
WOWHacker-BI0S | shellphish | 1 | |
(318 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment