Skip to content

Instantly share code, notes, and snippets.

@p-s-dev

p-s-dev/dao_multiple_transfer_single_transaction.sql

Created July 8, 2016 13:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save p-s-dev/3f188eed00a4c111438d0adbc0fff1a5 to your computer and use it in GitHub Desktop.
Save p-s-dev/3f188eed00a4c111438d0adbc0fff1a5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dao_multiple_transfer_single_transaction.sql
SELECT
to
FROM
[etherquery:ethereum.transactions]
WHERE
hash IN (
SELECT
hash
FROM
[etherquery:ethereum.transactions]
WHERE
logs.address='0xbb9bc244d798123fde783fcc1c72d3bb8c189413'
AND logs.topics='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- transfer
GROUP BY
hash
HAVING
COUNT(logs.topics)>2
ORDER BY
hash)
GROUP BY
to
LIMIT
1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment