select origin_from_address,

chain,

to_address as pool_address,

case origin_from_address

when '0x6aac0942b8147bffab73789a82ee12fda7735bac' then 'ZeroLend'

when '0x0f6e98a756a40dd050dc78959f45559f98d3289d' then 'ZeroLend'

when '0xd955f0c167adbf7d553fc4d59a964a1b115cc093' then 'Avalon'

else null

end as mm_protocol,

substr(input, 0, 10) as func_sign,

concat('0x', substr(input, 35, 40)) as asset,

concat('0x', substr(input, 99, 40)) as aToken_address,

concat('0x', substr(input, 227, 40)) as variable_debt_address,

tx_hash,

from

(

select origin_from_address, to_address, input, tx_hash, 'ethereum' as chain

from ethereum.core.fact_traces

where substr(input, 0, 10) = '0x7a708e92' and TX_SUCCEEDED and BLOCK_TIMESTAMP > '2025-02-01'

union all

select origin_from_address, to_address, input, tx_hash, 'arbitrum' as chain

from arbitrum.core.fact_traces

where substr(input, 0, 10) = '0x7a708e92' and TX_SUCCEEDED and BLOCK_TIMESTAMP > '2025-02-01'

union all

select origin_from_address, to_address, input, tx_hash, 'base' as chain

from base.core.fact_traces

where substr(input, 0, 10) = '0x7a708e92' and TX_SUCCEEDED and BLOCK_TIMESTAMP > '2025-02-01'

union all

select origin_from_address, to_address, input, tx_hash, 'bsc' as chain