Results 1 to 8 of 8

Thread: First team to 100K,500K, 1M & 10M rankings

  1. #1
    Advisor - Stateside Division
    Bok's Avatar
    Join Date
    October 14th, 2010
    Location
    Wake Forest, NC
    Posts
    1,211

    First team to 100K,500K, 1M & 10M rankings

    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)
    
    
    

  2. #2
    Past Administrator
    Fire$torm's Avatar
    Join Date
    October 13th, 2010
    Location
    In the Big City
    Posts
    7,938

    Re: First team to 100K,500K, 1M & 10M rankings

    Me likey!

    That may prove to be a good incentive for teams with a limited variety of project participation.


    Future Maker? Teensy 3.6

  3. #3
    Platinum Member
    Mumps's Avatar
    Join Date
    October 28th, 2010
    Location
    Milwaukee, WI
    Posts
    3,994

    Re: First team to 100K,500K, 1M & 10M rankings

    By all means! My plan is that I'll be adding a few of these in the next couple of days for the team.

  4. #4
    Platinum Member
    denim's Avatar
    Join Date
    November 1st, 2010
    Location
    Maryland, USA
    Posts
    2,896

    Re: First team to 100K,500K, 1M & 10M rankings

    We can call them Zombies?

  5. #5
    Past Admin
    Mike029's Avatar
    Join Date
    October 24th, 2010
    Location
    Bronx, New York
    Posts
    3,377

    Re: First team to 100K,500K, 1M & 10M rankings

    Awesome stat Bok. Could you add it to the "Combined Teams" front page? Sort of like you have the "your CPID page" That way when someone looks at the overall team stats it also shows the mega milestones. Otherwise I feel it will just be buried and no one will notice it.



  6. #6
    Platinum Member
    Crazybob's Avatar
    Join Date
    October 25th, 2010
    Location
    Preparing for the flakes!
    Posts
    2,529

    Re: First team to 100K,500K, 1M & 10M rankings

    Good idea, you da man!

    Joined Original Message Board: Fri Jan 27, 2006 1:47 pm, Currently with 11298 Posts

    If it ain't crunch'n, unplug it!

  7. #7
    Advisor - Stateside Division
    Bok's Avatar
    Join Date
    October 14th, 2010
    Location
    Wake Forest, NC
    Posts
    1,211

    Re: First team to 100K,500K, 1M & 10M rankings

    hmm, you mean put in a 'header type' part there. Maybe, I think it'll be a bit sparse unless I add a bit more to it. Thinking...

    Quote Originally Posted by Mike029 View Post
    Awesome stat Bok. Could you add it to the "Combined Teams" front page? Sort of like you have the "your CPID page" That way when someone looks at the overall team stats it also shows the mega milestones. Otherwise I feel it will just be buried and no one will notice it.

  8. #8
    Past Admin
    Mike029's Avatar
    Join Date
    October 24th, 2010
    Location
    Bronx, New York
    Posts
    3,377

    Re: First team to 100K,500K, 1M & 10M rankings

    Quote Originally Posted by Bok View Post
    hmm, you mean put in a 'header type' part there.
    Exactly. Add some buttons & bows, make it look pretty.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •