SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 4)
   ExpressionList (children 2)
    Identifier id
    Identifier flag
   TablesInSelectQuery (children 2)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      TableIdentifier test (alias t1)
    TablesInSelectQueryElement (children 2)
     TableExpression (children 1)
      Subquery (alias t2) (children 1)
       SelectWithUnionQuery (children 1)
        ExpressionList (children 1)
         SelectQuery (children 2)
          ExpressionList (children 1)
           Identifier id
          TablesInSelectQuery (children 1)
           TablesInSelectQueryElement (children 1)
            TableExpression (children 1)
             TableIdentifier test
     TableJoin (children 1)
      Function equals (children 1)
       ExpressionList (children 2)
        Identifier t1.id
        Identifier t2.id
   Function and (children 1)
    ExpressionList (children 3)
     Function equals (children 1)
      ExpressionList (children 2)
       Identifier flag
       Literal UInt64_0
     Function equals (children 1)
      ExpressionList (children 2)
       Identifier t
       Literal UInt64_1
     Function notIn (children 1)
      ExpressionList (children 2)
       Identifier id
       Subquery (children 1)
        SelectWithUnionQuery (children 1)
         ExpressionList (children 1)
          SelectQuery (children 2)
           ExpressionList (children 1)
            Literal UInt64_1
           Literal UInt64_0
   ExpressionList (children 1)
    OrderByElement (children 1)
     Identifier id
