partially migrated old member fix root view joins