SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 5) ExpressionList (children 2) Identifier status Function count (alias all) (children 1) ExpressionList TablesInSelectQuery (children 2) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier test TablesInSelectQueryElement (children 1) ArrayJoin (children 1) ExpressionList (children 1) Identifier nested (alias nestedJoined) Function and (children 1) ExpressionList (children 2) Function in (children 1) ExpressionList (children 2) Identifier status Subquery (children 1) SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 5) ExpressionList (children 1) Identifier status TablesInSelectQuery (children 2) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier test TablesInSelectQueryElement (children 1) ArrayJoin (children 1) ExpressionList (children 1) Identifier nested (alias nestedJoined) ExpressionList (children 1) Identifier status ExpressionList (children 1) OrderByElement (children 1) Function count (children 1) ExpressionList Literal UInt64_10 Function in (children 1) ExpressionList (children 2) Identifier id Literal Tuple_(\'1\', \'2\') ExpressionList (children 1) Identifier status Literal UInt64_100