rezarwzmysteri box eth
    Updated 2023-11-07
    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