SELECT DISTINCT contract_address

FROM monad.testnet.fact_event_logs

WHERE topic_0 IN (

'0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62', -- TransferSingle

'0x4a39dc06d4c0dbc64b70b5eb2aa10c99d1887e3f0adf967c6fbbfb89c4a79e11' -- TransferBatch

)

),

decoded_mints AS (

SELECT

'0x' || SUBSTR(topics[2], 27) AS to_address,

'0x' || SUBSTR(topics[1], 27) AS from_address,

l.contract_address AS contract_address,

ethereum.public.udf_hex_to_int(topics[3]) AS token_id,

ethereum.public.udf_hex_to_int(l.data) AS amount, -- ERC-1155 includes amount in `data`

l.block_timestamp AS block_timestamp,

l.tx_hash AS tx_hash,

l.event_index AS event_index

FROM monad.testnet.fact_event_logs l

WHERE '0x' || SUBSTR(topics[1], 27) IN ('0x0000000000000000000000000000000000000001',

'0x0000000000000000000000000000000000000000')

AND l.contract_address IN (SELECT contract_address FROM erc1155_contracts)

SELECT

contract_address,

COUNT(DISTINCT from_address) AS total_minters,

COUNT(DISTINCT tx_hash) AS total_mints,

SUM(amount) AS total_minted_tokens

FROM decoded_mints

GROUP BY contract_address

ORDER BY total_mints DESC;