group by node_address

order by sum(slash_points) desc

limit 10)

,reasons as (select count(*),reason from thorchain.slash_points where node_address in (select node_address from top10nodes)

group by reason)

,earned as (select sum(asset_e8),node_address from thorchain.slash_amounts inner join thorchain.slash_points

on thorchain.slash_points.block_id=thorchain.slash_amounts.block_id

where asset like '%.RUNE%' or asset like '%USD%'

group by node_address

having sum(asset_e8)<0

order by sum(asset_e8))

select distinct reason from thorchain.slash_points