chainlabs2024-04-29 03:03 PM
Updated 2024-04-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with megadm_1 as (
SELECT distinct
f.value:address::string as address,
'Mega Darknet Market (Russian)' as entity
from (
SELECT
parse_json(livequery.live.udf_api('https://ipfs.io/ipfs/QmNTcZYH2i59dDCAqZMLCXaoTLi1L8PFHfUJbhW5qDge3q')) as response
),
lateral flatten(input => response:data) as f
),
megadm_2 as (
SELECT distinct
f.value:address::string as address,
'Mega Darknet Market (Russian)' as entity
from (
SELECT
parse_json(livequery.live.udf_api('https://ipfs.io/ipfs/QmfS6dAogow7GFsMv4xf3n2AjXoTtkdNGZkCFEdGxjHcoj')) as response
),
lateral flatten(input => response:data) as f
)
select * from megadm_2
QueryRunArchived: QueryRun has been archived