Query editor
WITHunlisted_tokens AS (SELECT * FROM query_3807040),blacklist_tokens AS (SELECT * FROM query_3807042),erc20 AS (SELECT contract_address, symbol, decimalsFROM (SELECT DISTINCT t.contract_address, t.symbol, t.decimalsFROM tokens.erc20 tLEFT JOIN blacklist_tokens fk ON t.contract_address = fk.contract_addressWHERE blockchain = 'fantom' AND fk.contract_address IS NULLUNIONSELECT ut.contract_address, ut.symbol, ut.decimalsFROM unlisted_tokens utLEFT JOIN blacklist_tokens fk ON ut.contract_address = fk.contract_addressWHERE fk.contract_address IS NULL)),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 graphene_fantom.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 graphene_fantom.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 graphene_fantom.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 graphene_fantom.CarbonController_evt_StrategyDeleted),clean_created AS (SELECT *