SELECT TOP 10 *, dbo.LargerDateTime(DateAvailable, GETDATE()) AS DateAvailable, CASE WHEN MarketRentMin = 0 AND MarketRentMax = 0 AND EffectiveRentMax = 0 AND EffectiveRentMin = 0 THEN 1 ELSE 0 END AS CFP, (0 + 0 + 0 + (CASE WHEN MarketRentMin >= 1400 THEN 0 ELSE ABS(1400 - MarketRentMin) * .01 END) + (CASE WHEN MarketRentMax <= 3100 THEN 0 ELSE ABS(3100 - MarketRentMax) * .01 END) ) AS Ranking FROM View_Adkast_Units2 WHERE PropID IN (5508) AND Active = 1 ORDER BY Ranking