figure21

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)