Code:
mysql> select nick,rankpoints1,rankrank0 from temp_boinc_combined_user order by rankpoints1 desc limit 0,20;
+-----------------------+------------------+-----------+
| nick | rankpoints1 | rankrank0 |
+-----------------------+------------------+-----------+
| zombie67 | 779110.264264381 | 1 |
| zeitgeistmovie.com | 739505.166102081 | 2 |
| PoorBoy | 736562.711482215 | 3 |
| Nasicus | 734297.886879788 | 4 |
| [B^S] Ralfy | 709570.241425383 | 5 |
| KAMCOBILL | 698890.539487113 | 6 |
| vaughan | 693506.415913394 | 7 |
| Shann | 681965.846018752 | 8 |
| Ram Raider | 669054.48357307 | 9 |
| user312 | 666866.927957689 | 10 |
| [B^S] Morgan the Gold | 661070.186967151 | 11 |
| Bok | 660826.998077637 | 12 |
| Viking69 | 659650.27956312 | 13 |
| [SETI.USA]Tank_Master | 654519.709749795 | 14 |
| [B^S] Spydermb | 650183.261296516 | 15 |
| Grizz | 637378.306663701 | 16 |
| Eliot Meadow | 634981.054607436 | 17 |
| manu | 634102.367273942 | 18 |
| dduggan47 | 623448.526196029 | 19 |
| Sven Giese | 620794.744410701 | 20 |
+-----------------------+------------------+-----------+
20 rows in set (0.12 sec)
bonus points* for anyone who can see what this is