SELECT SUM(Counted) AS TotalRowCount FROM( SELECT COUNT(ML_Number) AS Counted FROM OpenHouse WITH (NOLOCK) WHERE (MLSID = :SQL_PARAM_1) AND (