telperionUnclaimed $WINR From Camelot Launchpad
Updated 2023-07-02
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
›
⌄
SELECT
a.origin_from_address as wallet,
a.amount as USDC_deposited,
a.amount/0.029 as unclaimed_WINR
FROM
(SELECT
origin_from_address,
(sum(event_inputs:value))/1000000 as amount
FROM
arbitrum.core.fact_event_logs
WHERE
contract_address = LOWER('0x40BF2461e5Cf86850174Ef4aE42d5cbfdc4b47d4')
AND tx_status = 'SUCCESS'
and event_name = 'Buy'
group by origin_from_address) a
left join
(SELECT
origin_from_address,
(sum(event_inputs:usdt))/1000000000000000000 as amount
FROM
arbitrum.core.fact_event_logs
WHERE
contract_address = LOWER('0x40BF2461e5Cf86850174Ef4aE42d5cbfdc4b47d4')
AND tx_status = 'SUCCESS'
and event_name = 'Claim'
group by origin_from_address) b
on a.origin_from_address = b.origin_from_address
where b.amount is null
order by unclaimed_WINR desc
Run a query to Download Data