页面历史

select t_user.c_userid from t_user
LEFT JOIN t_group_user on t_user.c_userid = t_group_user.c_userid
LEFT JOIN t_group on t_group_user.c_groupid = t_group.c_groupid
LEFT JOIN t_user_role on t_user_role.c_userid = t_user.c_userid
where (t_group.c_groupid in ( select t_group.c_pgroupid from t_group where t_group.c_groupname in (CurrentUserDefaultDepartmentAliasCurrentUserDefaultDepartmentName())) or  t_group.c_groupname in (CurrentUserDefaultDepartmentAliasCurrentUserDefaultDepartmentName()) )
and t_user_role.c_roleid = 'I402880ba016656bc56bccc6601667260f5344ef8'