A suggestion for a slightly silly but mysterious one

[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

[PDW]

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

Need to weight it against the number of other active team mates and possibly the amount of output they are doing.

[Bok]

Need to weight it against the number of other active team mates and possibly the amount of output they are doing.

Well, good point, but the cynic in me says that you could also create as many other id's you like and add them to the team and skew the team numbers like that.

Unsure, but it feels like this one could be gamed. Happy for you to counter the argument though

[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.

[Bok]

FWIW, doesn't seem to be much different when I do all of them

MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user where truncate(metric1,0) in (1000,10000,25000,50000,100000,250000,500000,750000,1000000,2500000,5000000,10000000,25000000,50000000,100000000,250000000,500000000,1000000000) group by cpid order by mycount desc limit 0,10;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    170374
Current database: static

+----------------------------------+-----------+---------+
| cpid                             | nick      | mycount |
+----------------------------------+-----------+---------+
| 0dd9749ec16c8900f065d871290156bc | BAR       |       7 |
| 2286c5351f0f2d2f5d7fee45967f22b8 | Baryna.ch |       5 |
| 8f15950e07e24a5c0c73016a77c952e9 | Nflight   |       4 |
| e33013c782482e80caf0c65b476a2d87 | JayPi     |       4 |
| 89e772f65716bba7c962b4a13d14e350 | AMDave    |       4 |
| 61c4eaaca6667bc9dda3412188c5f173 | x3mEn     |       3 |
| 476d777382a3555be83f6af9ab59c9f9 | Szopler   |       3 |
| 8496797f94775aac42635504add88c62 | $         |       3 |
| d7a3d9afaf379c6984d47f1d9672f5e2 | UL1       |       3 |
| 99fecfdc6caaa3ee9f7365297dd65634 | williami  |       3 |
+----------------------------------+-----------+---------+
10 rows in set (10.022 sec)

[MarkRBright]

I think I see, and that looks like a promising start - other than the "MySQL server has gone away" bit!
Combine it with SubProject breakpoints and Nebbers is go - assuming there's some tolerance in there somewhere - though I don't see it if it is. No I'm not looking for a free SQL lesson! ;-) Good work I think!

[MarkRBright]

The nice thing about this one is that I think everyone is as likely as anyone else to get one. OK so the more projects / SubProjects you have worked on increases the odds a fair bit, but someone could have worked on 5 projects and have one or two of these and quite probably wont know why! I always got the impression that you were quite keen on mysterious ones Bok.
I do think the 0.1% tolerance would make a difference if you haven't already got it in there. I would have thought that they will be far more commonplace with that tweak. Or would it be easier to just arbitrarily say plus or minus 500 say, or some such? I'm not bothered, but I suspect you will find more of them with percentages. Why not have a look at the data and pick what you think works best.

[Bok]

It would make it much more difficult to make it to have a range of values (tolerance) as in sql terms that would be individual between (9999 and 10001) for example

Though I certainly see the appeal of doing that.

MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user where (truncate(metric1,0) between 9999 and 10001) or (truncate(metric1,0) between 99999 and 100001) group by cpid order by mycount desc limit 0,10;
+----------------------------------+-------------+---------+
| cpid                             | nick        | mycount |
+----------------------------------+-------------+---------+
| 0dd9749ec16c8900f065d871290156bc | BAR         |       8 |
| 2286c5351f0f2d2f5d7fee45967f22b8 | Baryna.ch   |       7 |
| 61c4eaaca6667bc9dda3412188c5f173 | x3mEn       |       6 |
| e33013c782482e80caf0c65b476a2d87 | JayPi       |       5 |
| a848091602d6dade8ee661252d106d2d | rilian      |       4 |
| 89e772f65716bba7c962b4a13d14e350 | AMDave      |       4 |
| d5f358d1a7913ab61d7ea87c85aafbfd | Buster Gunn |       4 |
| 8f15950e07e24a5c0c73016a77c952e9 | Nflight     |       3 |
| 3a045e428e45f087f7cc832bdb4791ff | RAD-Poland  |       3 |
| 2e8203c09bffa7dd415284af2124eb53 | skivelitis  |       2 |
+----------------------------------+-------------+---------+
10 rows in set (9.725 sec)

but, saying that - it would only run once per day.