figure23

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 and r.team_id != i.team_id
                      group by t.name
                      order by total desc;
           team            | total
---------------------------+-------
 blue lotus                |  3665
 Alternatives              |  3095
 9447                      |  2751
 more smoked leet chicken  |  2650
 shellphish                |  2617
 APT8                      |  2482
 pwnies                    |  2091
 pwningyeti                |  1948
 The European Nopsled Team |  1895
 Samurai                   |  1841
 [Technopandas]            |  1837
 WOWHacker-BI0S            |  1794
 raon_ASRT                 |  1723
 clgt                      |  1463
 Robot Mafia               |  1456
 routards                  |  1402
 sutegoma2                 |  1336
 PPP                       |  1309
 shell corp                |  1034
 men in black hats         |   876
(20 rows)