Get the last 100 MINA transactions

last-100-transactions.sql

SELECT transactions.amount,
       transactions.fee,
       transactions.`from`,
       transactions.`to`,
       transactions.`hash`,
       transactions.id,
       transactions.isdelegation,
       transactions.memo,
       transactions.nonce,
       transactions.`datetime`,
       transactions.blockstatehash,
       transactions.blockheight
FROM (
         SELECT transactions.amount,
                transactions.fee,
                transactions.`from`,
                transactions.`to`,
                transactions.`hash`,
                transactions.id,
                transactions.isdelegation,
                transactions.memo,
                transactions.nonce,
                transactions.`datetime`,
                transactions.blockstatehash,
                transactions.blockheight
         FROM minaexplorer.archive.transactions
         WHERE `to` = 'B62qk9WYHu2PBYv4EyEubnVQURcwpiV2ysuYYoMdwi8YTnwZQ7H4bLM'
           AND canonical = true
           AND failurereason is Null
         UNION ALL
         SELECT transactions.amount,
                transactions.fee,
                transactions.`from`,
                transactions.`to`,
                transactions.`hash`,
                transactions.id,
                transactions.isdelegation,
                transactions.memo,
                transactions.nonce,
                transactions.`datetime`,
                transactions.blockstatehash,
                transactions.blockheight
         FROM minaexplorer.archive.transactions
         WHERE `from` = 'B62qk9WYHu2PBYv4EyEubnVQURcwpiV2ysuYYoMdwi8YTnwZQ7H4bLM'
           AND canonical = true
           AND failurereason is Null
     ) transactions
ORDER BY datetime DESC,
         nonce DESC
LIMIT 100