-- forked from Top Minter @ https://flipsidecrypto.xyz/edit/queries/9361e18f-165f-4a6a-ad13-fcc89503f23a

WITH mints AS (

SELECT

tx_id

FROM flow.core.fact_events

WHERE (event_contract LIKE '%A.ca63ce22f0d6bdba.Cryptoys%'

and event_data:metadata like '%Mickey and Friends: Volume I%'

AND event_type = 'Minted'

AND tx_succeeded = 'true')

),

minters AS (

SELECT

MIN(block_timestamp) AS date,

event_data:to minter,

COUNT(DISTINCT event_data:id) AS NFTs

FROM flow.core.fact_events

JOIN mints USING (tx_id)

WHERE event_type = 'Deposit'

GROUP BY 2

SELECT

minter,

NFTs

FROM minters

ORDER BY NFTs DESC

LIMIT 10;