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