rishiahujaRetro - Total Unique Users
Updated 2024-09-12
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
›
⌄
WITH combined_events AS (
SELECT EVENT_DATA['player'] AS user_id
FROM aptos.core.fact_events
WHERE EVENT_TYPE = '0xcd7b88c2181881bf8e7ef741cae867aee038e75df94224496a4a81627edf7f65::plinko::PlayEvent'
UNION
SELECT EVENT_DATA['user_address'] AS user_id
FROM aptos.core.fact_events
WHERE EVENT_TYPE = '0xcd7b88c2181881bf8e7ef741cae867aee038e75df94224496a4a81627edf7f65::raffle::TicketMintEvent'
UNION
SELECT EVENT_DATA['player'] AS user_id
FROM aptos.core.fact_events
WHERE EVENT_TYPE = '0xcd7b88c2181881bf8e7ef741cae867aee038e75df94224496a4a81627edf7f65::wheel::PlayEvent'
UNION
SELECT EVENT_DATA['player'] AS user_id
FROM aptos.core.fact_events
WHERE EVENT_TYPE = '0xcd7b88c2181881bf8e7ef741cae867aee038e75df94224496a4a81627edf7f65::dice_roll::PlayEvent'
UNION
SELECT EVENT_DATA['player'] AS user_id
FROM aptos.core.fact_events
WHERE EVENT_TYPE = '0xcd7b88c2181881bf8e7ef741cae867aee038e75df94224496a4a81627edf7f65::coin_flip::PlayEvent'
)
SELECT COUNT(DISTINCT user_id) AS total_unique_users
FROM combined_events;
QueryRunArchived: QueryRun has been archived