Sandeshpolygon contracts deplyed
    Updated 2024-04-15
    -- forked from polygon contracts deplyed @ https://flipsidecrypto.xyz/edit/queries/486eaeb2-5163-4dae-8319-d7acc366c1e0

    -- forked from polygon contracts deplyed copya @ https://flipsidecrypto.xyz/edit/queries/597af6ed-a854-47af-b411-837334417703

    -- forked from polygon contracts deplyed @ https://flipsidecrypto.xyz/edit/queries/fd1f8526-d915-4ca3-b93e-fdbafe8ec8a5

    -- forked from polygon contracts deplyed @ https://flipsidecrypto.xyz/edit/queries/c49311fd-0b39-4e03-a6ee-35b56601763d

    -- forked from arbitrum contracts deplyed @ https://flipsidecrypto.xyz/edit/queries/c28286c0-f1eb-4a96-9ef4-1645443ed1b9

    with polygon_data AS
    (
    with hlg_contracts_polygon as
    (
    select address from polygon.core.dim_contracts
    where creator_address in (
    lower('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55')
    -- lower('0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')
    )
    )

    select
    contract_address as contract,
    topics[3] as tokenId
    from polygon.core.fact_event_logs
    where 1=1
    and contract_address in (select distinct address from hlg_contracts_polygon)
    and topics[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    AND topics[1] = '0x0000000000000000000000000000000000000000000000000000000000000000'
    and topics[3] is not null
    and tx_hash not in
    (
    select distinct tx_hash from polygon.core.fact_decoded_event_logs
    where event_name='FinishedOperatorJob'
    )

    QueryRunArchived: QueryRun has been archived