SELECT

ft.block_timestamp,

el.origin_from_address AS minter,

el.origin_to_address,

el.tx_hash,

TRY_CAST(

CASE

WHEN TRY_CAST(utils.udf_hex_to_int(SUBSTR(topic_3, -40, 40)) AS DECIMAL(38,0)) <= 888

THEN utils.udf_hex_to_int(SUBSTR(topic_3, -40, 40))

ELSE NULL

END

AS DECIMAL(38,0)) AS tokenID

FROM monad.testnet.fact_event_logs el

INNER JOIN monad.testnet.fact_traces ft

ON el.tx_hash = ft.tx_hash

WHERE contract_address = LOWER('0x2FC49a061b8ec3615b5cd1806bf287909069c5Be')

AND TX_SUCCEEDED = 'TRUE'

AND EVENT_REMOVED = 'FALSE'

,base2 AS (

SELECT

tx_hash,

COUNT(CASE WHEN tokenID IS NOT NULL THEN 1 END) AS tokenID_count,

COUNT(CASE WHEN tokenID IS NULL THEN 1 END) AS null_tokenID_count

FROM base

GROUP BY tx_hash

,base3 AS (

select *

from base2

where null_tokenID_count > tokenID_count