refactor(server): filter assets by people using a subquery instead of a cte

refactor(server): filter assets by people using a subquery instead of a cte #29109