It's correct though.. (not got your raksearch one up to date yet)
Code:
MariaDB [dcfree]> select a.cpid,a.nick,count(*) as c1 from boinc_user a where a.metric1 > 24999999 group by a.cpid having count(*) > 20 order by c1 desc;+----------------------------------+---------------+----+
| cpid | nick | c1 |
+----------------------------------+---------------+----+
| 16a4a513fbbb77b756173c6d1cf16b44 | Mumps [MM] | 48 |
| c36ec714d8ce4609f9d8f6371fd8151e | Bryan | 29 |
| 1cbc21d2518924bbe3e94014c2f6b3b0 | vanos0512 | 26 |
| ac5790e143f98262a0eaffffd5df9932 | [SG-FC] hl | 25 |
| 0a7b8378436fdcaef549d87e35f26480 | zombie67 [MM] | 24 |
| 163f049997e8a2dee054d69a7720bf05 | grcpool.com-3 | 24 |
| 7d0d73fe026d66fd4ab8d5d8da32a611 | grcpool.com | 23 |
| a914eba952be5dfcf73d926b508fd5fa | grcpool.com-2 | 23 |
| 2a6ff29b76493b1ceed6dc9b5e561af2 | whizbang | 23 |
| 13a87c3a303bcdca4ba0ed600daebb6b | STE\/E | 21 |
| 92cbc200b2b2232e70f41d35403bee80 | PDW | 21 |
| 5e5e0b903b32cb3581e69a5e5cd3d30e | stoneageman | 21 |
+----------------------------------+---------------+----+
12 rows in set (32.86 sec)