(SELECT addr, min(block_timestamp) as time_ from

(SELECT *, parse_json(concat(concat('{',tx:receipt[1]:outcome:logs[0]),'}')):EVENT_JSON:data[0]:new_owner_id as addr from

(SELECT * from

mdao_near.transactions

where tx_receiver = 'aurora' and tx_signer = 'relay.aurora'

)

where contains(tx:receipt[1]:outcome:logs[0], ':') and parse_json(concat(concat('{',tx:receipt[1]:outcome:logs[0]),'}')):EVENT_JSON:data[0]:old_owner_id = 'aurora' and addr is not NULL )

GROUP by 1 )

BEGIN TRY

SELECT * from time_nd_addr

END TRY

BEGIN CATCH

END CATCH

-- inner join time_nd_addr

-- on addr = tx_signer and block_timestamp > time_

LIMIT 100