SELECT C1.ID AS ContractID, E.Estimate, C1.CodePostav, C1.Firm + ' '+ L.LawForm AS NAME, C.Comment AS Ball, e.RusName, C.[Status], C.Author
  FROM _EstimateHeads E
  INNER JOIN _ApplicHeads A ON A.EstimateID = E.Estimate
  LEFT JOIN ContractFullBall C ON E.Estimate = C.Estimate AND C.ContractID = A.Acceptor
  INNER JOIN ContractFull C1 ON A.Acceptor = C1.ID
  INNER JOIN ContractFullLawForm L ON L.LawID = C1.lawForm
  WHERE A.IsCash = 1 AND  E.Estimate = @ID AND C.FieldID = 6