select

tx_id

,block_timestamp

,event_type

,decoded_instruction:accounts[0]:name --funding address accound

,decoded_instruction:accounts[0]:pubkey as funding_address

,decoded_instruction:accounts[1]:name --game account

,decoded_instruction:accounts[1]:pubkey as game_account--game account

,decoded_instruction:accounts[2]:name --gamePlayer player account

,decoded_instruction:accounts[2]:pubkey as game_player--gamePlayer player account

,decoded_instruction:accounts[3]:name --treasury

,decoded_instruction:accounts[3]:pubkey as treasury

,decoded_instruction:args:gameArgs:allowJoin as allow_join

,decoded_instruction:args:gameArgs:blocktimeStart as blocktime_start

,decoded_instruction:args:gameArgs:currency as currency

,decoded_instruction:args:gameArgs:days as days

,decoded_instruction:args:gameArgs:dropinDays as droping_Days

,decoded_instruction:args:gameArgs:gameId as game_id

,decoded_instruction:args:gameArgs:limit as limit

,decoded_instruction:args:gameArgs:meta as meta

,decoded_instruction:args:gameArgs:metaVersion as meta_version

,decoded_instruction:args:gameArgs:playerDeposit as player_deposit

,decoded_instruction:args:gameArgs:qtyPerDay as steps_per_day

,decoded_instruction:args:gameArgs:version as version

,case

when currency = '{"sol":{}}' then 'So11111111111111111111111111111111111111112'

when currency = '{"USDC":{}}' then 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

when currency = '{"bonk":{}}' then 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

end as token_address

--,decoded_instruction

from solana.core.ez_events_decoded

where block_timestamp > '2024-03-22'

and program_id = 'FitAFk15vtx2PBjfr7QTnefaHRx6HwajRiZMt1DdSSKU'

and event_type = 'initializeGame'

),