SELECT block_timestamp, tx_hash,

origin_from_Address AS user,

REGEXP_SUBSTR_ALL(SUBSTR(data, 3), '.{64}') AS segmented,

TO_NUMBER(livequery.utils.udf_hex_to_int(segmented[1]::STRING), 38, 0) / 1e18 AS Amount,

TO_NUMBER(livequery.utils.udf_hex_to_int(segmented[2]::STRING), 38, 0) / 1e18 AS AmountUsd,

TO_TIMESTAMP(livequery.utils.udf_hex_to_int(segmented[3]::STRING)) AS expires,

livequery.utils.udf_hex_to_string(segmented[5]::STRING) AS Name_Registered

FROM ronin.core.fact_event_logs

WHERE origin_to_address = '0x662852853614cbbb5d04bf2e29955b97e3c50b69'

AND contract_address = '0x662852853614cbbb5d04bf2e29955b97e3c50b69'

AND tx_succeeded = 1

AND topic_0 = '0x8b0e0cd1a643dbca06e60f7e03e5ff3c4e72b78e1c9842b5c3a29ad3ce8d384b'

),

UserMintCounts AS (

SELECT

user,

COUNT(DISTINCT Tx_hash) AS num_minted_names

FROM roninEns

GROUP BY user

SELECT *

FROM UserMintCounts

ORDER BY num_minted_names desc

limit 100