receiver_id as validator,

count(distinct a.tx_hash) as stakes_count

from near.core.fact_receipts a,

lateral flatten(input => logs) c

join near.core.fact_transactions b

where c.value ilike '%contract total staked balance is%'

and a.tx_hash = b.tx_hash

group by validator

order by stakes_count desc

limit 20