WITH mine_stakers AS (SELECT event_attributes:"from"::string as address
FROM terra.msg_events
WHERE event_attributes:"1_contract_address" = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp'
or event_attributes:"0_contract_address" = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp')
SELECT validator_address, COUNT(DISTINCT delegator_address) as num_stakers
FROM terra.staking
WHERE delegator_address IN (SELECT address FROM mine_stakers)
GROUP BY validator_address
ORDER BY num_stakers DESC