rendered paste bodymysql> 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)