0x07f2e2fE7A091e69389E6996644F1Af09441C7e4shihisyunqi
Updated 2023-07-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
SELECT
distinct a.tx_hash
FROM
optimism.core.fact_transactions as a,
optimism.core.fact_traces as b,
optimism.core.fact_token_transfers as c
WHERE
a.tx_hash = b.tx_hash
and b.tx_hash = c.tx_hash
and substring(b.input, 3, 8) = 'fa461e33' /*d3487997*/ /*0xfa461e33 univ3swap*/
/* and c.TOPICS[0] = '0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925'
and c.TOPICS[2] like concat('%', substring(a.to_address, 3), '%')*/
and a.input_data like concat('%', substring(b.from_address, 3), '%')
and a.from_address = c.from_address
and a.to_address = b.to_address
and a.to_address = '0x10eff04c6d9ac5eb77109ad76010c36357748edb'
and b.input != '0x'
Run a query to Download Data