freemartianRewards Received while Depositing
    Updated 2023-09-10
    -- Received Reward while Depositing for the second time onwards (harvesting previous BLID rewards)

    select
    tx_hash,
    decoded_log:from,
    decoded_log:to as receiver,
    decoded_log:value/pow(10,decimals) as reward_amount,
    symbol as token_symbol
    from bsc.core.ez_decoded_event_logs l
    inner join bsc.core.dim_contracts c on c.address = l.contract_address
    where event_name = 'Transfer'
    and contract_address = '0x766afcf83fd5eaf884b3d529b432ca27a6d84617'
    and origin_function_signature = '0x00f714ce'
    and decoded_log:from in ('0x941ef9aaf3277052e2e6c737ae9a75b229a20988',
    '0xed18f1ce58fed758c7937cc0b8be66cb02dc45c6',
    '0x5d735e9ffe9664b80c405d16921912e5b989688c')


    Run a query to Download Data