select BLOCK_TIMESTAMP, user,

case

when program_id in ('ALTNSZ46uaAUU7XUV6awvdorLGqAsPwa9shm7h4uP2FK','TLDHkysf5pCnKsVA4gXpNvmy7psXLPEu4LAdDJthT9S') then 'AllDomains'

when program_id='turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN' then 'Turbo Tap'

when program_id='whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc' then 'Orca'

when program_id in ('5hEa5j38yNJRM9vQA44Q6gXVj4Db8y3mWxkDtQeofKKs','RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE','Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic') then 'Scope'

when program_id='iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU' then 'Invariant'

when program_id='4UsSbJQZJTfZDFrgvcPBRCSg5BbcQE6dobnriCafzj12' then 'Lifinity'

when program_id='So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo' then 'Save Finance'

when program_id in ('FJu4E1BDYKVg7aTWdwATZRUvytJZ8ZZ2gQuvPfMWAz9y','EqRSt9aUDMKYKhzd1DGMderr3KNp29VZH3x5P7LFTC8m','BpXHAiktwjx7fN6M9ST9wr6qKAsH27wZFhdHEhReJsR6',

'5g5ujyYUNvdydwyDVCpZwPpgYRqH5RYJRi156cxyE3me','6tBGmKNxirxBYnm9khkaTtcr2fhJ9YviCgRm1RWM8NJv','EitxJuv2iBjsg2d7jVy2LDC1e2zBrx4GB5Y9h2Ko3A9Y') then 'Hyperlane'

when program_id='Cook7kyoaKaiG57VBDUjE2KuPXrWdLEu7d3FdDgsijHU' then 'Let`s Cook'

when program_id='MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr' and INSTRUCTION:programId::string='MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr' then 'Send Arcade'

when program_id='MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr' and INSTRUCTION:programId::string!='MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr' then 'Memo Program'

when program_id='E98KDQN4NuhPcj4KD82pZj122KxYZ9dNhsNaAbPXLkeY' then 'Polymarket'

when program_id='DcZMKcjz34CcXF1vx7CkfARZdmEja2Kcwvspu1Zw6Zmn' then 'Sharp Trade'

when program_id='sooGfQwJ6enHfLTPfasFZtFR7DgobkJD77maDNEqGkD' then 'Solar'

when program_id='Astro1oWvtB7cBTwi3efLMFB47WXx7DJDQeoxi235kA' then 'Astrol'

when program_id='7X3YmPcRu4V5GKxeFvC9MQq4bemCdR5MWea5tVs62bM9' then 'FightHorse'

when program_id='F3MQq5eugYvhUJqnRruvyv3tu7nsVBgXxJrsaKfLhRDL' then 'Moonlaunch'

when program_id='6L3qpmxyVnHT1JenPwJaP856tfWg6HPV355XVuvSzea' then 'Moon Coin'

when program_id='AssetGtQBTSgm5s91d1RAQod5JmaZiJDxqsgtqrZud73' then 'Nifty'

when program_id in ('CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d','CMAGAKJ67e9hRZgfC5SFTbZH8MgEmtqazKXjmkaJjWTJ') then 'Metaplex Core'

else program_id end as program_name, program_id, tx_id

from

(select SIGNERS[0] as USER, *,

row_number() over (partition by USER order by BLOCK_TIMESTAMP,INDEX) as rank

from eclipse.core.fact_events

WHERE SUCCEEDED=TRUE

and program_id not in (

'ComputeBudget111111111111111111111111111111','11111111111111111111111111111111','TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA',

'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL', 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL','BPFLoaderUpgradeab1e11111111111111111111111',

'Stake11111111111111111111111111111111111111','TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb'))

)