Advertisement
retryW_

Bistamp to Bitso #2 96604252 txs

Apr 1st, 2019
2,720
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.53 KB | None | 0 0
  1. SELECT
  2.   CAST(t.AmountXRP / 1000000 AS INT64) AS AmountXRP,
  3.   COUNT(*) AS COUNT
  4. FROM
  5.   xrpledgerdata.fullhistory.transactions t
  6. JOIN
  7.   xrpledgerdata.fullhistory.ledgers l
  8. ON
  9.   t.LedgerIndex = l.LedgerIndex
  10. WHERE
  11.   t.Account = 'rDsbeomae4FXwgQTJp9Rs64Qg9vDiTCdBv'
  12.   AND
  13.   t.AmountXRP IS NOT NULL
  14.   AND
  15.   t.TransactionType = 'Payment'
  16.   AND
  17.   t.Destination = 'rLSn6Z3T8uCxbcd1oxwfGQN1Fdn5CyGujK'
  18.   AND
  19.   t.DestinationTag = 96604252
  20.   AND
  21.   t.TransactionResult = 'tesSUCCESS'
  22. GROUP BY
  23.   AmountXRP
  24. ORDER BY
  25.   COUNT DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement