Query editor
withfluid_blockchains as (select *from "query_5044493"), fluid_dexes as (select *-- from "query_6157381"from dune."0xfluid".result_fluid_dexes), tokens_native as (select *from "query_5825281"), manual_pricing as (select *from "query_5169345"), dex_tokens_subset as (selecttoken0 as contract_address, blockchain, symbol0 as symbol, decimals0 as decimalsfrom fluid_dexesunionselecttoken1 as contract_address, blockchain, symbol1 as symbol, decimals1 as decimalsfrom fluid_dexes), dex_tokens as (selectt.contract_address as token, t.blockchain, t.symbol, t.decimals, t.contract_address as price_token, t.blockchain as price_blockchain, t.decimals as price_decimalsfrom dex_tokens_subset as tleft join manual_pricing as mpon t.contract_address = mp.tokenand t.blockchain = mp.blockchainwhere t.contract_address <> 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeand t.blockchain in (select blockchain from fluid_blockchains)and mp.token is nullunion allselect0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee as token