CTE_1 AS (

SELECT

tx_id,

block_timestamp,

-BASE64_DECODE_STRING(msgs[32]:attributes[7]:value) AS return_amount,

BASE64_DECODE_STRING(msgs[32]:attributes[6]:value) AS offer_amount,

BASE64_DECODE_STRING(msgs[32]:attributes[4]:value) AS offer_asset,

BASE64_DECODE_STRING(msgs[32]:attributes[5]:value) AS return_asset

FROM

sei.core.fact_transactions

WHERE

msgs[32]:attributes[0]:key='X2NvbnRyYWN0X2FkZHJlc3M=' -- contract_address

AND msgs[32]:attributes[0]:value='c2VpMWpxa3FwN3FsMG45ZWRwOWU3eTg2em50MG0yaDdyc3RsYzJyd2Z2eXh6cmo4NGV0OWN6YXE4OXVxZHg=' -- withd liq

),

CTE_2 AS (

SELECT

tx_id,

block_timestamp,

-BASE64_DECODE_STRING(msgs[33]:attributes[7]:value) AS return_amount,

BASE64_DECODE_STRING(msgs[33]:attributes[6]:value) AS offer_amount,

BASE64_DECODE_STRING(msgs[33]:attributes[4]:value) AS offer_asset,

BASE64_DECODE_STRING(msgs[33]:attributes[5]:value) AS return_asset

FROM

sei.core.fact_transactions

WHERE

msgs[32]:attributes[0]:key='X2NvbnRyYWN0X2FkZHJlc3M=' -- contract_address

AND msgs[32]:attributes[0]:value='c2VpMWpxa3FwN3FsMG45ZWRwOWU3eTg2em50MG0yaDdyc3RsYzJyd2Z2eXh6cmo4NGV0OWN6YXE4OXVxZHg=' -- withd liq

)

SELECT

COALESCE(CTE_1.tx_id, CTE_2.tx_id) AS tx_id,

COALESCE(CTE_1.block_timestamp, CTE_2.block_timestamp) AS block_timestamp,

COALESCE(CTE_1.return_amount, CTE_2.return_amount)/1e6 AS return_amount,

COALESCE(CTE_1.offer_amount, CTE_2.offer_amount)/1e6 AS offer_amount,

COALESCE(CTE_1.offer_asset, CTE_2.offer_asset) AS offer_asset,

COALESCE(CTE_1.return_asset, CTE_2.return_asset) AS return_asset