count(DISTINCT CASE WHEN action = 'pool_joined' THEN tx_id END) as n_joined,

count(DISTINCT CASE WHEN action = 'pool_exited' THEN tx_id END) as n_exited,

n_joined+n_exited as n_actions

FROM osmosis.core.fact_liquidity_provider_actions

WHERE block_id >= 4707300 AND block_id <= 4713064

GROUP BY LIQUIDITY_PROVIDER_ADDRESS

ORDER BY n_actions DESC

LIMIT 25