with eth_markets as (

select

distinct contract_address

from ethereum.core.fact_event_logs

where 1=1

and origin_function_signature = '0xfa18022c' -- prepareMiso

and event_name = 'AuctionWalletUpdated'

-- and tx_hash = '0x79a6e43a80bff6db671bfff8cbee46ac46d612c8ef282b1cb9ba1bc134890d38'

order by contract_address

),

eth_commit_txns as (

select

*

from ethereum.core.fact_event_logs

where 1=1

and (

-- Non-ETH Tokens

(

origin_function_signature = '0xdc97e082' -- commitTokens

and event_name = 'Transfer'

) or

-- ETH Tokens

(

origin_function_signature = '0x29762960' -- commitEth

and event_name = 'AddedCommitment'

)

)

-- and tx_hash = '0x6e5b522ebca252f40384bc23d9301723f10c4c3b3c58ab1bbe3439dc4df00bf4'

and origin_to_address in (select contract_address from eth_markets)

),

bsc_markets as (

select

distinct contract_address

from bsc.core.fact_event_logs