SELECT c.*
FROM Contract c (nolock)
  JOIN ContractProduct cp (nolock) ON c.ContractId = cp.ContractId 
  JOIN Customer cu (nolock) ON c.CustomerId_Owner = cu.CustomerID  
WHERE 1 = 1
  AND cp.ProductId = 11090
  AND cu.CompanyID_Vendor = 1
  AND cp.ActivationDate IS NOT NULL
  AND cp.DeactivationDate IS NULL