hkeyingame wallets <> main wallets
Updated 2025-01-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT DISTINCT SIGNERS[0] AS main_acc, SIGNERS[1] AS playing_acc
FROM eclipse.core.fact_transactions
WHERE block_timestamp::date >= '2024-12-01'
AND SUCCEEDED = 'TRUE'
AND LOG_MESSAGES[0] LIKE '%turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN%'
AND LOG_MESSAGES[1] = 'Program log: Instruction: GrantClicker'
AND SIGNERS[1] IN (
SELECT DISTINCT signers[0]
FROM eclipse.core.fact_events
WHERE block_timestamp::date >= '2024-12-01'
AND PROGRAM_ID = 'turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN'
AND SUCCEEDED = 'TRUE'
GROUP BY signers[0]
having COUNT(DISTINCT tx_id) >= 100
)
QueryRunArchived: QueryRun has been archived