block_timestamp,

tx_hash,

tx_signer,

receipt_object_id,

regexp_substr(status_value, 'Success') as reg_success,

receiver_id,

logs

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

),

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,

try_parse_json(value) as parse_logs,

parse_logs:type as type,