Salehcontracts -type
    Updated 2025-04-30
    select top 10
    contract_address
    ,case
    when CONTRACT_ADDRESS='0x637e22a1ebbca50ea2d34027c238317fd10003eb' then 'MUSD'
    when CONTRACT_ADDRESS='0x7ec27d448c6437b4dc3561b3b33512680a179c3f' then 'tBTC'
    when CONTRACT_ADDRESS='0xd374631405613990d62984a08663a28248678975' then 'TroveManager'
    when CONTRACT_ADDRESS='0x20faea18b6a1d0fcdbccfffe3d164314744baf30' then 'BorrowerOperations'
    when CONTRACT_ADDRESS='0xb1dc6a437a2b96ac3ae61db110fe5be43deb09ad' then 'ActivePool'
    when CONTRACT_ADDRESS='0xd54700ad42fc49a829dcd3c377ad7b9ed176656a' then 'SortedTroves'
    when CONTRACT_ADDRESS='0x5eaa741552d6af40c7bf46467eaf79eea08eea9f' then 'WBTC'
    when CONTRACT_ADDRESS='0xd68308efbe8330a7bf58276edef51d91316e90b4' then 'USDT'
    when CONTRACT_ADDRESS='0xf08085ed33c0619113ee706fdb4b1b2c96137bee' then 'USDC'
    when CONTRACT_ADDRESS='0xf08085ed33c0619113ee706fdb4b1b2c96137bee' then 'USDC'
    when CONTRACT_ADDRESS='0xac10cd8486f92fa55d9549203fb7fdf6afdc5a77' then 'DefaultPool'
    else CONTRACT_ADDRESS
    end as "Contract Name"
    ,count(distinct tx_hash) as Calls
    from mezo.testnet.fact_event_logs
    where TX_SUCCEEDED
    and CONTRACT_ADDRESS not in('0x9c55214751472788a06797d88f38af1e79eee018','0xd6626dcca8aa760b227e02b2391aaaecf9371c5d')
    group by 1,2
    order by Calls desc



    Last run: 22 days ago
    CONTRACT_ADDRESS
    Contract Name
    CALLS
    1
    0x637e22a1ebbca50ea2d34027c238317fd10003ebMUSD91805
    2
    0x7ec27d448c6437b4dc3561b3b33512680a179c3ftBTC89879
    3
    0x5eaa741552d6af40c7bf46467eaf79eea08eea9fWBTC73857
    4
    0xd68308efbe8330a7bf58276edef51d91316e90b4USDT49299
    5
    0xf08085ed33c0619113ee706fdb4b1b2c96137beeUSDC41100
    6
    0xd54700ad42fc49a829dcd3c377ad7b9ed176656aSortedTroves24848
    7
    0xb1dc6a437a2b96ac3ae61db110fe5be43deb09adActivePool24848
    8
    0x20faea18b6a1d0fcdbccfffe3d164314744baf30BorrowerOperations24848
    9
    0xd374631405613990d62984a08663a28248678975TroveManager24848
    10
    0xe9c5143c3c116146d9745334cdd673aa124438ae0xe9c5143c3c116146d9745334cdd673aa124438ae11902
    10
    675B
    2s