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)
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)