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}}'