okb_addresses as (

select distinct l.address

from solana.core.dim_labels l

where

l.label = 'okay bears'

, okb_mint_base as (

select

n.block_timestamp

, n.tx_id

, n.mint

from solana.core.fact_nft_mints n

where

n.mint in (select okb.address from okb_addresses okb)

and n.succeeded

, okb_mint as (

select

m.block_timestamp

, m.tx_id

, cast(t.signers[0] as string) as tx_to

, m.mint

from okb_mint_base m

inner join (

select

t.tx_id

, t.signers

from solana.core.fact_transactions t

where

date(t.block_timestamp) between date('2022-04-24') and date('2022-04-26')

and t.succeeded

) t on t.tx_id = m.tx_id