WITH xref_finance AS ( --vote with ref

SELECT block_timestamp, tx_hash, signer_id as User, 'xRef' AS Stake_type,

args:amount / 1e18 AS adjusted_amount,

CASE

WHEN receiver_id = 'memefarm-xref-lonk.ref-labs.near' THEN 'lonk'

WHEN receiver_id = 'memefarm-xref-usm.ref-labs.near' THEN 'usmemetg'

WHEN receiver_id = 'memefarm-xref-blackdragon.ref-labs.near' THEN 'blackdragon'

WHEN receiver_id = 'memefarm-xref-gear.ref-labs.near' THEN 'Gear'

WHEN receiver_id = 'memefarm-xref-uwon.ref-labs.near' THEN 'Uwon'

WHEN receiver_id = 'memefarm-xref-kat.ref-labs.near' THEN 'Kat'

WHEN receiver_id = 'memefarm-xref-intel.ref-labs.near' THEN 'INTEAR'

WHEN receiver_id = 'memefarm-xref-chill.ref-labs.near' THEN 'Chill'

WHEN receiver_id = 'memefarm-xref-shitzu.ref-labs.near' THEN 'shitzu'

WHEN receiver_id = 'memefarm-xref-bd.ref-labs.near' THEN 'Bendog'

END AS token_name

from near.core.fact_actions_events_function_call

where predecessor_id = 'xtoken.ref-finance.near'

and receiver_id LIKE '%memefarm-xref%'

and block_timestamp >= '2024-10-01'

and method_name = 'ft_on_transfer'

AND receipt_succeeded = 1

UNION ALL

SELECT block_timestamp, tx_hash, signer_id as User, 'Meme' AS Stake_type,

CASE

WHEN predecessor_id = 'nearnvidia.near' THEN args:amount / 1e8

WHEN predecessor_id = 'token.lonkingnearbackto2024.near' THEN args:amount / 1e8

WHEN predecessor_id = 'token.0xshitzu.near' THEN args:amount / 1e18

WHEN predecessor_id = 'gear.enleap.near' THEN args:amount / 1e18

WHEN predecessor_id = 'chill-129.meme-cooking.near' THEN args:amount / 1e18