TO_ADDRESS | |
---|---|
1 | 0x0f240ce37490980e643d9456cefe406d90dd7e04 |
0x07f2e2fE7A091e69389E6996644F1Af09441C7e4personal-jade
Updated 2025-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
distinct a.to_address
FROM
ink.core.fact_transactions as a,
ink.core.fact_traces as b,
ink.core.ez_token_transfers as c
WHERE
DATE(a.BLOCK_TIMESTAMP) = '2025-02-12'
and DATE(b.BLOCK_TIMESTAMP) = '2025-02-12'
and a.TX_HASH = b.TX_HASH
and b.TX_HASH = c.TX_HASH
and substring(b.input, 3, 8) != substring(a.INPUT_DATA, 3, 8)
and substring(b.input, 3, 8) != '00000000'
and substring(a.INPUT_DATA, 3, 8) != 'b7d5e564'
and substring(a.INPUT_DATA, 3, 8) != '5e935362'
and substring(a.INPUT_DATA, 3, 8) != '3bc33417'
and substring(a.INPUT_DATA, 3, 8) != '9d55b53f'
and substring(a.INPUT_DATA, 3, 8) != '6a761202'
and substring(a.INPUT_DATA, 3, 8) != '7a9a1628'
and substring(a.INPUT_DATA, 3, 8) != 'b88d4fde'
and substring(a.INPUT_DATA, 3, 8) != '1cff79cd'
and substring(a.INPUT_DATA, 3, 8) != '3f801f91'
and substring(a.INPUT_DATA, 3, 8) != 'f242432a'
and substring(a.INPUT_DATA, 3, 8) != '59a4c24e'
and substring(a.INPUT_DATA, 3, 8) != '91aeeedc'
and substring(a.INPUT_DATA, 3, 8) != '26aa4655'
and substring(a.INPUT_DATA, 3, 8) != 'd1e30025'
and substring(a.INPUT_DATA, 3, 8) != '59a4c24e'
and substring(a.INPUT_DATA, 3, 8) != 'ab4ed83e'
and substring(a.INPUT_DATA, 3, 8) != 'dfec09e1'
and substring(a.INPUT_DATA, 3, 8) != '8fd8d1bb'
and substring(a.INPUT_DATA, 3, 8) != '0ceff6f1'
and substring(a.INPUT_DATA, 3, 8) != '47e1da2a'
and a.INPUT_DATA like concat('%', substring(b.input, 3), '%')
and a.INPUT_DATA like concat('%', substring(b.TO_ADDRESS, 3), '%')
and b.from_address = a.to_address
Last run: about 1 month ago
1
48B
4s