SPORTPASS2024-07-02 02:12 PM
Updated 2024-07-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH combined_addresses AS (
SELECT DISTINCT EVENT_DATA:from as address
FROM flow.core.fact_events
WHERE EVENT_CONTRACT LIKE '%AFLNFT%'
AND TX_SUCCEEDED = 'TRUE'
UNION
SELECT DISTINCT EVENT_DATA:to as address
FROM flow.core.fact_events
WHERE EVENT_CONTRACT LIKE '%AFLNFT%'
AND TX_SUCCEEDED = 'TRUE'
)
SELECT address
FROM combined_addresses
ORDER BY address;
QueryRunArchived: QueryRun has been archived