Correct Interpretation of Complex Queries with GLOBAL IN and UNION ALL

Correct interpretation of certain complex queries with GLOBAL IN and UNION ALL