rezarwzmysteri box eth
Updated 2023-11-07
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
›
⌄
WITH
handles AS (
SELECT
tx_hash AS cr_tx_hash,
DECODED_LOG:handle::string AS username,
DECODED_LOG:profileId::integer AS profile_id,
DECODED_LOG:to::string AS creator
FROM
bsc.core.ez_decoded_event_logs
WHERE
contract_address = '0x2723522702093601e6360cae665518c4f63e9da6'
AND event_name = 'CreateProfile'
),
Mystery_Box_eth as (
SELECT
tx_hash,
TOKENID,
NFT_TO_ADDRESS as claimer_address
FROM
ethereum.core.ez_nft_mints
WHERE
nft_address = '0xce4f341622340d56e397740d325fd357e62b91cb'
),
Mystery_Box_Bsc as (
SELECT
tx_hash,
DECODED_LOG:boxId::string as TOKENID,
DECODED_LOG:to::string as claimer_address
FROM
bsc.core.ez_decoded_event_logs
WHERE
event_name = 'ClaimBox'
AND CONTRACT_ADDRESS = '0xcadc6c364e8fcad0f382fddfd6ff5b41d82eb3e4'
)
SELECT
'The number of remaining boxes' as status,
Run a query to Download Data