Add guards for unsupported subqueries join plan, optimize the possible subqueriese

Where did we eliminate the case of 0 receive nodes? I think that can happen. At least in a single-partition stored proc.