ZSaed0.2 empty bolck_id
Updated 2023-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- forked from 1bd7fb58-dd06-46db-9c20-f984a0e72b1d
-- forked from 5ad5befe-a1f1-4197-abcc-53555a241656
with clean as (select a.* from near.social.fact_addkey_events a
INNER JOIN near.core.fact_transactions b on a.tx_hash = b.tx_hash and b.tx_status = 'Success'
)
, null_data as (
select *
from clean
where BLOCK_TIMESTAMP is null
)
select * from null_data
where BLOCK_ID in (select DISTINCT BLOCK_ID from near.core.fact_blocks)
Run a query to Download Data