kamilclFactory Contract callers
    Updated 2025-02-10
    -- who called the contract?

    SELECT -- Added DISTINCT to avoid duplicates
    DISTINCT FROM_ADDRESS,
    lab.ADDRESS_NAME,
    lab.LABEL_TYPE,
    lab.LABEL_SUBTYPE,
    lab.LABEL
    FROM ethereum.core.ez_decoded_traces tr
    JOIN ethereum.core.dim_contracts d
    ON d.CREATED_TX_HASH = tr.TX_HASH
    JOIN ethereum.core.dim_labels AS lab
    ON lab.ADDRESS = FROM_ADDRESS
    WHERE TO_ADDRESS = '0xffa397285ce46fb78c588a9e993286aac68c37cd'
    AND TYPE = 'CALL'
    AND IDENTIFIER = 'CALL_ORIGIN'
    AND TRACE_STATUS = 'SUCCESS'
    AND FUNCTION_NAME = 'createForwarder'
    QueryRunArchived: QueryRun has been archived