Miscellany

mysql> SELECT users.name, TO_DAYS(NOW())-TO_DAYS(minecraft_sessions.end) FROM minecraft_sessions LEFT JOIN users ON minecraft_sessions.uid = users.uid LEFT JOIN minecraft_sessions AS s2 ON minecraft_sessions.end < s2.end WHERE TO_DAYS(NOW())-TO_DAYS(minecraft_sessions.end) <= 10 GROUP BY users.uid;
+--------------------+------------------------------------------------+
| name               | TO_DAYS(NOW())-TO_DAYS(minecraft_sessions.end) |
+--------------------+------------------------------------------------+
|                    |                                             10 |
| sidein             |                                             10 |
| tdfischer          |                                             10 |
| TheInfamousBob     |                                             10 |
| Nybbles            |                                             10 |
| Chetawesomelaser   |                                              6 |
| Rossroth           |                                              0 |
| treath             |                                              1 |
| DragonBloodOD      |                                              9 |
| igot8001           |                                              1 |
| BetheyM10          |                                             10 |
| Susa               |                                             10 |
| mithbuster         |                                             10 |
| Snpbond            |                                             10 |
| kinoo              |                                             10 |
| Ajax               |                                              9 |
| sudodev            |                                              2 |
| originalnightninja |                                             10 |
| Fai Dan            |                                              8 |
| AWanderingMage     |                                              1 |
| jubbing            |                                              9 |
| sullenshade        |                                             10 |
| Redlegionnaire     |                                             10 |
| fuzzychan          |                                             10 |
| Corcast            |                                              9 |
| Dralan             |                                              9 |
| Arcadra            |                                              0 |
+--------------------+------------------------------------------------+
27 rows in set (10.87 sec)