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