Quote Originally Posted by Bok View Post
This might work ?

Code:
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