with t1 as
(select 
    u.name as u_n,
    c.name as c_n,
    l.date,
    l.user_id
from
    login l 
left join client c on l.client_id=c.id
left join user u on l.user_id=u.id)

select 
t2.u_n,t1.c_n,t2.date
from
(select
    u_n,
    max(date) as date
from
    t1
group by
    u_n)t2
left join 
    t1 
on 
    t2.u_n=t1.u_n and t2.date=t1.date
order by
    t1.u_n asc