0x07f2e2fE7A091e69389E6996644F1Af09441C7e4approve input data
Updated 2023-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select DISTINCT
a.tx_hash
from
bsc.core.fact_transactions as a,
bsc.core.fact_event_logs as b
where
a.tx_hash = b.tx_hash
and DATE(a.BLOCK_TIMESTAMP) = '2023-07-03'
and DATE(b.BLOCK_TIMESTAMP) = '2023-07-03'
and b.TOPICS[0] = '0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925'
and b.TOPICS[1] = concat('0x000000000000000000000000', substring(a.to_address, 3),'')
and b.TOPICS[2] != '0x0000000000000000000000000000000000000000000000000000000000000000'
and a.input_data like concat('%', substring(b.topics[2], 27, 67),'%')
and a.to_address = '0x735c1224cd4c7dcef37da269f7434bde548d6062'
Run a query to Download Data