SELECT
    transaction, concat("https://tracker.icon.foundation/transaction/0x", hash), CAST(UNHEX(SUBSTR(data, 3)) AS CHAR(500000))
FROM
    iconation.transaction_message
        JOIN
    iconation.transaction
WHERE
    iconation.transaction_message.transaction = iconation.transaction.id
ORDER BY transaction DESC