select distinct tx_id from sei.core.fact_msg_attributes

where attribute_key = '_contract_address'

and attribute_value = 'sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz'

),

t2 as (

tx_id,

block_timestamp,

a.attribute_value as seller

from sei.core.fact_msg_attributes a

join sei.core.fact_msg_attributes b

using(tx_id, block_timestamp)

where a.msg_type = 'wasm-execute-exchange'

and a.attribute_key = 'seller'

and b.msg_type = 'wasm-execute-exchange'

and b.attribute_key = 'buyer'

and tx_id in (select tx_id from t)

select * from t2

where tx_id = 'C7DBA66EFC98475F576F2AE553B3716D88DFE909CAA433D9E3A739299E13E28D'