SELECT SUM(vxl_order_line.discount)
FROM vxl.vxl_order
JOIN vxl.vxl_order_line USING (outlet_id, vxl_order_id)
JOIN vxl.applied_discount USING (outlet_id, vxl_order_id)
JOIN vxl.discount USING (discount_id)
WHERE order_ts >= '{cash_out_tstamp_start}'::timestamptz
      AND order_ts < '{cash_out_tstamp_end}'::timestamptz
      AND order_line_status NOT IN ('void', 'return')
      AND NOT training_data
      AND vxl_order.outlet_id = {outlet_id}
      AND discount > 0
      AND vxl_order_line.vxl_order_line_id = applied_discount.vxl_order_line_id