SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 4)
   ExpressionList (children 2)
    Identifier loyalty
    Function count (children 1)
     ExpressionList
   TablesInSelectQuery (children 2)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      TableIdentifier test.hits
    TablesInSelectQueryElement (children 2)
     TableExpression (children 1)
      TableIdentifier join
     TableJoin (children 1)
      ExpressionList (children 1)
       Identifier UserID
   ExpressionList (children 1)
    Identifier loyalty
   ExpressionList (children 1)
    OrderByElement (children 1)
     Identifier loyalty
