mintOwners as (

select

created_at_timestamp as block_timestamp,

'MINTED',

substr(token_id,1,12) AS tokenID,

token_metadata:additional_metadata:minter::string as minter

from

terra.nft_metadata

,

allNFTs as (

select msg_value:execute_msg:mint_nft:token_id::string AS tokenid,

substr(msg_value:execute_msg:mint_nft:token_id::string,1,12) AS truncTokenID

from terra.msgs

where msg_value:contract::string = 'terra16wuzgsx3tz4hkqu73q5s7unxenefkkvefvewsh'

and tx_status = 'SUCCEEDED'

and msg_value:execute_msg:mint_nft is not null

)

,

transfer_nfts AS (

select block_timestamp,

tx_id,

substr(msg_value:execute_msg:transfer_nft:token_id::string,1,12) AS TokenID,

msg_value:execute_msg:transfer_nft:recipient::string AS owner

from terra.msgs

where msg_value:contract::string = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k'

and msg_value:execute_msg:transfer_nft is not null

and tx_status = 'SUCCEEDED'

UNION

select block_timestamp,

tx_id,

substr(msg_value:execute_msg:ledger_proxy:msg:transfer_nft:token_id::string,1,12) AS TokenID,