*

from $query('0ad41d79-7bb8-4c48-b8e5-84298cf10a82')

,starbase_players AS (

player_profile::string as player_profile

,case when instruction:accounts[6] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'

AND instruction:accounts[10] = 'CRAFT2RPXPJWCEix4WpJST3E7NLf79GTqZUL75wngXo5'

then instruction:accounts[1]::string

when (instruction:accounts[18] = 'Point2iBvz7j5TMVef8nEgpmz4pDr7tU7v3RjAfkQbM'

OR instruction:accounts[24] = 'Point2iBvz7j5TMVef8nEgpmz4pDr7tU7v3RjAfkQbM')

then instruction:accounts[2]::string

end as starbase_player

FROM profile_wallets p,

solana.core.fact_events

WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'

AND succeeded = 'true'

AND p.wallet IN (signers[0], signers[1]) -- IN (p.wallet)

AND starbase_player IS NOT NULL

AND block_timestamp > current_date-30 AND block_timestamp < current_date

GROUP BY 1,2

SELECT * FROM starbase_players