A suggestion for a slightly silly but mysterious one

[MarkRBright]

OK then I'll leave it in your capable hands.

[MarkRBright]

Gah! I mad another mistake in it with putting zeros and 9's in the wrong places, it should be

MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user
where
metric1 between 995 and 1005
or metric1 between 9950 and 10050
or metric1 between 24875 and 25125
or metric1 between 49750 and 50250
or metric1 between 99500 and 100500

or metric1 between 248750 and 251250
or metric1 between 497500 and 502500
or metric1 between 746250 and 753750
or metric1 between 995000 and 1005000

or metric1 between 2487500 and 2512500
or metric1 between 4975000 and 5025000
or metric1 between 9950000 and 10050000

or metric1 between 24875000 and 25125000
or metric1 between 49950000 and 50050000
or metric1 between 99500000 and 100500000

or metric1 between 248750000 and 251250000
or metric1 between 499500000 and 500500000
or metric1 between 995000000 and 1005000000

or metric1 between 2487500000 and 2512500000
or metric1 between 4995000000 and 5005000000
or metric1 between 9950000000 and 10050000000

or metric1 between 24875000000 and 25125000000
or metric1 between 49950000000 and 50050000000
or metric1 between 99500000000 and 100500000000

group by cpid order by mycount desc limit 0,25;

This highlights the benefits of being able to parameterise it and work it out automatically at run time! I have no idea if SQL allows this but it would be good if it did. Anyway - sorry for messing you about, I am fairly sure it is right now.

[MarkRBright]

Double ARGGGH! So I was just sorting out a test for this in a spreadsheet, and I was horrified to see that there were still some differences once I had built some formulas - which I think just goes to show how tricky it will be for people to work out why the have suddenly gotten whatever number of Nebbers they get :-) Anyway according to my spreadsheet your SQL statement should be as follows :

select cpid,nick,count(*) as mycount from boinc_user
where
metric1 between 995 and 1005
or metric1 between 9950 and 10050
or metric1 between 24875 and 25125
or metric1 between 49750 and 50250
or metric1 between 99500 and 100500

or metric1 between 248750 and 251250
or metric1 between 497500 and 502500
or metric1 between 746250 and 753750
or metric1 between 995000 and 1005000

or metric1 between 2487500 and 2512500
or metric1 between 4975000 and 5025000
or metric1 between 9950000 and 10050000

or metric1 between 24875000 and 25125000
or metric1 between 49750000 and 50250000
or metric1 between 99500000 and 100500000

or metric1 between 248750000 and 251250000
or metric1 between 497500000 and 502500000
or metric1 between 995000000 and 1005000000

or metric1 between 2487500000 and 2512500000
or metric1 between 4975000000 and 5025000000
or metric1 between 9950000000 and 10050000000

or metric1 between 24875000000 and 25125000000
or metric1 between 49750000000 and 50250000000
or metric1 between 99500000000 and 100500000000

or metric1 between 248750000000 and 251250000000
or metric1 between 497500000000 and 502500000000
or metric1 between 995000000000 and 1005000000000

group by cpid order by mycount desc limit 0,25;

I also chucked another band on the end as there are probably some people out there with trillions.
OK I will shut up for a bit now, and stop making blattantly obviuos mustakes (hopfully)

[MarkRBright]

So I was testing this Nebbers idea out yesterday and I calculated on my spreadsheet how many I would get as a test, and for a laugh I added a line to the bottom of the MMs data that I import to see it's effect on my various other tables/graphs.
Well... we are just moving to the highest Tier of Covid Restrictions here this weekend so I might as well get used to filling my time!
Anyway, having been pushed into guessing my rank for Nebbers I thought that it might be amusing - if only for me - to publish my predictions just so I have something to really look forward to in Lockdown - Namely "Just how wrong could I be?"
So with that, here are the predictions from my panel of experts ;-)

MM Type Nebbers
Many 53
RankP 300
RankT 3
RankC 14
#Maxwell 80
#TeraMiRB 49
#MiRB 12

Ooh! I just can't wait!

[MarkRBright]

BTW Bok , if you do ever find the time to do this one (and I'm not nagging you here), could you please put it above SubClanks and Clanks on the MMs table, as it is probably slightly less volatile than those two.

[Bok]

Going to try an implement this tomorrow. My wife and daughter are away for hockey this weekend, so I get some time

[MarkRBright]

I'll keep my eyes peeled