query from ft to manager only