Add missing where clause to temp table cte

Add missing where clause to temp table cte #9494