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 |