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