pool_ids[0] as pool_id,

COUNT(DISTINCT TRADER) as users

FROM osmosis.core.fact_swaps

WHERE not pool_ids[0] = 1

GROUP BY pool_id

Order by users desc

LIMIT 10