sql script

select u.name as u_n, c.name as c_n, tmp.date as date
from login l, user u, client c, (select max(date) as date, user_id
                                from login
                                group by user_id) tmp
where l.user_id=tmp.user_id
and l.date=tmp.date
and l.user_id=u.id
and l.client_id=c.id
order by u.name