Sandeshpolygon contracts deplyed
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 polygon contracts deplyed @ https://flipsidecrypto.xyz/edit/queries/486eaeb2-5163-4dae-8319-d7acc366c1e0
-- forked from polygon contracts deplyed copya @ https://flipsidecrypto.xyz/edit/queries/597af6ed-a854-47af-b411-837334417703
-- forked from polygon contracts deplyed @ https://flipsidecrypto.xyz/edit/queries/fd1f8526-d915-4ca3-b93e-fdbafe8ec8a5
-- forked from polygon 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 polygon_data AS
(
with hlg_contracts_polygon as
(
select address from polygon.core.dim_contracts
where creator_address in (
lower('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55')
-- lower('0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')
)
)
select
contract_address as contract,
topics[3] as tokenId
from polygon.core.fact_event_logs
where 1=1
and contract_address in (select distinct address from hlg_contracts_polygon)
and topics[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND topics[1] = '0x0000000000000000000000000000000000000000000000000000000000000000'
and topics[3] is not null
and tx_hash not in
(
select distinct tx_hash from polygon.core.fact_decoded_event_logs
where event_name='FinishedOperatorJob'
)
QueryRunArchived: QueryRun has been archived