adding #outer_join to select manager too