select u.name, c.name, date from user u,client c,login l
where l.user_id = u.id and l.client_id = c.id
	and (user_id, date) in (select user_id, max(date)  from login 
		group by user_id)