Stuff

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