with

edition_mints as (

select distinct

instruction :accounts[3] as merkle_tree,

instruction :accounts[8] ::string as collection_mint

from solana.core.fact_events events

where succeeded

and date(block_timestamp) >= '2023-03-01'

and program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY' -- Bubblegum

and signers[0] = '4WCBsTL4fHpg8qCt1wxoqRzgj2CZepdpmS5NaaoxPUJh'

and signers[1] = 'EevH3LPRexR2431NSF6bCpBbPdQ2ViHbM1p84zujiEUs' -- Collection Authority

and instruction :accounts[8] not in (

'2DcGXgxpyWWS7ktztLS1TefCQUoVkSjxNeoe4V1ndivN' -- Dialect Genesis Mint Test (DGMT)

)

),

leaf_transfers as (

select

events.block_timestamp,

events.tx_id,

events.instruction :accounts[1] ::string as leaf_owner,

events.instruction :accounts[3] ::string as new_leaf_owner,

events.instruction :accounts[4] ::string as merkle_tree

from solana.core.fact_events events

inner join solana.core.fact_transactions txs

using(tx_id, block_timestamp, block_id, succeeded)

inner join edition_mints