saadiqProof Ecosystem Wallets
    Updated 2023-04-18
    -- forked from aabfe962-a4ce-40e1-b116-456ff8d9dcef

    SELECT
    user_address,
    sum(
    CASE
    WHEN contract_address IN ('0x08d7c0242953446436f34b4c78fe9da38c73668d') THEN current_bal_unadj
    ELSE 0
    END
    ) AS proof_count,
    CASE
    WHEN proof_count > 0 THEN 1
    ELSE 0
    END AS has_proof_pass,
    sum(
    CASE
    WHEN contract_address IN ('0x23581767a106ae21c074b2276d25e5c3e136a68b') THEN current_bal_unadj
    ELSE 0
    END
    ) AS moonbirds_count,
    CASE
    WHEN moonbirds_count > 0 THEN 1
    ELSE 0
    END AS has_moonbird,
    sum(
    CASE
    WHEN contract_address IN ('0x1792a96e5668ad7c167ab804a100ce42395ce54d') THEN current_bal_unadj
    ELSE 0
    END
    ) AS oddities_count,
    CASE
    WHEN oddities_count > 0 THEN 1
    ELSE 0
    END AS has_oddity,
    sum(
    CASE
    Run a query to Download Data