SELECT turbine_user.last_name,
turbine_user.first_name,
turbine_user.login_name,
turbine_user.email,
max(eip_t_eventlog.event_date)
FROM turbine_user
LEFT JOIN eip_t_eventlog ON turbine_user.user_id = eip_t_eventlog.user_id
WHERE turbine_user.user_id > 3
AND turbine_user.disabled != 'T'
AND turbine_user.disabled = 'F'
AND eip_t_eventlog.event_type = 10
AND eip_t_eventlog.portlet_type = 1
GROUP BY turbine_user.user_id,
turbine_user.last_name,
turbine_user.first_name,
turbine_user.login_name,
turbine_user.email
ORDER BY turbine_user.email;