(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 PROJECT_NAME, COUNT(*) PROJECT_TX_COUNT

FROM all_nft

JOIN nft_address

ON nft_address.ADDRESS = all_nft.CONTRACT_ADDRESS

GROUP BY 1

ORDER BY 2 DESC

LIMIT 20