instruction:accounts[0] as wallet

,instruction:accounts[1] as player_profile

,instruction:accounts[3] as mining_fleets

from solana.core.fact_events fe, lateral flatten(input => inner_instruction:instructions)

WHERE program_id IN ('SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')

AND instruction:accounts[18] = 'MineMBxARiRdMh7s1wdStSK4Ns3YfnLjBfvF5ZCnzuw'

AND instruction:accounts[1] >= 'D0000000000000000000000000000000000000000000'

AND instruction:accounts[1] < 'H0000000000000000000000000000000000000000000'

AND succeeded = 'true'

AND block_timestamp > current_date-30 AND block_timestamp < current_date

GROUP BY 1,2,3

,mining AS(

select

date_trunc('day', block_timestamp::date) as date

,m.player_profile

,m.mining_fleets

,case when instruction:accounts[6] = '98E4PDEwAYFCNcdbt5EL7JYMj5Rqpd4BkMRsDuYBaytF'

then 'MRZ_1'

when instruction:accounts[6] = 'mAfGxchko6ZU8bRpVHQHXjfYEGBsPwmzGWxUuo4csCa'

then 'MRZ_10'

when instruction:accounts[6] = '6nuTqwN5pPaF7KrPg6A82HigwwzuXPA4hRomfvmQyY8t'

then 'MRZ_11'

when instruction:accounts[6] = '4a1ZvTYdSxo688PNqVwWHzmnoLkm2Hw246DGwxRw8PTE'

then 'MRZ_12'

when instruction:accounts[6] = 'HnZX2YXwK8KZJVjAECprALtvZWhKNg9HDSzDikiQwN1M'

then 'MRZ_13'

when instruction:accounts[6] = '5yWdAS3mLbtVC9XZyRkntEn2n5ESkTQHdxccR7rYU9hT'

then 'MRZ_14'