Doug,
Great idea. I don't think joining on acs_magic_objects is a problem in this case. The cc_users view is part of the core, so we don't really need that level of abstraction. Indeed, we can't afford it if the query speeds up that much.
I think this should go back into the toolkit.
