SELECT turbine_user.user_id, turbine_user.login_name, turbine_user.email, turbine_user.first_name, turbine_user.last_name FROM turbine_user_group_role INNER JOIN turbine_user ON turbine_user_group_role.user_id=turbine_user.user_id WHERE turbine_user_group_role.role_id = 2 AND turbine_user_group_role.user_id > 3 and turbine_user.disabled <> 'T' GROUP BY turbine_user_group_role.user_id;
アカウントが有効なユーザーを調べる方法はこちら
select count(*) from turbine_user where user_id > 3 and disabled <> 'T';