SELECT '0x903e2f5d42ee23156d548dd46bb84b7873789e44' AS godmode

), transfers AS (

SELECT

*

FROM ethereum.core.ez_nft_transfers

WHERE NFT_ADDRESS=(SELECT godmode FROM variables)

), last_transfers AS(

SELECT

t1.*

FROM transfers t1

LEFT OUTER JOIN transfers t2

ON (

t1.TOKENID = t2.TOKENID

AND t1.BLOCK_TIMESTAMP < t2.BLOCK_TIMESTAMP

)

WHERE t2.TOKENID IS NULL

), transfers_data AS (

SELECT

TOKENID,

COUNT(EVENT_INDEX) AS transfers,

MAX(BLOCK_TIMESTAMP) AS last_transfer,

MAX(EVENT_INDEX) AS last_event

FROM ethereum.core.ez_nft_transfers

WHERE NFT_ADDRESS=(SELECT godmode FROM variables)

GROUP BY TOKENID

), main AS (

SELECT

t1.TOKENID,

t1.BLOCK_TIMESTAMP,

t1.TX_HASH,

t1.NFT_TO_ADDRESS AS current_owner

FROM last_transfers t1

LEFT OUTER JOIN last_transfers t2

ON (

t1.TOKENID = t2.TOKENID