MLDZMNCog10
Updated 2023-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with tb1 as (select
raw_metadata[0]:"account_address" as validators
from osmosis.core.dim_labels
where label_subtype ilike 'validator')
select
voter,
count (distinct tx_id) as no_votes
from osmosis.core.fact_governance_votes
where TX_SUCCEEDED = 'TRUE'
and voter not in (select validators from tb1)
group by 1
order by 2 DESC
limit 10
Run a query to Download Data