SELECT * FROM (VALUES

('ComputeBudget111111111111111111111111111111'),

('11111111111111111111111111111111'),

('TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'),

('ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL'),

('BPFLoaderUpgradeab1e11111111111111111111111'),

('Stake11111111111111111111111111111111111111'),

('TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb')

) AS t (program_id)

),

users_first_app AS (

SELECT

fe.BLOCK_TIMESTAMP,

fe.SIGNERS[0] AS user,

COALESCE(pm.program_name, fe.program_id) AS program_name,

fe.program_id,

fe.tx_id

FROM eclipse.core.fact_events fe

LEFT JOIN (

SELECT * FROM (VALUES

('7X3YmPcRu4V5GKxeFvC9MQq4bemCdR5MWea5tVs62bM9', 'FightHorse'),

('TLDHkysf5pCnKsVA4gXpNvmy7psXLPEu4LAdDJthT9S', 'AllDomains'),

('Astro1oWvtB7cBTwi3efLMFB47WXx7DJDQeoxi235kA', 'Astrol'),

('whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc', 'Orca'),

('E98KDQN4NuhPcj4KD82pZj122KxYZ9dNhsNaAbPXLkeY', 'Polymarket'),

('Cook7kyoaKaiG57VBDUjE2KuPXrWdLEu7d3FdDgsijHU', 'Let`s Cook'),

('ALTNSZ46uaAUU7XUV6awvdorLGqAsPwa9shm7h4uP2FK', 'AllDomains'),

('AssetGtQBTSgm5s91d1RAQod5JmaZiJDxqsgtqrZud73', 'Nifty'),

('sooGfQwJ6enHfLTPfasFZtFR7DgobkJD77maDNEqGkD', 'Solar'),

('So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo', 'Save Finance'),

('CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d', 'Metaplex Core'),

('turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN', 'Turbo Tap'),

('F3MQq5eugYvhUJqnRruvyv3tu7nsVBgXxJrsaKfLhRDL', 'Moonlaunch'),

('CMAGAKJ67e9hRZgfC5SFTbZH8MgEmtqazKXjmkaJjWTJ', 'Metaplex Core'),

('DcZMKcjz34CcXF1vx7CkfARZdmEja2Kcwvspu1Zw6Zmn', 'Sharp Trade'),