add some link fields to views to avoid unnecessary joins