WITH INTERACT_WITH_DAGORA_EXCHANGE_1 AS

SELECT BLOCK_TIMESTAMP, TX_ID, MSG_INDEX

FROM sei.core.fact_msg_attributes

WHERE ATTRIBUTE_VALUE = 'sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz'

AND ATTRIBUTE_KEY = '_contract_address'

AND MSG_TYPE = 'wasm'

--AND TX_ID = 'DD52EDA09CFD93E79836778BF12DF20A0969501B810AD4B13923EB9726884383'

GROUP BY BLOCK_TIMESTAMP, TX_ID, MSG_INDEX

),

NFT_ADDRESS_ID_DAGORA AS (

SELECT INTR.BLOCK_TIMESTAMP, INTR.TX_ID, INTR.MSG_INDEX, SPLIT_PART(ATTRIBUTE_VALUE, ',', 2) AS NFT_ADDRESS ,SPLIT_PART(ATTRIBUTE_VALUE, ',', 1) AS ID

FROM INTERACT_WITH_DAGORA_EXCHANGE_1 INTR JOIN sei.core.fact_msg_attributes USING(TX_ID,MSG_INDEX)

WHERE ATTRIBUTE_KEY = 'nft'

),

FIX_NFT_ADDRESS_ID_DAGORA AS (

SELECT BLOCK_TIMESTAMP, TX_ID, MSG_INDEX+1 AS MSG_INDEX, NFT_ADDRESS, ID

FROM NFT_ADDRESS_ID_DAGORA

),

INTERACT_WITH_DAGORA_EXCHANGE_2 AS

SELECT BLOCK_TIMESTAMP, TX_ID, MSG_INDEX

FROM sei.core.fact_msg_attributes

WHERE ATTRIBUTE_VALUE = 'sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz'

AND ATTRIBUTE_KEY = '_contract_address'

AND MSG_TYPE = 'wasm-execute-exchange'

--AND TX_ID = 'DD52EDA09CFD93E79836778BF12DF20A0969501B810AD4B13923EB9726884383'

GROUP BY BLOCK_TIMESTAMP, TX_ID, MSG_INDEX

),

BUYERS_DAGORA AS (