search

Giveth / giveth-dapps-v2

This project is the aggregation of GIVeconomy and Giveth.io DApps in a single repo
https://staging.giveth.io
GNU General Public License v3.0
61 stars 34 forks source link

Export a CSV of all verified projects that have an Arbitrum address on their Giveth profile (v4) #4614

Open koday1 opened 3 weeks ago

koday1 commented 3 weeks ago

This is a duplicate issue for checking the progress of our Arbitrum bounty program (# of verified Giveth projects that add an Arbitrum address to their profile).

@mohammadranjbarz can you do another export of the list of verified projects that have an ARB address on their profile? The query you used is on this issue: https://github.com/Giveth/giveth-dapps-v2/issues/4509

mohammadranjbarz commented 2 weeks ago

Query

SELECT 
    pa."createdAt" as "walletAddressAddedTime",
    pa."projectId",
    pa.address,
    'https://giveth.io/project/' || p.slug AS "givethLink"
FROM 
    project_address pa
JOIN 
    project p ON pa."projectId" = p.id
WHERE 
    pa."networkId" = 42161 AND pa."isRecipient" = true AND p.verified = true AND p."statusId" = 5
ORDER BY 
    pa."createdAt" ASC;

Response

projects_with_Arbitrum_address_25_aug_2024.csv