pool_names AS (

SELECT

column1 AS pool_id

, column2 AS pool_name

FROM (VALUES

(1, 'ATOM/OSMO')

, (2, 'ION/OSMO')

, (3, 'AKT/OSMO')

, (4, 'AKT/ATOM')

, (5, 'DVPN/OSMO')

, (6, 'ATOM/DVPN')

, (7, 'IRIS/OSMO')

, (8, 'ATOM/IRIS')

, (9, 'CRO/OSMO')

, (10, 'ATOM/CRO')

, (13, 'ATOM/XPRT')

, (15, 'XPRT/OSMO')

, (22, 'REGEN/ATOM')

, (42, 'REGEN/OSMO')

, (151, 'ATOM/ION')

, (183, 'ATOM/IOV')

, (197, 'IOV/OSMO')

, (461, 'NGM/EEUR')

, (463, 'NGM/OSMO')

, (464, 'NGM/ATOM')

, (481, 'EEUR/OSMO')

, (482, 'ATOM/EEUR')

, (497, 'JUNO/OSMO')

, (498, 'ATOM/JUNO')

, (547, 'ATOM/TICK')

, (548, 'REGEN/EEUR')

, (553, 'LIKE/OSMO')

, (555, 'ATOM/LIKE')