BT4042024-04-04 02:52 PM
Updated 2024-04-23
999
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
›
⌄
WITH all_seed_nft AS (
with seed_nft as (
SELECT
tx_hash AS in_TX_HASH,
FROM_ADDRESS AS in_ua,
block_timestamp AS in_BLOCK_TIMESTAMP
FROM
ethereum.core.fact_transactions
WHERE
to_address = '0x00000000fe898dae93619d020f1826333e1cfb85'
AND ORIGIN_FUNCTION_SIGNATURE = '0xa22cb465'
AND substr(input_data, 75, 64) = '0000000000000000000000000000000000000000000000000000000000000001'
AND substr(input_data, 11, 64) = '00000000000000000000000027374086a3ed6d926326956da4dcd8109a753189'
AND STATUS = 'SUCCESS'
),
Unseed_nft AS (
SELECT
tx_hash AS out_TX_HASH,
FROM_ADDRESS AS out_ua,
block_timestamp AS out_BLOCK_TIMESTAMP
FROM
ethereum.core.fact_transactions
WHERE
to_address = '0x00000000fe898dae93619d020f1826333e1cfb85'
AND ORIGIN_FUNCTION_SIGNATURE = '0xa22cb465'
AND substr(input_data, 75, 64) = '0000000000000000000000000000000000000000000000000000000000000000'
AND substr(input_data, 11, 64) = '00000000000000000000000027374086a3ed6d926326956da4dcd8109a753189'
AND STATUS = 'SUCCESS'
),
seed_unseed_ranks AS (
SELECT
seed_nft.in_TX_HASH,
seed_nft.in_ua,
seed_nft.in_BLOCK_TIMESTAMP,
Unseed_nft.out_TX_HASH,
Unseed_nft.out_ua,
QueryRunArchived: QueryRun has been archived