Updated 6 days ago
    SELECT
    a.TO_ADDRESS,
    COUNT(*) AS call_count
    FROM bsc.core.fact_traces as a, bsc.core.dim_contracts as b
    WHERE

    a.to_address = b.address
    and SUBSTRING(a.input, 3, 8) = '1626ba7e'
    GROUP BY a.TO_ADDRESS, a.input
    HAVING COUNT(*) > 1;
    Last run: 6 days ago
    TO_ADDRESS
    CALL_COUNT
    1
    0xad3b67bca8935cb510c8d18bd45f0b94f54a968f2
    2
    0xcd68591e4f9fa55c4a9938a5574e22517047a05514
    3
    0xc3c8a64f2fadd0a836007ef4fe3a76d62dd6759a2
    4
    0xbac849bb641841b44e965fb01a4bf5f074f84b4d2
    5
    0x970a0575a3e5a1c76493b5744b90bd0a490b08862
    6
    0x552fcecc218158fff20e505c8f3ad24f8e1dd33c5
    7
    0x69017801667545db032286167564aacb94a2a2e73
    8
    0x69017801667545db032286167564aacb94a2a2e72
    9
    0x69017801667545db032286167564aacb94a2a2e72
    10
    0x3d45adac77d310051e9a3b8aaef1c9aebdf91fd42
    11
    0x69017801667545db032286167564aacb94a2a2e73
    12
    0x6c0623f2a30821263029345dc9aad6446eb4b0252
    13
    0x3f59e7dbdb92cd40ac8bb2d49470cca1bc61b1222
    14
    0x3ad53ad1e474be52301f387716086848cef1c3352
    15
    0x6c0623f2a30821263029345dc9aad6446eb4b0252
    16
    0x62ab2e65cc872f37e72100ab209f568103e9ed462
    17
    0x3d45adac77d310051e9a3b8aaef1c9aebdf91fd42
    18
    0xe1c31f0ee585e87addf493c7b2b9aa88c533aac22
    19
    0x69017801667545db032286167564aacb94a2a2e72
    20
    0x3d45adac77d310051e9a3b8aaef1c9aebdf91fd42
    ...
    5146
    246KB
    379s