Coleslaws

[Coleslaw]

Coleslaws would be the number of 1st places you hold on your team for each of the mega milestones. Since I'm currently ranked 1st in 31 of the categories, I would have 31Coleslaws. this of course would exclude itself.

https://stats.free-dc.org/mosttag.php?cpid=1bb993deb5284d5f357c6ef05d8eddb2

[Bok]

It's certainly possible to do this, only problem is that for anything team related it's easily cheated by creating your own team and excluding any others...

btw, you don't crack the top50



MariaDB [static]> select cpid,count(*) as mycount from boinc_milestone_makers where teamrank = 1 group by cpid having mycount > 10 order by mycount desc limit 0,50;
+----------------------------------+---------+
| cpid | mycount |
+----------------------------------+---------+
| 92cbc200b2b2232e70f41d35403bee80 | 53 |
| 3f13def575553fa8d10ef548fb464b03 | 51 |
| 398ddf3dd9e43a7d38c8fd66bdd3534c | 47 |
| 13a87c3a303bcdca4ba0ed600daebb6b | 46 |
| 2f998e84d53b4ef813b308bf9fbb3ec8 | 44 |
| bed64602e97395a4f2127a3d5382bba4 | 44 |
| d03306bb308b1c15b0fd20ce7e63eae3 | 44 |
| 7fb79bebee83fc92e77a1386d0bfce9b | 43 |
| afe566e135be9874ed1e9db32be5e6bd | 43 |
| ee4a19259edf11e9e90005773cb8ad16 | 43 |
| 76608db02c18eb701287bda8924b2437 | 43 |
| 48fee03e8abb4fa84b21473cc9d5e733 | 43 |
| f0e530e5dcb634c0280df714a56d4065 | 42 |
| 6ceba8d274a1c972e44eb9d1f6854a42 | 42 |
| 698708b6fcbe95503cb56cb97934ff98 | 42 |
| ccd132458da90a454e2065e34b1d7cfa | 42 |
| 4c8db15e0f572591dcd862d658a8b5f6 | 41 |
| da0c795e81490ce47752d88cb0cbd5be | 41 |
| 8c5ac710e9e79ffee7b958abe155da25 | 41 |
| 68193ff085b019ffc693e5914502b0f6 | 41 |
| e6d7c085548c74d8fabd85c703a0491e | 41 |
| ae3b2189869c5f1b9040fddc884379f0 | 40 |
| a80d9d05984851dc024d96d0bfb63d53 | 40 |
| 6cc6bbbc5d4798914c700b2c6924ecd8 | 40 |
| 133035a08f68b6219272c5282a9f4a21 | 40 |
| 1cbc21d2518924bbe3e94014c2f6b3b0 | 40 |
| 1af584e3ffa95fd941d2d232fab98611 | 40 |
| 93cde4451c1fb02297f3eb3ba64b630c | 40 |
| 1537b4e119146bddd3c1b182fc6e2952 | 40 |
| 8ca20c5d45e9d2dc1bb0a819f4433d72 | 40 |
| ad705da0df11ef8f112e2b000f788dc6 | 40 |
| 6d8374653616d8a19c591acb7c2b2e0e | 40 |

[Coleslaw]

It's certainly possible to do this, only problem is that for anything team related it's easily cheated by creating your own team and excluding any others...

btw, you don't crack the top50



MariaDB [static]> select cpid,count(*) as mycount from boinc_milestone_makers where teamrank = 1 group by cpid having mycount > 10 order by mycount desc limit 0,50;
+----------------------------------+---------+
| cpid | mycount |
+----------------------------------+---------+
| 92cbc200b2b2232e70f41d35403bee80 | 53 |
| 3f13def575553fa8d10ef548fb464b03 | 51 |
| 398ddf3dd9e43a7d38c8fd66bdd3534c | 47 |
| 13a87c3a303bcdca4ba0ed600daebb6b | 46 |
| 2f998e84d53b4ef813b308bf9fbb3ec8 | 44 |
| bed64602e97395a4f2127a3d5382bba4 | 44 |
| d03306bb308b1c15b0fd20ce7e63eae3 | 44 |
| 7fb79bebee83fc92e77a1386d0bfce9b | 43 |
| afe566e135be9874ed1e9db32be5e6bd | 43 |
| ee4a19259edf11e9e90005773cb8ad16 | 43 |
| 76608db02c18eb701287bda8924b2437 | 43 |
| 48fee03e8abb4fa84b21473cc9d5e733 | 43 |
| f0e530e5dcb634c0280df714a56d4065 | 42 |
| 6ceba8d274a1c972e44eb9d1f6854a42 | 42 |
| 698708b6fcbe95503cb56cb97934ff98 | 42 |
| ccd132458da90a454e2065e34b1d7cfa | 42 |
| 4c8db15e0f572591dcd862d658a8b5f6 | 41 |
| da0c795e81490ce47752d88cb0cbd5be | 41 |
| 8c5ac710e9e79ffee7b958abe155da25 | 41 |
| 68193ff085b019ffc693e5914502b0f6 | 41 |
| e6d7c085548c74d8fabd85c703a0491e | 41 |
| ae3b2189869c5f1b9040fddc884379f0 | 40 |
| a80d9d05984851dc024d96d0bfb63d53 | 40 |
| 6cc6bbbc5d4798914c700b2c6924ecd8 | 40 |
| 133035a08f68b6219272c5282a9f4a21 | 40 |
| 1cbc21d2518924bbe3e94014c2f6b3b0 | 40 |
| 1af584e3ffa95fd941d2d232fab98611 | 40 |
| 93cde4451c1fb02297f3eb3ba64b630c | 40 |
| 1537b4e119146bddd3c1b182fc6e2952 | 40 |
| 8ca20c5d45e9d2dc1bb0a819f4433d72 | 40 |
| ad705da0df11ef8f112e2b000f788dc6 | 40 |
| 6d8374653616d8a19c591acb7c2b2e0e | 40 |


I guess I better get busy then...lol