mad_lads_addresses as (

select distinct l.address

from solana.core.dim_labels l

where

l.label = 'mad lads'

, mad_lads_mint_base as (

select

n.block_timestamp

, n.tx_id

, n.mint

from solana.core.fact_nft_mints n

where

n.mint in (select mla.address from mad_lads_addresses mla)

and n.succeeded

, mad_lads_mint as (

select

m.block_timestamp

, m.tx_id

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

, m.mint

from mad_lads_mint_base m

inner join (

select

t.tx_id

, t.signers

from solana.core.fact_transactions t

where

date(t.block_timestamp) between date('2023-04-19') and date('2023-04-21')

and t.succeeded

) t on t.tx_id = m.tx_id