datavortex1:1
Updated 2025-02-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
›
⌄
⌄
/*
WITH ReceiptStatus AS (
SELECT
tx_hash,
CASE
WHEN COUNT(CASE WHEN receipt_succeeded = FALSE THEN 1 END) > 0 THEN FALSE
ELSE TRUE
END AS receipt_succeeded
FROM near.core.fact_receipts
GROUP BY tx_hash
HAVING COUNT(CASE WHEN receipt_succeeded = FALSE THEN 1 END) = 0
)
SELECT
t.block_timestamp,
t.tx_hash,
t.amount,
FROM near.core.ez_token_transfers t
JOIN ReceiptStatus r
ON t.tx_hash = r.tx_hash
WHERE
t.from_address = 'kingofjank.near'
AND t.to_address = 'marketing.v1.potfactory.potlock.near';
*/
WITH filtered_receipts AS (
SELECT
tx_hash,
block_timestamp
FROM
near.core.fact_receipts
GROUP BY
tx_hash,
block_timestamp
HAVING
COUNT(CASE WHEN receipt_succeeded = FALSE THEN 1 END) = 0
)
QueryRunArchived: QueryRun has been archived