Results 1 to 3 of 3

Thread: Coleslaws

  1. #1

    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
    Last edited by Coleslaw; 06-12-2019 at 10:46 PM. Reason: typo

  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,570
    Blog Entries
    13
    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 |

  3. #3
    Quote Originally Posted by Bok View Post
    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

Posting Permissions

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