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'