MLDZMNpools
Updated 2024-08-28
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
›
⌄
-- withdraw_commission update_client set_withdraw_address lava_provider_reported lava_delegator_claim_rewards lava_relay_payment
-- lava_unbond_from_provider lava_provider_reported lava_provider_latest_block_report lava_stake_update_provider lava_stake_new_provider lava_delegate_to_provider lava_provider_unstake_commit
-- select
-- *
-- from lava.core_testnet.fact_msg_attributes
-- where tx_id = 'BD0FC5FF4563A2AEC27477BD51A7E976ABBC17B004D83B6F2B9B73C21EA94986'
-- -- group by 1
-- -- order by 1 desc
-- limit 100
--distinct ATTRIBUTE_KEY
select *
--distinct ATTRIBUTE_VALUE
from lava.core_testnet.fact_msg_attributes
where MSG_TYPE = 'lava_provider_latest_block_report'
and ATTRIBUTE_KEY = 'NEAR'
and ATTRIBUTE_VALUE = 126777363
order by INSERTED_TIMESTAMP desc
limit 100
-- and ATTRIBUTE_KEY ilike '%NEAR%'
-- and ATTRIBUTE_VALUE ilike '%126705194%'
--where tx_id = 'BDD1AA4DDFF5BC5C9E6782639DDB8EC2AE6C5DAB46B7CAC100C736032844605D'
QueryRunArchived: QueryRun has been archived