WITH DomainMints AS (

-- Polygon Chain

SELECT

block_timestamp,

tx_hash,

'polygon' AS chain,

decoded_log:domainName AS Name,

TO_TIMESTAMP(decoded_log:expiry) AS expiry_date,

decoded_log:owner AS Owner

FROM polygon.core.ez_decoded_event_logs

WHERE contract_address = '0x8ccd9c0a9c084412416a85fd748c7f1e9b86442d'

AND block_timestamp >= '2024-05-31'

AND event_name = 'MintedDomain'

UNION ALL

-- BSC Chain

SELECT

block_timestamp,

tx_hash,

'bsc' AS chain,

decoded_log:domainName AS Name,

TO_TIMESTAMP(decoded_log:expiry) AS expiry_date,

decoded_log:owner AS Owner

FROM bsc.core.ez_decoded_event_logs

WHERE contract_address = '0x7e2cf06f092c9f5cf5972ef021635b6c8e1c5bb2'

AND block_timestamp >= '2024-04-30'

AND event_name = 'MintedDomain'

UNION ALL

-- Blast Chain

SELECT

block_timestamp,