SELECT DISTINCT t2.TerritoryID FROM tbl_TER_Territories t, tbl_TER_TerritoryLevels tl, tbl_TER_Territories t2 WHERE t.OwnerID = AND t.FSL_TableCode = AND t.LevelID = tl.LevelID AND tl.BrokerLevel = 1 AND t.ParentTerritoryID = t2.TerritoryID AND t2.primarymanager = ;