pool_name,

count(*)

FROM thorchain.liquidity_actions

WHERE lp_action = 'add_liquidity'

AND from_address IN (SELECT from_address FROM (select from_address, count (*) FROM thorchain.liquidity_actions WHERE lp_action = 'add_liquidity'

AND from_address is NOT NULL GROUP BY 1 ORDER BY 2 DESC

LIMIT 20))

GROUP BY 1

ORDER BY 2 DESC