SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 3)
   ExpressionList (children 4)
    Identifier segmented_ctr_cache.product_id
    Identifier segmented_ctr_cache.segment_id
    Identifier count_in_bookmark
    Identifier count_in_cart
   TablesInSelectQuery (children 3)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      TableIdentifier segmented_ctr_cache
    TablesInSelectQueryElement (children 2)
     TableExpression (children 1)
      TableIdentifier cart_join
     TableJoin (children 1)
      Function and (children 1)
       ExpressionList (children 2)
        Function equals (children 1)
         ExpressionList (children 2)
          Identifier cart_join.product_id
          Identifier segmented_ctr_cache.product_id
        Function equals (children 1)
         ExpressionList (children 2)
          Identifier cart_join.segment_id
          Identifier segmented_ctr_cache.segment_id
    TablesInSelectQueryElement (children 2)
     TableExpression (children 1)
      TableIdentifier bookmarks_join
     TableJoin (children 1)
      Function and (children 1)
       ExpressionList (children 2)
        Function equals (children 1)
         ExpressionList (children 2)
          Identifier bookmarks_join.product_id
          Identifier segmented_ctr_cache.product_id
        Function equals (children 1)
         ExpressionList (children 2)
          Identifier bookmarks_join.segment_id
          Identifier segmented_ctr_cache.segment_id
   ExpressionList (children 1)
    OrderByElement (children 1)
     Identifier ALL
