all_interactions as (

select distinct

case

when program_id in (

'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW',

'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg',

'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2'

) then 'Star Atlas'

when program_id in (

'HAbiTatJVqoCJd9asyr6RxMEdwtfrQugwp7VAFyKWb1g',

'CrAFTUv7zKXBaS5471aCwHx7mq9Jp1eQQB5FQgdiSLyi',

'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v',

'srmv4uTCPF81hWDaPyEN2mLZ8XbvzuEM6LsAxR8NpjU'

) then 'Genopets'

when program_id in (

'EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J',

'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5',

'StKLLTf7CQ9n5BgXPSDXENovLTCuNc7N2ehvTb6JZ5x',

'comp8FLpN5bbNUC2fhnkFtM7T16DWvaHs8N5dcaoZWP',

'CAsieqooSrgVxhgWRwh21gyjq7Rmuhmo4qTW9XzXtAvW'

) then 'Aurory'

end as label_game,

signers[0] as user_address

from solana.core.fact_events events

where succeeded

and program_id in (

'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW', -- SA FLEET Program

'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg', -- SA Marketplace Program

'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2', -- SA Governance Staking Program

'HAbiTatJVqoCJd9asyr6RxMEdwtfrQugwp7VAFyKWb1g', -- GP Habitats Program