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

Please fix the spelling of Receive