- _phase: enter
  _type: SelectStmt
  distinct: false
- _phase: enter
  _type: FieldList
- _phase: enter
  _type: SelectField
  as_name: stock_count
  offset: 7
- _phase: enter
  _type: FuncCallExpr
  fn_name: count
  schema: ""
- _phase: enter
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnName
  name: s_i_id
  schema: ""
  table: ""
- _phase: leave
  _type: ColumnName
- _phase: leave
  _type: ColumnNameExpr
- _phase: leave
  _type: FuncCallExpr
- _phase: leave
  _type: SelectField
- _phase: leave
  _type: FieldList
- _phase: enter
  _type: TableRefsClause
- _phase: enter
  _type: Join
  using: []
- _phase: enter
  _type: Join
  using: []
- _phase: enter
  _type: TableSource
  as_name: ""
- _phase: enter
  _type: TableName
  name: order_line
  schema: ""
- _phase: leave
  _type: TableName
- _phase: leave
  _type: TableSource
- _phase: leave
  _type: Join
- _phase: enter
  _type: TableSource
  as_name: ""
- _phase: enter
  _type: TableName
  name: stock
  schema: ""
- _phase: leave
  _type: TableName
- _phase: leave
  _type: TableSource
- _phase: leave
  _type: Join
- _phase: leave
  _type: TableRefsClause
- _phase: enter
  _type: BinaryOperationExpr
  op: and
- _phase: enter
  _type: BinaryOperationExpr
  op: and
- _phase: enter
  _type: BinaryOperationExpr
  op: and
- _phase: enter
  _type: BinaryOperationExpr
  op: and
- _phase: enter
  _type: BinaryOperationExpr
  op: and
- _phase: enter
  _type: BinaryOperationExpr
  op: and
- _phase: enter
  _type: BinaryOperationExpr
  op: eq
- _phase: enter
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnName
  name: ol_w_id
  schema: ""
  table: ""
- _phase: leave
  _type: ColumnName
- _phase: leave
  _type: ColumnNameExpr
- _phase: enter
  _type: ParamMarkerExpr
  in_execute: false
  offset: 89
  order: 0
- _phase: leave
  _type: ParamMarkerExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: enter
  _type: BinaryOperationExpr
  op: eq
- _phase: enter
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnName
  name: ol_d_id
  schema: ""
  table: ""
- _phase: leave
  _type: ColumnName
- _phase: leave
  _type: ColumnNameExpr
- _phase: enter
  _type: ParamMarkerExpr
  in_execute: false
  offset: 107
  order: 0
- _phase: leave
  _type: ParamMarkerExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: enter
  _type: BinaryOperationExpr
  op: lt
- _phase: enter
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnName
  name: ol_o_id
  schema: ""
  table: ""
- _phase: leave
  _type: ColumnName
- _phase: leave
  _type: ColumnNameExpr
- _phase: enter
  _type: ParamMarkerExpr
  in_execute: false
  offset: 125
  order: 0
- _phase: leave
  _type: ParamMarkerExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: enter
  _type: BinaryOperationExpr
  op: ge
- _phase: enter
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnName
  name: ol_o_id
  schema: ""
  table: ""
- _phase: leave
  _type: ColumnName
- _phase: leave
  _type: ColumnNameExpr
- _phase: enter
  _type: BinaryOperationExpr
  op: minus
- _phase: enter
  _type: ParamMarkerExpr
  in_execute: false
  offset: 144
  order: 0
- _phase: leave
  _type: ParamMarkerExpr
- _phase: enter
  _type: ParamMarkerExpr
  in_execute: false
  offset: 148
  order: 0
- _phase: leave
  _type: ParamMarkerExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: enter
  _type: BinaryOperationExpr
  op: eq
- _phase: enter
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnName
  name: s_w_id
  schema: ""
  table: ""
- _phase: leave
  _type: ColumnName
- _phase: leave
  _type: ColumnNameExpr
- _phase: enter
  _type: ParamMarkerExpr
  in_execute: false
  offset: 165
  order: 0
- _phase: leave
  _type: ParamMarkerExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: enter
  _type: BinaryOperationExpr
  op: eq
- _phase: enter
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnName
  name: s_i_id
  schema: ""
  table: ""
- _phase: leave
  _type: ColumnName
- _phase: leave
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnName
  name: ol_i_id
  schema: ""
  table: ""
- _phase: leave
  _type: ColumnName
- _phase: leave
  _type: ColumnNameExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: enter
  _type: BinaryOperationExpr
  op: lt
- _phase: enter
  _type: ColumnNameExpr
- _phase: enter
  _type: ColumnName
  name: s_quantity
  schema: ""
  table: ""
- _phase: leave
  _type: ColumnName
- _phase: leave
  _type: ColumnNameExpr
- _phase: enter
  _type: ValueExpr
- _phase: leave
  _type: ValueExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: leave
  _type: BinaryOperationExpr
- _phase: leave
  _type: SelectStmt