cloudr3nNumber of Services
    Updated 2024-05-30
    select
    sum(service_count) as total_services
    from (
    select
    count(*) as service_count
    from
    ethereum.core.ez_decoded_event_logs
    where
    1=1
    and event_name='Transfer'
    and contract_address='0x48b6af7b12c71f09e2fc8af4855de4ff54e775ca'
    and decoded_log:from='0x0000000000000000000000000000000000000000'

    union all

    select
    count(*) as service_count
    from
    polygon.core.ez_decoded_event_logs
    where
    1=1
    and event_name='Transfer'
    and contract_address='0xe3607b00e75f6405248323a9417ff6b39b244b50'
    and decoded_log:from='0x0000000000000000000000000000000000000000'

    union all

    select
    count(*) as service_count
    from
    gnosis.core.ez_decoded_event_logs
    where
    1=1
    and event_name='Transfer'
    and contract_address='0x9338b5153ae39bb89f50468e608ed9d764b755fd'
    and decoded_log:from='0x0000000000000000000000000000000000000000'
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived