with f_events as (

select

event_data,

event_contract,

event_type,

tx_id,

block_timestamp,

tx_succeeded

from

flow.core.fact_events

where

block_timestamp >= '2023-01-01 17:00:00.000'

),

sets as (

SELECT

DISTINCT EVENT_DATA:id :: STRING AS "ID",

EVENT_DATA:editionType AS "Edition Type",

EVENT_DATA:name AS "Set Name",

EVENT_DATA:renderID AS "RenderID",

CASE

WHEN EVENT_DATA:seriesID :: STRING = 1 THEN '2023'

WHEN EVENT_DATA:seriesID :: STRING = 2 THEN '2024'

ELSE EVENT_DATA:seriesID :: STRING

END AS "Series Name"

FROM

f_events

WHERE

EVENT_CONTRACT = 'A.edf9df96c92f4595.Pinnacle'

and EVENT_TYPE = 'SetCreated'

),

mints as (

select

x.tx_id,

x.block_timestamp,