flipside

    Sci-hub
    datavortexSci-hub
    Updated 2025-01-10
    WITH all_donations AS (
    SELECT
    transfer.tx_from AS from_owner,
    transfer.tx_to AS to_owner,
    tags.name,
    SUM(transfer.amount) AS transfer_amount,
    COUNT(DISTINCT transfer.tx_id) AS donate_count
    FROM
    solana.core.fact_transfers AS transfer
    LEFT JOIN (
    SELECT
    '2ZiQY2u9bNxLF3fDhUFmZCz1n1baNnx2jtu1asPYpMhR' AS address,
    '0xAA' AS name
    ) AS tags ON transfer.tx_from = tags.address
    WHERE
    transfer.tx_to = 'Cfy5rFwmU2fe43YbR79F1Nsm1REZ9DurQ3aoKhP6ANgt'
    AND transfer.mint = 'GxdTh6udNstGmLLk9ztBb6bkrms7oLbrJp5yzUaVpump'
    GROUP BY
    transfer.tx_from,
    transfer.tx_to,
    tags.name
    )
    SELECT
    COUNT(
    DISTINCT CASE
    WHEN transfer_amount > 1 THEN from_owner
    END
    ) AS unique_address,
    SUM(
    CASE
    WHEN transfer_amount > 1 THEN transfer_amount
    ELSE 0
    END
    ) AS total_donation_raised,
    SUM(donate_count) AS total_donation_count
    FROM
    QueryRunArchived: QueryRun has been archived