SPORTPASSearly-ivory
Updated 2024-09-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select * from flow.core.fact_events
WHERE
event_contract = 'A.8f9231920da9af6d.AFLPack'
and
event_type in (
'HashedPackPurchasedDetails', -- buyer, packHash, packID, pricePaid, settledOnChain, individualPackTemplateId,
'HashedPackOpened', -- nftId, packHash, packID, receiptAddress
'PackAdminMintedPackContents' -- moments, packHash, receiptAddress
)
--AND
-- event_data:packID = '34313'
AND
(event_data:receiptAddress =
'0xfa71348aa08544c8'
OR
event_data:buyer =
'0xfa71348aa08544c8'
)
QueryRunArchived: QueryRun has been archived