SELECT '0x903e2f5d42ee23156d548dd46bb84b7873789e44' AS godmode

), mints AS (

SELECT

TOKENID AS ID,

NFT_TO_ADDRESS AS summoner,

TX_HASH AS txn,

NFT_ADDRESS

FROM ethereum.core.ez_nft_mints

WHERE NFT_ADDRESS=(SELECT godmode FROM variables)

), metadata AS (

SELECT

mints.ID,

mints.summoner,

md.TOKEN_METADATA,

md.IMAGE_URL

FROM mints

LEFT JOIN (

SELECT

CONTRACT_ADDRESS,

TOKEN_METADATA,

TOKEN_ID,

IMAGE_URL

FROM flipside_prod_db.ethereum.nft_metadata

) md

ON md.TOKEN_ID=mints.ID

AND md.CONTRACT_ADDRESS=(SELECT godmode FROM variables)

SELECT * FROM metadata

ORDER BY CAST(ID AS INT) ASC