select distinct grouprole.GroupID, groups.GroupName  from grouprole, groups, persongrouprole, person  where grouprole.GroupID = groups.GroupID and  persongrouprole.GroupRoleId = grouprole.GroupRoleID and  persongrouprole.system_user_id = person.SystemUserID and person.SystemUserID =  and (persongrouprole.RoleEndDate is null || persongrouprole.RoleEndDate > now()) order by groups.groupname