Fixed Subquery Name in Queries with ARRAY JOIN and GLOBAL IN Subquery with Alias
Official CH changelog text
Fixed subquery name in queries with ARRAY JOIN and GLOBAL IN subquery with alias. Use subquery alias for external table name if it is specified. #6934 (Ivan)