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
avalanche.core.fact_transactions as a,
avalanche.core.fact_traces as b,
avalanche.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) != substring(a.input_data, 3, 8)
and substring(a.input_data, 3, 8) != '9d55b53f'
and substring(a.input_data, 3, 8) != 'b7d5e564'
and substring(a.input_data, 3, 8) != '3bc33417'
and substring(a.input_data, 3, 8) != '6a761202'
and substring(a.input_data, 3, 8) != '7a9a1628'
and substring(a.input_data, 3, 8) != '5e935362'
and substring(a.input_data, 3, 8) != 'b88d4fde'
and substring(a.input_data, 3, 8) != '1cff79cd'
and substring(a.input_data, 3, 8) != 'e0e90acf'
and substring(a.input_data, 3, 8) != '9304c934'
and substring(a.input_data, 3, 8) != '09779927'
and substring(a.input_data, 3, 8) != '9b78fdd9'
and substring(a.input_data, 3, 8) != '39bf70d1'
and substring(a.input_data, 3, 8) != '4f1ef286'
and substring(a.input_data, 3, 8) != '26aa4655'
and substring(a.input_data, 3, 8) != '59a4c24e'
and substring(a.input_data, 3, 8) != 'a22cb465'
and substring(a.input_data, 3, 8) != 'f242432a'
and substring(a.input_data, 3, 8) != '1c7ee796'
and substring(a.input_data, 3, 8) != '1840f5c2'
and substring(a.input_data, 3, 8) != '419f1992'
and substring(a.input_data, 3, 8) != '8433e7f3'
and substring(a.input_data, 3, 8) != '163cacd5'
and substring(a.input_data, 3, 8) != '34fcd5be'
and substring(a.input_data, 3, 8) != '8fd8d1bb'
and substring(b.input, 3, 8) = '23b872dd'
Run a query to Download Data