mysql> SELECT * FROM (SELECT users.name, TO_DAYS(NOW())-TO_DAYS(minecraft_sessions.end) AS lastSeen FROM minecraft_sessions LEFT JOIN users ON minecraft_sessions.uid = users.uid WHERE TO_DAYS(NOW())-TO_DAYS(minecraft_sessions.end) <= 100 ORDER BY minecraft_sessions.end DESC) AS tmp GROUP BY name ORDER BY lastSeen;
+--------------------+----------+
| name               | lastSeen |
+--------------------+----------+
|                    |        0 |
| sidein             |        0 |
| treath             |        0 |
| BetheyM10          |        0 |
| tdfischer          |        0 |
| TheInfamousBob     |        0 |
| Susa               |        0 |
| igot8001           |        0 |
| Rossroth           |        0 |
| Arcadra            |        0 |
| originalnightninja |        0 |
| kinoo              |        0 |
| Nybbles            |        0 |
| AWanderingMage     |        1 |
| mithbuster         |        1 |
| fuzzychan          |        1 |
| Dralan             |        1 |
| Chetawesomelaser   |        1 |
| sudodev            |        2 |
| Ajax               |        3 |
| DragonBloodOD      |        3 |
| Redlegionnaire     |        4 |
| Snpbond            |        5 |
| Fai Dan            |        5 |
| sullenshade        |        6 |
| Corcast            |        9 |
| jubbing            |        9 |
| HereticSoul        |       11 |
| StompyCH           |       12 |
| CrystalBlue        |       14 |
| Tanilu             |       16 |
| Ryannewbe          |       20 |
| codeblock          |       20 |
| phuzion            |       24 |
| Osek               |       27 |
| gurbara            |       29 |
| ShadeFawks         |       32 |
| Mithoja            |       35 |
| DarkQueen          |       36 |
| jagler04           |       42 |
| kenny85246         |       44 |
| -K-                |       51 |
| SladeDoobiedog     |       54 |
| ajanata            |       55 |
| Styrofoam12        |       63 |
| beallis            |       63 |
| thickfreakness     |       68 |
| Reaver             |       77 |
| ChickenSalad       |       81 |
| tm258              |       87 |
| MightyThor         |       89 |
| root               |       91 |
+--------------------+----------+
52 rows in set (0.05 sec)