(SELECT ADDRESS, PROJECT_NAME

FROM polygon.core.dim_labels

WHERE LABEL_TYPE = 'nft' AND BLOCKCHAIN = 'polygon' AND LABEL_SUBTYPE = 'token_contract'),

all_nft AS

(SELECT *

FROM

(SELECT DATE_TRUNC('days', BLOCK_TIMESTAMP) "DAY", EVENT_INPUTS:to RECEIVER,

TX_ID, CONTRACT_NAME, CONTRACT_ADDRESS, TX_FROM_ADDRESS, TX_TO_ADDRESS,

CASE WHEN EVENT_INPUTS:from = '0x0000000000000000000000000000000000000000' THEN 'mint' ELSE 'transfer' END AS TYPE,

EVENT_INPUTS

FROM flipside_prod_db.polygon.events_emitted

WHERE 1=1

AND TX_SUCCEEDED = TRUE

AND EVENT_INPUTS:tokenId IS NOT NULL

AND EVENT_NAME = 'Transfer')

WHERE TYPE = 'transfer' AND TX_FROM_ADDRESS = RECEIVER AND (CONTRACT_ADDRESS<>RECEIVER OR CONTRACT_ADDRESS<>TX_FROM_ADDRESS)

)

SELECT RECEIVER AS WALLET, PROJECT_NAME, COUNT(*) PROJECT_TX_COUNT, SUM(COUNT(*)) OVER(PARTITION BY RECEIVER) ALL_TX_COUNT

FROM all_nft

JOIN nft_address

ON nft_address.ADDRESS = all_nft.CONTRACT_ADDRESS

WHERE RECEIVER NOT IN (SELECT ADDRESS FROM polygon.core.dim_labels)

AND RECEIVER <> '0x54ce08dbcee53af8c3e2dc159402d3ee687507d9' -- deployer address

GROUP BY 1, 2

ORDER BY 4 DESC

LIMIT 10