select redelegate_source_validator_address as validator_address

from osmosis.core.fact_staking

where 1 = 1

and redelegate_source_validator_address is not null

and currency = 'uosmo'

and tx_status = 'SUCCEEDED'

and block_timestamp::date >= current_date - {{ days }}

group by redelegate_source_validator_address

union

select validator_address

from osmosis.core.fact_staking

where 1 = 1

and redelegate_source_validator_address is null

and currency = 'uosmo'

and tx_status = 'SUCCEEDED'

and block_timestamp::date >= current_date - {{ days }}

group by validator_address

select

count(distinct(validator_address)) as total_unique_validators

from list