SELECT u.ID AS ID, u.nick, datenschutz , u.name AS name, u.vname AS vname, u.seen AS seen, (TO_DAYS(NOW())-TO_DAYS(seen)) AS abwesenheit, u.anzgames, u.wongames, u.losegames, (u.anzgames - u.wongames - u.losegames) AS remisgames, (((u.wongames + (u.anzgames - u.wongames - u.losegames)/2)*100)/u.anzgames) AS percent, u.elo, u.anzelorated, u.rstitel, IF(u.rstitelgueltigbis>NOW(), 1, 0) AS nochgueltig, u.titel, SUM(uo.type) AS type, uo.ID_channels AS channel, c.kname AS channelname FROM user AS u INNER JOIN useronline AS uo ON uo.ID_user = u.ID LEFT JOIN channels AS c ON uo.ID_channels = c.ID WHERE u.ID<>1 GROUP BY uo.ID_user ORDER BY seen DESC

---