DISTINCT

CASE

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('eth') THEN 'Ethereum'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('sol') THEN 'Solana'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('btc') THEN 'Bitcoin'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('gnosis') THEN 'Gnosis'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('arb') THEN 'Arbitrum'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('base') THEN 'Base'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('aurora') THEN 'Aurora'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('xrp') THEN 'XRP Ledger'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('bsc') THEN 'BNB Smart Chain'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('zec') THEN 'Zcash'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('doge') THEN 'Dogecoin'

WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('bera') THEN 'Berachain'

ELSE 'NEAR'

END AS blockchain_name

FROM near.defi.fact_intents;