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

Disable noisy prints with the "//* enable to debug */ " comment pattern.