(select

a.BLOCK_TIMESTAMP AS "Time",

TRIM(REGEXP_REPLACE(TRY_HEX_DECODE_STRING(SUBSTR(a.DATA, 129, 144)), '[\x00-\x1F]', '')) AS "Minted .nad domain",

a.ORIGIN_FROM_ADDRESS as "Mitner",

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

a.tx_hash as "Tx hash" ,

LENGTH("Minted .nad domain") AS lengh,

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(DISTINCT FROM_ADDRESS) as addresses,

case when FROM_ADDRESS in (SELECT DISTINCT

"Mitner" from mints)

then '.nom name minters' else 'Other addresses' end as type

from monad.testnet.fact_transactions

group by all