Recent Commercial Sales

((WebAgencyID IN (647)) OR ((HeadWebAgencyID IS NOT NULL) AND ((HeadWebAgencyID) IN (647)))) AND ((StatusID & 70149) = 0) AND (((([TypeID] & 72) > 0) AND ([SoldDate] IS NOT NULL) AND (CONVERT(DATE, [SoldDate]) <= getdate()) AND (DATEADD(MONTH, [PastSalesPeriodInMonths], [SoldDate]) >= getdate())) OR ((([TypeID] & 16) > 0) AND ([DateLeased] IS NOT NULL) AND (CONVERT(DATE, [DateLeased]) <= getdate()) AND (DATEADD(MONTH, [PastSalesPeriodInMonths], [DateLeased]) >= getdate()))) AND ((([TypeID] & 72) > 0) OR (([TypeID] & 16) > 0)) AND ((TypeID & 8) > 0)