Query editor
SELECTcex_name,blockchain,distinct_name,CASEWHEN blockchain = 'bitcoin' THEN address -- bitcoin addresses are stored as text-like varbinary, handle belowELSE CONCAT('0x', LOWER(to_hex(address)))END AS address_hex_attempt,added_by,added_dateFROM cex.addressesWHERE cex_name IN ('Binance','Binance US','Bybit','Bitget','Gate.io','Gate','Gate_io','MEXC','mexc','KuCoin','kucoin','Crypto.com','Crypto_com','Bitfinex','bitfinex','BingX','Kraken','kraken','BitMart','LBank','Bitstamp','YoBit','Bitunix','CoinEx','Biconomy','DigiFinex','Bitkan','Phemex','CEX.IO')ORDER BY cex_name, blockchain