WITH starbase_player AS (

player_profile

,starbase_player

FROM $query('62a2c594-afe5-4164-9a14-81fb22953bdc')

,last_value AS (

*

FROM $query('6a2519e0-27f9-4633-8fe0-8934f60d6bb2')

,crafting_fee AS (

select

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

,player_profile

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

then 'MRZ_1'

when instruction:accounts[1] = 'mAfGxchko6ZU8bRpVHQHXjfYEGBsPwmzGWxUuo4csCa'

then 'MRZ_10'

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

then 'MRZ_11'

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

then 'MRZ_12'

when instruction:accounts[1] = 'HnZX2YXwK8KZJVjAECprALtvZWhKNg9HDSzDikiQwN1M'

then 'MRZ_13'

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

then 'MRZ_14'