select u.name as u_n,	c.name as  c_n,	t.date
from login l
    join user u on l.user_id=u.id
    join client c on l.client_id=c.id
    join (
        select user_id,max(date) as date
        from login
        group by user_id
    ) as t on l.user_id=t.user_id and l.date=t.date
order by u_n