Query editor
withpairs 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_alphaFROM basevelocimeter_base.CarbonController_evt_PairCreated),created AS (SELECT *FROM basevelocimeter_base.CarbonController_evt_StrategyCreated),updated as (SELECT *FROM basevelocimeter_base.CarbonController_evt_StrategyUpdated),deleted AS (SELECT *FROM basevelocimeter_base.CarbonController_evt_StrategyDeleted),clean_updated AS (SELECT updated.*FROM updatedJOIN (SELECT id, MAX(evt_block_number) AS max_bnFROM updatedWHERE updated.id NOT IN (SELECT id FROM deleted)GROUP BY id) t ON (updated.id = t.id) AND (updated.evt_block_number = t.max_bn)),clean_created AS (SELECT *FROM createdWHERE (created.id NOT IN (SELECT id FROM deleted))AND (created.id NOT IN (SELECT id FROM updated))),current_orders1 AS (SELECTid, order0, order1, token0, token1,LEAST(CAST(token0 AS varchar), CAST(token1 as varchar)) || '_' || GREATEST(CAST(token0 as varchar), CAST(token1 as varchar)) AS pair_alpha --evt_tx_hash, evt_block_time, evt_block_number,FROM clean_updatedUNION ALLSELECTid, order0, order1, token0, token1,LEAST(CAST(token0 AS varchar), CAST(token1 as varchar)) || '_' || GREATEST(CAST(token0 as varchar), CAST(token1 as varchar)) AS pair_alpha --evt_tx_hash, evt_block_time, evt_block_number,FROM clean_created),current_orders2 AS (SELECT curr.id, curr.order0, curr.order1, curr.token0, curr.token1, pair_alpha, ownerFROM current_orders1 currLEFT JOIN created c ON c.id = curr.id),