GROUP BY address),

top_ten_voting_power as

(select terra.validator_voting_power.address as validator_address, min(terra.validator_voting_power.voting_power) as power

from terra.validator_voting_power INNER join last_voting_power

on(last_voting_power.address = terra.validator_voting_power.address

and terra.validator_voting_power.block_timestamp = last_voting_power.Last_Power )

group by validator_address )

select terra.validator_labels.label as name ,top_ten_voting_power.power as voting_power from terra.validator_labels

INNER join top_ten_voting_power

on(top_ten_voting_power.validator_address = terra.validator_labels.vp_address )

GROUP BY name, voting_power ORDER BY voting_power DESC limit 10