Sandeshavalanche contracts deplyed copya
Updated 2024-04-15
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 avalanche contracts deplyed @ https://flipsidecrypto.xyz/edit/queries/fd1f8526-d915-4ca3-b93e-fdbafe8ec8a5
-- forked from avalanche contracts deplyed @ https://flipsidecrypto.xyz/edit/queries/c49311fd-0b39-4e03-a6ee-35b56601763d
-- forked from arbitrum contracts deplyed @ https://flipsidecrypto.xyz/edit/queries/c28286c0-f1eb-4a96-9ef4-1645443ed1b9
with avalanche_data AS
(
with hlg_contracts_avalanche as
(
select address from avalanche.core.dim_contracts
where creator_address in (
lower('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55')
-- lower('0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')
)
)
select
contract_address as contract,
topics[3] as tokenId
from avalanche.core.fact_event_logs
where 1=1
and contract_address in (select distinct address from hlg_contracts_avalanche)
and topics[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
-- AND topics[1] = '0x0000000000000000000000000000000000000000000000000000000000000000'
and topics[3] is not null
group by contract_address, tokenId
)
select count(distinct contract) as contracts, count(distinct tokenId) as tokens from avalanche_data
QueryRunArchived: QueryRun has been archived