update groupsvc to reflect newest sql