SELECT

tokenid,

nft_to_address AS wallet

FROM

base.nft.ez_nft_transfers

WHERE

nft_address = LOWER('0x82ab03ec6244293bdc02f6c4555b72d3246513d8')

QUALIFY ROW_NUMBER() OVER (

PARTITION BY tokenid

ORDER BY block_timestamp DESC

) = 1

),

nft_holders_stat AS (

SELECT

wallet,

COUNT(*) AS holds

FROM

nft_holders

WHERE

wallet <> '0x0000000000000000000000000000000000000000'

GROUP BY wallet

),

base_sln_holders AS (

SELECT

sln_in.wallet AS wallet,

COALESCE(sln_in.amount, 0) - COALESCE(sln_out.amount, 0) AS sln

FROM

(

SELECT

to_address AS wallet,

SUM(amount) AS amount

FROM base.core.ez_token_transfers

WHERE contract_address = LOWER('0xef0b105b4f2ce61d2a7ae62d03b1f4cb6c4fbeec')

GROUP BY to_address

) sln_in