SELECT u.name AS u_n, c.name AS c_n, MAX(date) AS date
FROM login AS l, user AS u, client AS c 
WHERE l.user_id = u.id
AND l.client_id = c.id
GROUP BY u.name
ORDER BY u.name