SELECT

pool_ids as pool_id,

MAX(from_currency) as from_currency2,

MIN(from_currency) as to_currency2,

CASE

WHEN MAX(from_currency) = 'uosmo' THEN 'OSMO'

WHEN MAX(from_currency) = 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2' THEN 'ATOM'

WHEN MAX(from_currency) = 'ibc/8A34AF0C1943FD0DFCDE9ADBF0B2C9959C45E87E6088EA2FC6ADACD59261B8A2' THEN 'LUM'

WHEN MAX(from_currency) = 'ibc/9712DBB13B9631EDFA9BF61B55F1B2D290B2ADB67E3A4EB3A875F3B6081B3B84' THEN 'DVPN'

WHEN MAX(from_currency) = 'ibc/0EF15DF2F02480ADE0BB6E85D9EBB5DAEA2836D3860E9F97F9AADE4F57A31AA0' THEN 'LUNC'

WHEN MAX(from_currency) = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858' THEN 'USDC'

WHEN MAX(from_currency) = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A' THEN 'EVMOS'

WHEN MAX(from_currency) = 'ibc/BE1BB42D4BE3C30D50B68D7C41DB4DFCE9678E8EF8C539F6E6A9345048894FCC' THEN 'USTC'

WHEN MAX(from_currency) = 'ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4' THEN 'STARS'

WHEN MAX(from_currency) = 'ibc/E6931F78057F7CC5DA0FD6CEF82FF39373A6E0452BF1FD76910B93292CF356C1' THEN 'CRO'

WHEN MAX(from_currency) = 'ibc/8318FD63C42203D16DDCAF49FE10E8590669B3219A3E87676AC9DA50722687FB' THEN 'EROWAN'

WHEN MAX(from_currency) = 'ibc/46B44899322F3CD854D2D46DEEF881958467CDD4B3B10086DA49296BBED94BED' THEN 'JUNO'

WHEN MAX(from_currency) = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A' THEN 'SCRT'

WHEN MAX(from_currency) = 'ibc/A0CC0CF735BFB30E730C70019D4218A1244FF383503FF7579C9201AB93CA9293' THEN 'XPRT'

WHEN MAX(from_currency) = 'ibc/3BCCC93AD5DF58D11A6F8A05FA8BC801CBA0BA61A981F57E91B8B598BF8061CB' THEN 'MED'

WHEN MAX(from_currency) = 'ibc/EA3E1640F9B1532AB129A571203A0B9F789A7F14BB66E350DCBFA18E1A1931F0' THEN 'CMDX'

WHEN MAX(from_currency) = 'ibc/67795E528DF67C5606FC20F824EA39A6EF55BA133F4DC79C90A8C47A0901E17C' THEN 'UMEE'

WHEN MAX(from_currency) = 'ibc/EA4C0A9F72E2CEDF10D0E7A9A6A22954DB3444910DB5BE980DF59B05A46DAD1C' THEN 'DSM'

WHEN MAX(from_currency) = 'ibc/0CD3A0285E1341859B5E86B6AB7682F023D03E97607CCC1DC95706411D866DF7' THEN 'DAI'

WHEN MAX(from_currency) = 'ibc/5973C068568365FFF40DEDCF1A1CB7582B6116B731CD31A12231AE25E20B871F' THEN 'EEUR'

WHEN MAX(from_currency) = 'ibc/9F9B07EF9AD291167CF5700628145DE1DEB777C2CFC7907553B24446515F6D0E' THEN 'USDC.grv'

WHEN MAX(from_currency) = 'ibc/4E5444C35610CC76FC94E7F7886B93121175C28262DDFDDE6F84E82BF2425452' THEN 'BTSG'

WHEN MAX(from_currency) = 'ibc/1DCC8A6CB5689018431323953344A9F6CC4D0BFB261E88C9F7777372C10CD076' THEN 'REGEN'

WHEN MAX(from_currency) = 'ibc/CBA34207E969623D95D057D9B11B0C8B32B89A71F170577D982FDDE623813FFC' THEN 'MNTL'

WHEN MAX(from_currency) = 'uion' THEN 'ION'

WHEN MAX(from_currency) = 'ibc/297C64CC42B5A8D8F82FE2EBE208A6FE8F94B86037FA28C4529A23701C228F7A' THEN 'NETA'

WHEN MAX(from_currency) = 'ibc/41999DF04D9441DAC0DF5D8291DF4333FBCBA810FFD63FDCE34FDF41EF37B6F7' THEN 'CRBRUS'

WHEN MAX(from_currency) = 'ibc/1DC495FCEFDA068A3820F903EDBD78B942FBD204D7E93D3BA2B432E9669D1A59' THEN 'NGM'

WHEN MAX(from_currency) = 'ibc/1480B8FD20AD5FCAE81EA87584D269547DD4D436843C1D20F15E00EB64743EF4' THEN 'AKT'

WHEN MAX(from_currency) = 'ibc/655BCEF3CDEBE32863FF281DBBE3B06160339E9897DC9C9C9821932A5F8BA6F8' THEN 'TICK'