DISTINCT l.pool_id[0] as pool_id,

assets

FROM osmosis.core.fact_liquidity_provider_actions l

LEFT OUTER JOIN osmosis.core.dim_liquidity_pools p

ON l.pool_id[0] = p.pool_id

WHERE liquidity_provider_address = '{{address}}'