with TX_RECEIPT AS (

block_timestamp,

tx_hash,

tx_signer, -- left joined from transactions

receipt_object_id,

regexp_substr(status_value, 'Success') as reg_success,

receiver_id,

logs

-- proof, metadata

FROM near.core.fact_receipts

LEFT JOIN (SELECT tx_signer, tx_hash as tx_hash1 FROM near.core.fact_transactions) ON tx_hash = tx_hash1

WHERE receiver_Id = 'marketplace.paras.near'

AND reg_success IS NOT NULL

-- WHERE tx_hash = 'AS5QLqtdQKz4fGZeqtBgXHhLbkA1HpVCM4fRaSoBqK5y' -- sale https://paras.id/token/x.paras.near::426086

),

logs_flatten AS (

SELECT

block_timestamp,

tx_hash,

tx_signer,

receiver_id,

seq,key,path,index,

value,

check_json(value) as checks

FROM TX_RECEIPT,

table(flatten(input => logs))

),

nft_tx_log AS (

SELECT

block_timestamp,

tx_hash,

tx_signer,

receiver_id,