from terra.msgs

where msg_value:execute_msg:send:contract::string = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' and msg_value:contract::string = 'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' and tx_status = 'SUCCEEDED'

group by 1),

unstake as (select msg_value:sender::string as staker, sum(msg_value:execute_msg:withdraw_voting_tokens:amount/1e6) as unstake

from terra.msgs

where msg_value:execute_msg:withdraw_voting_tokens is not null and msg_value:contract::string = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' and tx_status = 'SUCCEEDED'

group by 1),

final as (select a.staker, a.stake, b.unstake, (a.stake - b.unstake) as Current_MINE_Staked

from stake a

join unstake b on a.staker = b.staker

having current_mine_staked >= 100

order by 4 desc

limit 10),

luna as (select delegator_address, sum(event_amount) as stake_Luna, validator_address_label as validator

from terra.staking

where action = 'delegate' and tx_status = 'SUCCEEDED' and delegator_address in (select staker from final)

group by 1,3),

finalz as (select a.staker, a.current_mine_staked, b.stake_luna, b.validator

from final a

join luna b on a.staker = b.delegator_address)

select validator, count (distinct staker) as staker_count, sum(stake_luna) as Luna_staked

from finalz

where validator is not null

group by 1

order by 3 desc

limit 25