, dex_other as dex

, blockchain_links.link_prefix || 'address/' || pool_other as pool

, exchanges_other as exchanges

, txs_other as txs

, volume

, pairs_other as pairs

, blockchain_links.link_prefix || 'tx/' || example_transaction as tx_hash_example

from others

left join oneinch on oneinch.pool_1inch = others.pool_other and oneinch.blockchain_1inch = others.blockchain_other

left join blockchain_links on blockchain_links.blockchain = others.blockchain_other

where oneinch.pool_1inch is null and txs_other > {{txs}} and volume > {{volume bigger than}}

order by volume desc nulls last