Query editor
withunlisted_tokens AS (SELECT * FROM query_3806957),blacklist_tokens AS (SELECT * FROM query_3806980),pairs_legacy AS (SELECTevt_block_time AS block_time,evt_tx_hash AS tx_hash,token0,token1, pairId,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_alphaFROM basevelocimeter_base.CarbonController_evt_PairCreated),created AS (SELECTevt_block_time AS block_time,evt_tx_hash AS tx_hash,evt_block_number AS block_number,owner, token0, token1, id, order0, order1FROM basevelocimeter_base.CarbonController_evt_StrategyCreated),updated AS (SELECTevt_block_time AS block_time,evt_tx_hash AS tx_hash,evt_block_number AS block_number,token0, token1, id, order0, order1,reasonFROM basevelocimeter_base.CarbonController_evt_StrategyUpdated),deleted AS (SELECTevt_block_time AS block_time,evt_tx_hash AS tx_hash,evt_block_number AS block_number,owner, token0, token1, id, order0, order1FROM basevelocimeter_base.CarbonController_evt_StrategyDeleted),clean_created AS (SELECT *FROM createdWHERE (created.id NOT IN (SELECT id FROM deleted)) AND (created.id NOT IN (SELECT id FROM updated))),clean_updated AS (SELECT updated.*FROM updatedJOIN (SELECT id,MAX(block_number) AS max_bnFROM updatedWHERE updated.id NOT IN (SELECT id FROM deleted)GROUP BY id) j ON (updated.id = j.id) AND (updated.block_number = j.max_bn)),current_orders1 AS (