Donation check

datavortexDonation check

Updated 2024-12-31

WITH all_donations AS (

SELECT

transfer.tx_from AS from_owner,

transfer.tx_to AS to_owner,

tags.name,

SUM(transfer.amount / 1e6) 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

UNION ALL

SELECT 'cvvhDhkZqq2x8NwkQkxWpnUCbJe63qK9ZVpKw9Syc4R', '八爷'

UNION ALL

SELECT 'E1ByeBwfWSJ6Y4DPtoh54zePXsxkWD9MNkTa9PhvF1eg', '猫博士'

UNION ALL

SELECT '8Uy8iKXD6DunGWELyqMDn1ARZCpandy2NDb23MU6Phgf', '七爷'

UNION ALL

SELECT 'BRAtk5fLdRZdU581MzGUbWpd2jwPad9tpwTpZyG5kHuF', 'Dragon 龙哥'

UNION ALL

SELECT 'F34pqaCHZJNe5QBD7AuKADieYqTue6XyGPgaErAE9voB', '内盘哥'

UNION ALL

SELECT '3RpA8nPsCNTGh2UReCoq9dwDhmXM5kXCjAMNZH1UKm43', '李屌毛大神'

UNION ALL

SELECT 'E9CXsf9L8VYTdxgccXXMQTvqeQbHuKmeY5kE5A34i7UH', '123olp'

UNION ALL

SELECT 'ECuQUe43rucFHLfyy2C2CoZ4BmHoqP2xmxCdVAaVoWEP', '0xES E神'

UNION ALL

SELECT 'BDuPckk4HUCSDcTAhi6ivHPUYibSiWXBJ7GPn8ZwSAG', '@CBTTTi Usher'

UNION ALL

SELECT '2xeEwaHRMtARqG87oRzUsYLofKbGoBpNHkzt4MwqXsei', '番薯'

) 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

QueryRunArchived: QueryRun has been archived

flipside