Query editor
SELECTMAX(call_block_time) AS "date",_account AS "address",GET_HREF(CONCAT(CAST('https://basescan.org/' AS VARCHAR),CAST('address/' AS VARCHAR),CAST(TRY_CAST(_account AS VARCHAR) AS VARCHAR)),CONCAT(CAST(SUBSTRING(TRY_CAST(_account AS VARCHAR), 1, 5) AS VARCHAR),CAST('...' AS VARCHAR),CAST(SUBSTRING(TRY_CAST(_account AS VARCHAR), LENGTH(TRY_CAST(_account AS VARCHAR)) - (4 - 1)) AS VARCHAR))) AS address_linkFROM cbbtc_base.FiatTokenV2_1_call_blacklistGROUP BY_accountORDER BYdate DESC