Query editor
withunlisted_tokens AS (SELECT * FROM query_3806957),blacklist_tokens AS (SELECT * FROM query_3806980),pairs AS (SELECTtoken0, token1,CAST(token0 AS varchar) || '_' || CAST(token1 AS varchar) AS native_pair,LEAST(CAST(token0 AS varchar), CAST(token1 AS varchar)) || '_' || GREATEST(CAST(token0 AS varchar), CAST(token1 AS varchar)) AS pair_alpha,LEAST(e0.symbol, e1.symbol) || '_' || GREATEST(e0.symbol, e1.symbol) AS pair_alpha_symbolFROM basevelocimeter_base.CarbonController_evt_PairCreated coLEFT JOIN (SELECTt.contract_address,t.decimals,t.symbolFROM tokens.erc20 tLEFT JOIN blacklist_tokens fk ON t.contract_address = fk.contract_addressWHERE blockchain = 'base' AND fk.contract_address IS NULLUNION ALLSELECTut.contract_address,ut.decimals,ut.symbolFROM unlisted_tokens utLEFT JOIN blacklist_tokens fk ON ut.contract_address = fk.contract_addressWHERE fk.contract_address IS NULL) e0 ON e0.contract_address = co.token0LEFT JOIN (SELECTt.contract_address,t.decimals,t.symbolFROM tokens.erc20 tLEFT JOIN blacklist_tokens fk ON t.contract_address = fk.contract_addressWHERE blockchain = 'base' AND fk.contract_address IS NULLUNION ALLSELECTut.contract_address,ut.decimals,ut.symbolFROM unlisted_tokens utLEFT JOIN blacklist_tokens fk ON ut.contract_address = fk.contract_addressWHERE fk.contract_address IS NULL) e1 ON e1.contract_address = co.token1),created AS (SELECT *FROM basevelocimeter_base.CarbonController_evt_StrategyCreated),updated AS (SELECT *FROM basevelocimeter_base.CarbonController_evt_StrategyUpdated),