select

distinct el.contract_address as contract,

case

when dl.project_name is not null and dl.project_name != 'planet ix - assets' then dl.project_name

when el.contract_address is null then 'transfer'

when el.contract_address in ('0x0c1ebbb61374da1a8c57cb6681bf27178360d36f',

'0x488863d609f3a673875a914fbee7508a1de45ec6' --bridge to aptos

) then 'layer zero'

when el.contract_address in ('0xa47c861de3272690a51f57e0e43551e55f6c790d',

'0x70012d84a1044454cfb2973d5968fa451f94f5cc',

'0x24e541a5c32830a4e8b89846fd4bf86e294dd3cb',

'0xba6666b118f8303f990f3519df07e160227cce87', --planet ix assets

'0x56b4d5e18441fdd09bf4ad69c484866e92b8650e') then 'planet ix'

when el.contract_address in ('0x9d5d479a84f3358e8e27afe056494bd2da239acd', -- mainnetalpha galxe NFT

'0xa25be50be65070c2ad96d5ed639061de31c45e12', -- tx prover

'0x2e953a70c37e8cb4553dae1f5760128237c8820d',

'0x6b0c248679f493481411a0a14cd5fc2dbbe8ab02',

'0x5e6589b5c06096405bdbce59821027c6854b1a44' -- loyalty program galxe NFT

) then 'polyhedra' --https://polyhedra.network/

when el.contract_address in ('0x8acecfa353f46c6afe235b2b838154426612cdd8', --BetaWLD token

'0xec11fc239bb43474b270242ddaae9fb7973936c1', --Claim BetaWLD

'0x261bd83050579edea22d90a18fcc9dafd43d10e3') then 'worldcoin'

when el.contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3' then 'btc.b'

when el.contract_address in ('0xaa9c15cd603428ca8ddd45e933f8efe3afbcc173',

'0x7081a38158bd050ae4a86e38e0225bc281887d7e',

'0x817eb46d60762442da3d931ff51a30334ca39b74') then 'woofi'

when el.contract_address = '0xf53343233359e700e83ba797f3b9d0d7dfd27138' then 'sui futures bitget' --$SUIBG, https://twitter.com/SuiWorldHQ/status/1639980786844856322?lang=en https://blog.bitkeep.com/en/?p=3905

when el.contract_address = '0xe6f1d4eef6ea4cf5ae53eb13549ef52849d5dca3' then 'benji bananas'

when el.contract_address = '0x1a924340c013084f0da820ba9eec11ac76951bbe' then 'pixels' --https://twitter.com/pixels_online

when el.contract_address = '0x8e0dcca4e6587d2028ed948b7285791269059a62' then 'rarible bear pass' --just rarible?

when el.contract_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57' then 'paraswap' --v5: augustus swapper

when el.contract_address = '0xff04820c36759c9f5203021fe051239ad2dcca8a' then 'guild' --Guild Credential https://twitter.com/guildxyz

when el.contract_address in ('0x4cbca5c2b88e3fcc38fdd6982f1bab6efb32f234', --galxe 2 year anniversary NFT

'0xbc2b5d07e8658d74176e3044fd60b38d08f926a4', --orbiter trainee pilot nft

'0x829c606d2ba4cdef61df2bbac49718bd40024f02', --syncswap era pioneer