WITH mints as

(select

a.BLOCK_TIMESTAMP ,

a.ORIGIN_FROM_ADDRESS as "Mitner",

ethereum.public.udf_hex_to_int(b.topics[3]) as "Token id",

a.tx_hash as "Tx hash"

from monad.testnet.fact_event_logs a

join monad.testnet.fact_event_logs b on a.tx_hash = b.tx_hash

WHERE -- a.tx_hash = '0x7eaa7ba024fd1a07d3148aa7c1aa1e35ec9550c816f3d90f498d22741d4cca7b' and

a.CONTRACT_ADDRESS = '0x3019bf1dfb84e5b46ca9d0eec37de08a59a41308' and

a.TOPICS[0] = '0xcee7d9f7ea527be6fd2ad58f0621348b614e640f77b4e69c5546e2a68ac4db20'

and a.ORIGIN_FUNCTION_SIGNATURE = '0xadba7a51'

and a.TX_SUCCEEDED = 'TRUE'

and b.CONTRACT_ADDRESS = '0x3019bf1dfb84e5b46ca9d0eec37de08a59a41308' and

b.TOPICS[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

and b.ORIGIN_FUNCTION_SIGNATURE = '0xadba7a51')

SELECT

count("Token id") as mints,

count(DISTINCT "Mitner") as "Minters"

from mints