FROM osmosis.core.fact_transactions as a JOIN osmosis.core.fact_liquidity_provider_actions as b

on a.tx_id = b.tx_id

WHERE a.tx_id IN (

select DISTINCT tx_id

FROM osmosis.core.fact_msgs

WHERE block_id BETWEEN 4707300 AND 4713064

AND msg_type = 'pool_joined'

) AND

b.amount > 0

GROUP BY a.tx_from