SELECT

event_data:id AS nft_id,

event_data:to AS wallet_address

FROM flow.core.fact_events

WHERE event_contract = 'A.edf9df96c92f4595.Pinnacle'

AND event_type = 'Deposit'

),

Withdrawals AS (

SELECT

event_data:id AS nft_id,

event_data:from AS wallet_address

FROM flow.core.fact_events

WHERE event_contract = 'A.edf9df96c92f4595.Pinnacle'

AND event_type = 'Withdraw'

),

Minted AS (

SELECT

event_data:id AS nft_id,

event_data:editionID AS edition_id

FROM flow.core.fact_events

WHERE event_contract = 'A.edf9df96c92f4595.Pinnacle'

AND event_type = 'PinNFTMinted'

SELECT

d.wallet_address AS owner_wallet,

m.edition_id AS editionID,

COUNT(m.edition_id) AS quantity

FROM Deposits d

LEFT JOIN Minted m ON d.nft_id = m.nft_id

WHERE m.edition_id = '{{editionID}}' -- Correct syntax for numeric editionID

AND NOT EXISTS (

SELECT 1

FROM Withdrawals w

WHERE d.nft_id = w.nft_id