select
u.name as u_n,
c.name as c_n,
date

from
login t left outer join  user u 
on t.user_id=u.id
left outer join client c 
on t.client_id=c.id
where (user_id,date) in (select user_id,
                        max(date) 
                        from 
                        login
                        group by user_id)
order by u_n