with wealth_distribution as(
select to_address as address, sum(rune_amount) as balance from thorchain.transfers
group by address
)
select case when position('-', pool_name, 1) = 0 then pool_name else
substr(pool_name, 1, position('-', pool_name, 1) - 1) end as pool_name, count(distinct from_address) as number_of_lpers, sum(rune_amount_usd+asset_amount_usd) as amount_usd from thorchain.liquidity_actions
where from_address in (select address from wealth_distribution where balance > 10000)
and lp_action = 'add_liquidity'
group by pool_name
order by number_of_lpers desc