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;

関連記事