Flipside TeamContracts deployed per network base
Updated 2024-09-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Contracts deployed per network base @ https://flipsidecrypto.xyz/edit/queries/5ff19dfc-e6da-4dfa-9d2b-52c7f8136a7a
-- forked from Contracts deployed per network base @ https://flipsidecrypto.xyz/edit/queries/2babb871-6db4-44c7-9c32-b2adb3190794
-- forked from Contracts deployed per network base @ https://flipsidecrypto.xyz/edit/queries/bac28de0-6c0c-4986-b1e8-a90d00b4abf8
-- forked from Contracts deployed per network base @ https://flipsidecrypto.xyz/edit/queries/fb270bd3-702b-45a1-9893-f3e8cea24b48
-- forked from Contracts deployed per network base @ https://flipsidecrypto.xyz/edit/queries/c04175ad-ac6f-4caa-82be-e6c2413bc73c
-- forked from Contracts deployed per network base @ https://flipsidecrypto.xyz/edit/queries/deecc66a-4f8d-4e18-b65e-306f8ce16ab7
with hlg_contracts_base as
(
select
CONTRACT_ADDRESS as address
from base.core.fact_event_logs
where 1=1
and origin_to_address in
('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55',
'0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')
and CONTRACT_ADDRESS not in
('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55',
'0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')
group by contract_address
),
NFTs_table as (
select
contract_address as contract,
topics[3] as tokenId
from base.core.fact_event_logs
where 1=1
and contract_address in (select distinct address from hlg_contracts_base)
QueryRunArchived: QueryRun has been archived