with mints as (

select

tx_hash

,block_timestamp

,topics

,data

,REGEXP_SUBSTR_ALL(SUBSTRING(data, 3), '.{64}') as parsed_data

,livequery.utils.udf_hex_to_int(parsed_data[0])::varchar as token_id

,livequery.utils.udf_hex_to_int(parsed_data[1])::int as quantity

,concat('0x', right(topic_3, 40)) as minter_address

from ronin.core.fact_event_logs

where 1=1

and block_timestamp > '2025-03-28 17:56:00'

and contract_address = '0xf6fe00893eea4d47f0cba303ef518fe4ab1c9dd6'

and topic_0 = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'

and origin_function_signature = '0x731133e9'

and tx_succeeded = 'TRUE'

--and tx_hash = '0x748c8dd3141b076823d9ffd708e9bfae941d1bfdf9258d9e502763ff04182c5b' --token_id 4 mint, the first token that was minted after 1, 2, 3 and the potions

select

count(distinct minter_address) as minters

,count(tx_hash) as mints

from mints

--where minter_address not in ('0x0000000000000000000000000000000000000000')