Query editor
withcurrent_roi AS (SELECTLEAST(e0.symbol, e1.symbol) || '_' || GREATEST(e0.symbol, e1.symbol) AS pair,co.id as strategyid,'https://dune.com/queries/3572450?strategyId_t6c1ea=' || CAST(co.id AS varchar) AS destination_text,get_href(get_chain_explorer_address('fantom', co.owner), cast(co.owner as varchar)) AS owner,qroi.ROI/100 AS ROIFROM graphene_fantom.CarbonController_evt_StrategyCreated coLEFT JOIN query_3572457 qroi ON qroi.id = co.idLEFT JOIN tokens.erc20 e0 ON e0.contract_address = co.token0LEFT JOIN tokens.erc20 e1 ON e1.contract_address = co.token1WHERE e0.blockchain = 'fantom' AND e1.blockchain = 'fantom')SELECTpair,get_href(destination_text, CAST(strategyid AS varchar)) AS strategyid,owner, ROIFROM current_roiORDER BY ROI DESC