select u.name as u_n,c.name as c_n ,date d
 from login l 
 left join user u 
 on l.user_id=u.id 
 left join client c 
 on l.client_id= c.id 
WHERE
exists (select * from (
    select user_id ,max(date) d 
    from login 
    group by user_id)t1 
        where t1.user_id=l.user_id 
        and l.date=t1.d)
order by u_n