Did a bandaid patch for bug number 1144. The views were fixed earlier but the new pages in acs-subsite assumed that a user could only belong to one relseg at a time.
Another partial fix for #1144: join on rel_id, too, so when a user has two rows in cc_users he only shows up twice, not four times (cartesian product of all the relations)