select u.name u_n,c.name c_n,a.datefrom login aright join (select user_id,max(date) date from logingroup by user_id)b on( a.user_id = b.user_id and a.date = b.date)left join user u on a.user_id=u.idleft join client c on(a.client_id = c.id)order by u.name