Generalize use of LEFT JOINs to account for missing facts

For example, CAs have no Institution in current selection: an extra
join across datasets is needed to retrieve this information.
Add information retrieved from CA profile in SELECT for facts