SELECT signers[0] as voter,

block_timestamp::date as fecha,

ARRAY_SIZE(inner_instructions) as votes

from solana.fact_transactions

where instructions[0]:accounts[6] = 'BD9XQhU1DXA9V4GLdgTq7xdQY5UBnShfq4caTSEL9Lr'

and succeeded = 'TRUE'

and instructions[0]:programId = 'Daovoteq2Y28gJyme6TNUXT9TxXrePiouFuHezkiozci'

and instructions[0]:data = 'Yjf5DvKUCfa2Rh5YBEg7FM'

),

VOTERS_SELLERS as (

select block_timestamp::date as fecha,

tx_from,

concat_ws('#', 'SMB', token_id) as SMB_id,

md.mint

from solana.dim_nft_metadata md

left join solana.fact_transfers ft

on md.mint = ft.mint

where contract_address = ('9uBX3ASjxWvNBAD1xjbVaKA74mWGZys3RGSF7DdeDD3F') --contract_name = ('Solana Monkey Business')

and md.mint is not null

and tx_from in (select voter from NO_VOTERS)

and fecha > '2022-03-04'

select min(fecha) as fecha_oferta,

tx_from as seller,

--vs.mint,

SMB_id,

purchaser,

ns.block_timestamp::date as fecha_compra,

sales_amount

from VOTERS_SELLERS vs

inner join solana.fact_nft_sales ns

on vs.mint = ns.mint