WITH EditionCounts AS (

SELECT

EVENT_DATA:editionID::STRING AS "EditionID",

COUNT(*) AS "EditionCount",

EVENT_DATA:renderID AS "Shape"

FROM

flow.core.fact_events

WHERE

EVENT_CONTRACT = 'A.edf9df96c92f4595.Pinnacle'

AND EVENT_TYPE = 'PinNFTMinted'

AND "Shape" ILIKE 'OEV1-PRIN%'

GROUP BY

EVENT_DATA:editionID::STRING,

EVENT_DATA:renderID

),

Shapes AS (

SELECT

EVENT_DATA:id::STRING AS "ID",

2023 AS "seriesID",

EVENT_DATA:renderID AS "Shape",

EVENT_DATA:variant AS "Variant",

EVENT_DATA:isChaser AS "Chaser",

EVENT_DATA:setID AS "SetID"

FROM

flow.core.fact_events

WHERE

EVENT_CONTRACT = 'A.edf9df96c92f4595.Pinnacle'

AND EVENT_TYPE = 'EditionCreated'

),

Sets AS (