select u.name
,c.name
,max(l.date)
from login l
left join user u
on l.user_id =u.id
left join client c
on l.client_id=c.id
group by l.user_id
order by u.name asc