A suggestion for a slightly silly but mysterious one

[MarkRBright]

Just thought I'd post something to this again so that it stays alive. I still like this idea.

[MarkRBright]

Still liking this one!

[Dirk Broer]

Still liking this one!

Let's call it the SmartyPants then, SuperDuperBok is slightly over the top IMHO, and it gives the opportunity to switch pants -with the SquarePants....
It is even related:

[Bok]

So this would need to check

for each project
(have I got exactly 10k or 25K or 50K or 100K or 500K or 1M etc


Whilst doable, that's a lot of calculations. But i will try and see

[Bok]

This might work ?

MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user where truncate(metric1,0) in (10000,100000,500000,1000000) group by cpid order by mycount desc limit 0,10;
+----------------------------------+------------+---------+
| cpid                             | nick       | mycount |
+----------------------------------+------------+---------+
| 0dd9749ec16c8900f065d871290156bc | BAR        |       7 |
| 2286c5351f0f2d2f5d7fee45967f22b8 | Baryna.ch  |       5 |
| e33013c782482e80caf0c65b476a2d87 | JayPi      |       4 |
| 89e772f65716bba7c962b4a13d14e350 | AMDave     |       4 |
| d7a3d9afaf379c6984d47f1d9672f5e2 | UL1        |       3 |
| 8f15950e07e24a5c0c73016a77c952e9 | Nflight    |       3 |
| 61c4eaaca6667bc9dda3412188c5f173 | x3mEn      |       3 |
| 16b5360510c4a408ca02d2ff07ab4a9e | RAD-Poland |       2 |
| 8496797f94775aac42635504add88c62 | $          |       2 |
| 2e8203c09bffa7dd415284af2124eb53 | skivelitis |       2 |
+----------------------------------+------------+---------+
10 rows in set (8.956 sec)

[PDW]

Not so keen on this one, Coleslaw's https://www.free-dc.org/showthread.php?57942-Coleslaws however is a winner

[Bok]

Not so keen on this one, Coleslaw's https://www.free-dc.org/showthread.php?57942-Coleslaws however is a winner

Not so sure for the reasons I have on that post. I could just create a new team, move all my accounts to it and not allow new users. I'd be #1 in any active project available

[MarkRBright]

This might work ?

MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user where truncate(metric1,0) in (10000,100000,500000,1000000) group by cpid order by mycount desc limit 0,10;
+----------------------------------+------------+---------+
| cpid                             | nick       | mycount |
+----------------------------------+------------+---------+
| 0dd9749ec16c8900f065d871290156bc | BAR        |       7 |
+----------------------------------+------------+---------+
10 rows in set (8.956 sec)

Sorry to interrupt, but can we please stay on track here, this is about Nebbers!
Excuse my lack of SQL but is this just a trial? I was thinking more ALL of the credit-value based MMs so 1000 10000, 25000 etc and for both Projects and SubProjects and with a tolerance of somewhere about 0.1% either way. It may seem like a lot to do but I feel there will not be many of them so perhaps it won't take too long, though if it does, then by all means drop the idea. Cheers

[Bok]

This was just to show how it could be done.