SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 2)
   ExpressionList (children 2)
    Function countIf (children 1)
     ExpressionList (children 1)
      Function like (children 1)
       ExpressionList (children 2)
        Identifier explain
        Literal \'%Algorithm: DirectKeyValueJoin%\'
    Function countIf (children 1)
     ExpressionList (children 1)
      Function like (children 1)
       ExpressionList (children 2)
        Identifier explain
        Literal \'%Algorithm: HashJoin%\'
   TablesInSelectQuery (children 1)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      Subquery (children 1)
       SelectWithUnionQuery (children 1)
        ExpressionList (children 1)
         SelectQuery (children 2)
          ExpressionList (children 1)
           Asterisk
          TablesInSelectQuery (children 1)
           TablesInSelectQueryElement (children 1)
            TableExpression (children 1)
             Function viewExplain (children 1)
              ExpressionList (children 3)
               Literal \'EXPLAIN\'
               Literal \'actions = 1\'
               Subquery (children 1)
                SelectWithUnionQuery (children 1)
                 ExpressionList (children 1)
                  SelectQuery (children 3)
                   ExpressionList (children 1)
                    Asterisk
                   TablesInSelectQuery (children 2)
                    TablesInSelectQueryElement (children 1)
                     TableExpression (children 1)
                      Subquery (alias t2) (children 1)
                       SelectWithUnionQuery (children 1)
                        ExpressionList (children 1)
                         SelectQuery (children 2)
                          ExpressionList (children 1)
                           Identifier k (alias key)
                          TablesInSelectQuery (children 1)
                           TablesInSelectQueryElement (children 1)
                            TableExpression (children 1)
                             TableIdentifier t2
                    TablesInSelectQueryElement (children 2)
                     TableExpression (children 1)
                      TableIdentifier rdb
                     TableJoin (children 1)
                      Function equals (children 1)
                       ExpressionList (children 2)
                        Identifier rdb.key
                        Identifier t2.key
                   ExpressionList (children 1)
                    OrderByElement (children 1)
                     Identifier key
