Online Users

From SharedTree Wiki

select FROM_UNIXTIME(ses_time), round((ses_time - ses_start)/60) as online_minutes, 
user_id, person_id, given_name, family_name, email, visits, creation_date, host_addr
from app_session s
join app_user u using (user_id)
order by s.ses_time DESC