distinct pool_id[0] as pool,

count(distinct tx_id) as actions,

count(distinct LIQUIDITY_PROVIDER_ADDRESS) as users

from osmosis.core.fact_liquidity_provider_actions

where ACTION in ('pool_joined')

and LIQUIDITY_PROVIDER_ADDRESS in (

select

DISTINCT LIQUIDITY_PROVIDER_ADDRESS AS exitors

from osmosis.core.fact_liquidity_provider_actions where ACTION in ('pool_exited')

and POOL_ID[0]='872'

) and block_timestamp>='2023-01-23'

group by 1

having users>1

order by 3 desc