The Million Stones per Day Club.

[Duke of Buckingham]

You make me blush with all the things you say of your mother.

Not so crazy Duke
just a bit

[Mike029]

Added Medictom and Dan to the list. Let's keep it growing. Who is next?

[DrPop]

I dunno who is next, but I am sorry to have missed the chance to give Joker a sound retort that he well deserves...alas he is now under the radar it would seem.

[dan]

Added Medictom and Dan to the list. Let's keep it growing. Who is next?

Hey I made the list twice. Time to celebrate!

[Mike029]

Hey I made the list twice. Time to celebrate!

Duh.

Heh heh, Got it right now. lol

[vaio]

Pup should qualify thru his Moo and PG participation.
But pup is a Renegade so pup no care

[Bok]

Why do you all MAKE me think of new stats !!!!

Did you know there were 181 MegaDay crunchers yesterday

And SETI.USA were 3rd when we group them.. 2nd if you discount the users not on a team..

mysql> select team0,count(*) from boinc_combined_user where days1 - days2 > 1000000 group by team0 order by count(*) desc limit 0,30;
+-------------------------+----------+
| team0                   | count(*) |
+-------------------------+----------+
| NULL                    |       16 |
| Sicituradastra.         |       14 |
| SETI.USA                |       13 |
| SETI.Germany            |        8 |
| L'Alliance Francophone  |        5 |
| Team Norway             |        4 |
| Team 2ch                |        4 |
| Team Musketeers         |        4 |
| AMD Users               |        3 |
| SwissTeam.NET           |        3 |
| Boinc@Taiwan            |        3 |
| Team China              |        3 |
| Planet 3DNow!           |        3 |
| The Knights Who Say Ni! |        3 |
| Czech National Team     |        3 |
| UK BOINC Team           |        3 |
| Polish National Team    |        2 |
| TitanesDC               |        2 |
| BOINC@MIXI              |        2 |
| XtremeSystems           |        2 |
| USA                     |        2 |
| PrimeSearchTeam         |        2 |
| U.S.Air Force           |        2 |
| GPU Force               |        2 |
| Overclock.net           |        2 |
| Dutch Power Cows        |        2 |
| Scotland                |        2 |
| Russia Team             |        2 |
| Ars Technica            |        2 |
| TeAm AnandTech          |        2 |
+-------------------------+----------+
30 rows in set (37.09 sec)

I feel a new page coming^TM

[Mike029]

Pup should qualify thru his Moo and PG participation.
But pup is a Renegade so pup no care

Ofcourse the pup counts. Sorry my friend I'm fixing it now.

[Mike029]

Why do you all MAKE me think of new stats !!!!

Did you know there were 181 MegaDay crunchers yesterday

And SETI.USA were 3rd when we group them.. 2nd if you discount the users not on a team..

mysql> select team0,count(*) from boinc_combined_user where days1 - days2 > 1000000 group by team0 order by count(*) desc limit 0,30;
+-------------------------+----------+
| team0                   | count(*) |
+-------------------------+----------+
| NULL                    |       16 |
| Sicituradastra.         |       14 |
| SETI.USA                |       13 |
| SETI.Germany            |        8 |
| L'Alliance Francophone  |        5 |
| Team Norway             |        4 |
| Team 2ch                |        4 |
| Team Musketeers         |        4 |
| AMD Users               |        3 |
| SwissTeam.NET           |        3 |
| Boinc@Taiwan            |        3 |
| Team China              |        3 |
| Planet 3DNow!           |        3 |
| The Knights Who Say Ni! |        3 |
| Czech National Team     |        3 |
| UK BOINC Team           |        3 |
| Polish National Team    |        2 |
| TitanesDC               |        2 |
| BOINC@MIXI              |        2 |
| XtremeSystems           |        2 |
| USA                     |        2 |
| PrimeSearchTeam         |        2 |
| U.S.Air Force           |        2 |
| GPU Force               |        2 |
| Overclock.net           |        2 |
| Dutch Power Cows        |        2 |
| Scotland                |        2 |
| Russia Team             |        2 |
| Ars Technica            |        2 |
| TeAm AnandTech          |        2 |
+-------------------------+----------+
30 rows in set (37.09 sec)

I feel a new page coming^TM

I'll add anyone who crunches a million a day for the team. WTG Bok!!! I wish I could get that list. Makes finding the guy that is crunching for us but on another team easier to find.

[Bok]

It's actually not totally accurate as there are some that are due to split CPID's. Chimichango for instance flip/flops every day and appears as a new user doing 60+ million.

Could possibly filter it based on row creation or something like that, I'd just have to add a new column to the table and populate it on creation (separate from the min(create_date) in the exported xml).