dao_voters.sql

SELECT
  REPLACE(d.logs.topics,'000000000000000000000000','') AS [voter],
  BOOLEAN(REPLACE(d.logs.topics,'000000000000000000000000','') != [c.a.from]) AS proxy_vote,
  INTEGER(FLOAT(c.a.logs.topics)) AS prop,
  d.vote AS vote,
  d.blocknumber,
  d.timestamp,
  c.a.hash,
  [c.a.from] AS [from]
FROM (
  SELECT
    a.hash,
    [a.from],
    a.logs.topics,
    a.logs.data,
    b.logs.topics
  FROM (
    SELECT
      hash,
      [from],
      INTEGER(FLOAT(logs.topics)),
      logs.topics,
      CAST(CASE WHEN TO_BASE64(logs.data)='AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=' THEN 'yes' WHEN TO_BASE64(logs.data)='AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAE=' THEN 'no' ELSE logs.data END AS string) AS vote
    FROM ( FLATTEN((
          SELECT
            hash,
            [from],
            logs.topics,
            logs.data
          FROM ( FLATTEN((
                SELECT
                  hash,
                  [from],
                  logs.topics,
                  logs.data
                FROM
                  [etherquery:ethereum.transactions]
                WHERE
                  logs.address='0xbb9bc244d798123fde783fcc1c72d3bb8c189413'), logs.topics) ) ), logs.data) )) AS a
  JOIN (
    SELECT
      hash,
      [from],
      INTEGER(FLOAT(logs.topics)),
      logs.topics,
      CAST(CASE WHEN TO_BASE64(logs.data)='AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=' THEN 'yes' WHEN TO_BASE64(logs.data)='AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAE=' THEN 'no' ELSE logs.data END AS string) AS vote
    FROM ( FLATTEN((
          SELECT
            hash,
            [from],
            logs.topics,
            logs.data
          FROM ( FLATTEN((
                SELECT
                  hash,
                  [from],
                  logs.topics,
                  logs.data
                FROM
                  [etherquery:ethereum.transactions]
                WHERE
                  logs.address='0xbb9bc244d798123fde783fcc1c72d3bb8c189413'), logs.topics) ) ), logs.data) )) AS b
  ON
    a.hash=b.hash
  WHERE
    b.logs.topics='0x86abfce99b7dd908bec0169288797f85049ec73cbe046ed9de818fab3a497ae0'
    AND b.logs.topics!=a.logs.topics ) c
JOIN (
  SELECT
    hash,
    blocknumber,
    timestamp,
    [from],
    INTEGER(FLOAT(logs.topics)),
    logs.topics,
    CAST(CASE WHEN TO_BASE64(logs.data)='AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=' THEN 'No' WHEN TO_BASE64(logs.data)='AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAE=' THEN 'Yes' ELSE logs.data END AS string) AS vote
  FROM ( FLATTEN((
        SELECT
          hash,
          blocknumber,
          timestamp,
          [from],
          logs.topics,
          logs.data
        FROM ( FLATTEN((
              SELECT
                hash,
                blocknumber,
                timestamp,
                [from],
                logs.topics,
                logs.data
              FROM
                [etherquery:ethereum.transactions]
              WHERE
                logs.address='0xbb9bc244d798123fde783fcc1c72d3bb8c189413'), logs.topics) ) ), logs.data) )) AS d
ON
  c.a.hash=d.hash
WHERE
  1=1
  AND c.a.logs.topics!=d.logs.topics
  AND c.b.logs.topics!=d.logs.topics
  AND c.a.logs.topics CONTAINS '0000000000000000000000000000000000000000000000000000000'