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;