Coleslaws

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.ph...7c6ef05d8eddb2

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

Code:

---

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 |

---

Quote:

---

Originally Posted by 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

Code:

---

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