SELECT

raw_metadata[0] :rank AS rank,

raw_metadata[0] :account_address :: STRING AS validator_address,

address,

label as validator_name,

raw_metadata[0] :delegator_shares :: NUMBER / POW(10,6) as voting_power,

raw_metadata[0] :jailed as jailed,

CASE WHEN rank <= 175 and jailed = false THEN

'TRUE'

ELSE

'FALSE'

END AS active_set

FROM osmosis.core.dim_labels

WHERE label_type = 'operator'

AND label_subtype = 'validator'

AND raw_metadata[0] :account_address :: STRING = '{{validator_address}}'

),

last_prop AS (

max(proposal_id) as last

FROM osmosis.core.fact_governance_votes

WHERE proposal_id < 600

),

last_day AS (

SELECT

max(block_timestamp :: date) as day

FROM osmosis.core.fact_governance_votes

JOIN last_prop

WHERE proposal_id = last

),

stakers AS (

SELECT

delegator_address,

COALESCE(

redelegate_source_validator_address,