ShapeShift2024-06-13 04:07 PM
    Updated 2024-06-13
    SELECT
    s.from_asset,
    s.asset_usd,
    s.rune_usd,
    se.tx_id,
    se.memo,
    s.affiliate_address,
    s.affiliate_fee_basis_points,
    s.from_amount,
    s.from_amount_usd,
    FROM
    thorchain.defi.fact_swaps s
    JOIN
    thorchain.defi.fact_swaps_events se
    ON
    se.tx_id = s.tx_id
    WHERE
    s.affiliate_address IN ('ss', 'thor1xmaggkcln5m5fnha2780xrdrulmplvfrz6wj3l')
    AND NOT REGEXP_LIKE(se.memo, '.*:\\d+/\\d+/\\d+:.*');
    QueryRunArchived: QueryRun has been archived