select b.name as u_n, c.name as c_n, a.date from login a join user b on a.user_id = b.id join client c on a.client_id = c.id
where
(a.user_id, a.date) in (select user_id, max(date) from login group by user_id)
order by u_n