SELECT t.territoryid, t.name FROM tbl_TER_Territories t, tbl_TER_TerritoryLevels tL, tbl_TER_Territories t2 WHERE t.LevelID = tL.LevelID AND tL.BrokerLevel = 1 AND t.ParentTerritoryID = t2.TerritoryID AND t2.primarymanager = AND t.OwnerID = AND t.FSL_TableCode =