Move over the bandaid patch for bug #1144 from the 5.0 branch. This needsto be fixed for real (including datamodel changes with upgrade scripts) in5.1.
Did a bandaid patch for bug number 1144. The views were fixed earlier butthe new pages in acs-subsite assumed that a user could only belong to onerelseg 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)