allyPOAP Users
    Updated 2023-06-16
    SELECT DISTINCT
    from_address AS user,
    'POAP' AS project_name,
    'Credential' AS category,
    'Gnosis' AS chain
    FROM gnosis.core.fact_transactions
    WHERE to_address like LOWER('0x22C1f6050E56d2876009903609a2cC3fEf83B415')
    union all
    SELECT DISTINCT
    from_address AS user,
    'POAP' AS project_name,
    'Credential' AS category,
    'BSC' AS chain
    FROM bsc.core.fact_transactions
    WHERE to_address like LOWER('0x22C1f6050E56d2876009903609a2cC3fEf83B415')
    union all
    SELECT DISTINCT
    from_address AS user,
    'POAP' AS project_name,
    'Credential' AS category,
    'Ethereum' AS chain
    FROM ethereum.core.fact_transactions
    WHERE to_address like LOWER('0x22C1f6050E56d2876009903609a2cC3fEf83B415')
    union all
    SELECT DISTINCT
    from_address AS user,
    'POAP' AS project_name,
    'Credential' AS category,
    'Arbitrum' AS chain
    FROM arbitrum.core.fact_transactions
    WHERE to_address like LOWER('0x22C1f6050E56d2876009903609a2cC3fEf83B415')
    union all
    SELECT DISTINCT
    from_address AS user,
    'POAP' AS project_name,
    'Credential' AS category,