(

select

fs.REDELEGATE_SOURCE_VALIDATOR_ADDRESS as source,

dl.label as labels,

count(distinct fs.tx_id) as redelgates

from osmosis.core.fact_staking fs

inner join osmosis.core.dim_labels dl

on dl.address=fs.REDELEGATE_SOURCE_VALIDATOR_ADDRESS

where

action='redelegate'

and

fs.block_timestamp > current_date - interval '3 months'

group by source, labels

order by redelgates desc

limit 5

),

gainers as

(

select

fs.VALIDATOR_ADDRESS as destination,

dl.label as labels,

count(distinct fs.tx_id) as redelgates

from osmosis.core.fact_staking fs

inner join osmosis.core.dim_labels dl

on dl.address=fs.VALIDATOR_ADDRESS

where

action='redelegate'

and

fs.block_timestamp > current_date - interval '3 months'

group by destination, labels

order by redelgates desc

limit 5

),