SHARE
TWEET

Untitled

a guest Oct 15th, 2019 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT sum(CONVERT(INT, CONVERT(ethBinary, ethHex, 1))) sum(CONVERT(INT, CONVERT(tokenBinary, tokenHex, 1)))
  2.         FROM public_transactions t
  3.         LEFT JOIN public_logs l ON t."hash" = l."transactionHash"
  4.         WHEN l."data" LIKE "%0xcd60aa75" THEN SUBSTRING(l."data", 43, 72) AS ethHex
  5.         WHEN l."data" LIKE "%0x7f4091b4" THEN SUBSTRING(l."data", 43, 72) AS tokenHex
  6.         WHERE t."to"=lower(?)
  7.         AND t."blockNumber" > 0
  8.         AND t."blockNumber" < ? // current block?
  9.         AND t."network"="ethereum_main"
  10.         AND r."network"="ethereum_main"
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top