from sei.core.fact_msg_attributes

where attribute_value = 'sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc'

and attribute_key = 'collection'

and block_timestamp::date >= '2023-12-29'

and tx_id in (select tx_id from sei.core.fact_msg_attributes

where attribute_value = 'mint'

and attribute_key = 'action'

and block_timestamp::date >= '2023-12-29'))

,

nfts as (select block_timestamp,

tx_id,

attribute_value as nft

from sei.core.fact_msg_attributes

where tx_id in (select tx_id from hash)

and block_timestamp::date >= '2023-12-29'

and attribute_key = 'token_id'

,

final as (select DISTINCT nft,

a.block_timestamp,

a.tx_id,

attribute_value as user

from sei.core.fact_msg_attributes a join nfts b on a.tx_id = b.tx_id

where attribute_key = 'fee_payer'

and a.block_timestamp::date >= '2023-12-29'

select nft,

block_timestamp,

tx_id,

from final

order by CAST(nft AS INTEGER) ASC

limit 9001