select

DISTINCT contract_address

FROM base.core.ez_token_transfers

where tx_hash in (

select

tx_hash

from base.core.fact_transactions

where to_address LIKE lower('0xF66DeA7b3e897cD44A5a231c61B6B4423d613259')

and origin_function_signature LIKE '0x3c0b93aa'

and status like 'SUCCESS'

)

and from_address like '0x0000000000000000000000000000000000000000'

SELECT *

FROM base.defi.ez_dex_swaps

where token_in in (SELECT * from tab1)

or token_out in (SELECT * from tab1)

LIMIT 100