Query editor
select pairName as name, case when chainId = 56 then 'bnb'when chainId = 1 then 'ethereum'when chainId = 42161 then 'arbitrum'when chainId = 8453 then 'base'when chainId = 59144 then 'linea'when chainId = 324 then 'zksync'when chainId = 1101 then 'polygon_zkevm'when chainId = 204 then 'opbnb'when "type" = 4 then 'aptos'else cast(chainId as varchar) end as chain, case when type = 0 then 'V2'when type = 1 then 'V3'when type = 2 then 'ALM'when type = 3 then 'veCAKE'when type = 4 then 'V2'else 'StableSwap'end as lp_type, case when b.fee is not null then b.fee else feeTier/1e6 end as fee_tier, address as lp_address, cast(boostMultiplier/100 as varchar) || 'x' as boost_multiplier, maxVoteCap/1e4 as emission_capfrom query_4116264 a -- pcs_gauge_listleft join query_4117343 b -- pcs_stableswap_pool_infoon a.address = b.lporder by gid