select sum(asset_usd) as total_rewards,count (tx_id) as Payment_frequency, to_address ,bond_type
from thorchain.bond_actions
where BOND_TYPE = 'bond_reward'
-- and to_address in (select node_address from thorchain.new_node_events)
group by 3,4
order by total_rewards DESC limit 10