SELECT

AFFILIATE_ADDRESS,

AFFILIATE_FEE_BASIS_POINTS,

FROM_AMOUNT_USD,

CASE

WHEN affiliate_address IN ('t', 'T','ts','thor160yye65pf9rzwrgqmtgav69n6zlsyfpgm9a7xk') THEN 'Thorswap'

WHEN affiliate_address IN ('ti', 'te','tr', 'td') THEN 'Trust Wallet'

WHEN affiliate_address IN ('dx','thor1ap5vn4svwkpch2c9jm7hlpr2pj47e62xwpcvtw') THEN 'Asgardex'

WHEN affiliate_address IN ('wr','thor1a427q3v96psuj4fnughdw8glt5r7j38lj7rkp8') THEN 'Thorwallet'

WHEN affiliate_address IN ('zcx-com','0xbami') THEN 'Unizen'

WHEN affiliate_address = 'ds' THEN 'Defispot'

WHEN affiliate_address = 'rg' THEN 'Rango'

WHEN affiliate_address = 'ss' THEN 'Shapeshift'

WHEN affiliate_address = 'lends' THEN 'Lends'

WHEN affiliate_address = 'bp' THEN 'BitPay'

WHEN affiliate_address = 'dcf' THEN 'Decentralfi'

WHEN affiliate_address = 'tl' THEN 'Thorswap Ledger'

WHEN affiliate_address = 'ej' THEN 'Edge Wallet'

WHEN affiliate_address = 'lifi' THEN 'Lifi'

WHEN affiliate_address = 'okw' THEN 'OKX Wallet'

WHEN affiliate_address = 'sy' THEN 'Symbiosis'

WHEN affiliate_address = 'oky' THEN 'OneKey'

WHEN affiliate_address = 'xdf' THEN 'XDEFI'

WHEN affiliate_address = 'zengo' THEN 'Zengo'

WHEN affiliate_address = 'cb' THEN 'Coinbot'

WHEN affiliate_address = 'pl' THEN 'Plexus'

WHEN affiliate_address = 'bqx' THEN 'Ethos'

WHEN affiliate_address = 'kf' THEN 'Babylon (Kensho)'

WHEN affiliate_address = 'ferz' THEN 'Ferz Wallet'

WHEN affiliate_address = 'runifier' THEN 'Runifier'

WHEN affiliate_address = 'cakewallet' THEN 'Cake Wallet'

WHEN affiliate_address = 'ELD' THEN 'El Dorado'

WHEN affiliate_address = 'll' THEN 'Ledger Live'

WHEN affiliate_address = 'bgw' THEN 'Bitget Wallet'

WHEN affiliate_address IN ('vi', 'va') THEN 'Vultisig'