select tx_from,

min (block_timestamp) as mindate

from osmosis.core.fact_transactions

group by 1)

select pool_id[0]::string as Pool_Number,

case when pool_number = '1' then 'ATOM / OSMO'

when pool_number = '497' then 'JUNO / OSMO'

when pool_number = '562' then 'LUNC / USTC'

when pool_number = '722' then 'EVMOS / OSMO'

when pool_number = '10' then 'ATOM / CRO'

when pool_number = '604' then 'STARS / OSMO'

when pool_number = '560' then 'USTC / OSMO'

when pool_number = '611' then 'ATOM / STARS'

when pool_number = '561' then 'LUNC / OSMO'

when pool_number = '498' then 'ATOM / JUNO'

else pool_number end as pool_name,

count (*) as Countt

from osmosis.core.fact_liquidity_provider_actions t1 join mintable t2 on t1.liquidity_provider_address = t2.tx_from and t1.block_timestamp = t2.mindate

group by 1,2

order by 3 DESC

limit 10