Thinking about putting a page up for this..
Code:
Teams with the most 1st places to 100K
mysql> select team,count(*) from boinc_project_timeline where tline = 't100000' group by team order by count(*) desc limit 0,10;
+------------------------+----------+
| team | count(*) |
+------------------------+----------+
| SETI.USA | 34 |
| SETI.Germany | 9 |
| BOINC Synergy | 7 |
| Czech National Team | 5 |
| Sicituradastra. | 5 |
| BOINC@Poland | 5 |
| L'Alliance Francophone | 4 |
| AMD Users | 4 |
| BOINCstats | 4 |
| PBToyz | 4 |
+------------------------+----------+
10 rows in set (0.00 sec)
Teams with the most 1st places to 500K
mysql> select team,count(*) from boinc_project_timeline where tline = 't500000' group by team order by count(*) desc limit 0,10;
+------------------------+----------+
| team | count(*) |
+------------------------+----------+
| SETI.USA | 23 |
| SETI.Germany | 11 |
| BOINC Synergy | 5 |
| Free-DC | 5 |
| Team Norway | 3 |
| L'Alliance Francophone | 3 |
| Czech National Team | 3 |
| Planet 3DNow! | 3 |
| CANAL@Boinc | 2 |
| Picard | 2 |
+------------------------+----------+
10 rows in set (0.00 sec)
Teams with the most 1st places to 1M
mysql> select team,count(*) from boinc_project_timeline where tline = 't1000000' group by team order by count(*) desc limit 0,10;
+---------------------------+----------+
| team | count(*) |
+---------------------------+----------+
| SETI.USA | 15 |
| SETI.Germany | 12 |
| L'Alliance Francophone | 8 |
| BOINC@Poland | 5 |
| CANAL@Boinc | 4 |
| BOINC Synergy | 4 |
| USA | 4 |
| Free-DC | 4 |
| Ukraine | 2 |
| Team Starfire World BOINC | 2 |
+---------------------------+----------+
10 rows in set (0.00 sec)
Teams with the most 1st places to 10M
mysql> select team,count(*) from boinc_project_timeline where tline = 't10000000' group by team order by count(*) desc limit 0,10;
+--------------------------------+----------+
| team | count(*) |
+--------------------------------+----------+
| SETI.USA | 8 |
| L'Alliance Francophone | 5 |
| Ars Technica | 4 |
| SETI.Germany | 3 |
| BOINC@AUSTRALIA | 2 |
| Electronic Sports League (ESL) | 2 |
| UH IT HPC | 2 |
| Sicituradastra. | 2 |
| Canada | 2 |
| BOINC@Poland | 2 |
+--------------------------------+----------+
10 rows in set (0.01 sec)