Updated 2025-04-08

    SELECT
    distinct tx_hash,
    decoded_log
    FROM ronin.core.ez_decoded_event_logs
    WHERE contract_address = '0x7cf0fb64d72b733695d77d197c664e90d07cf45a'
    and event_name in ('DecreaseLiquidity')
    and ORIGIN_FUNCTION_SIGNATURE = '0xac9650d8'
    and origin_to_address = '0x7cf0fb64d72b733695d77d197c664e90d07cf45a'
    limit 50;
    /*
    SELECT COUNT(DISTINCT tx_hash) AS total_tx_hashes
    FROM (
    SELECT tx_hash
    FROM ronin.core.ez_decoded_event_logs
    WHERE contract_address IN (
    '0x7cf0fb64d72b733695d77d197c664e90d07cf45a',
    '0x0b7007c13325c48911f73a2dad5fa5dcbf808adc',
    '0xe514d9deb7966c8be0ca922de8a064264ea6bcd4'
    )
    GROUP BY tx_hash
    HAVING COUNT(DISTINCT contract_address) = 3
    ) AS matching_transactions;
    */
    Last run: 27 days ago
    TX_HASH
    DECODED_LOG
    1
    0xc2aacbc896265660508a538fc38a221b0e6f52687e316ff841388f5ec6473fb9
    {"amount0":"309082774726897940","amount1":"1600516279743473120","liquidi...
    2
    0xbb1500a4a37ff03f0e132e8ed46d293690d75c70e749ab70ae4f953da955c94d
    {"amount0":"5018484177317807742813","amount1":0,"liquidity":"11297693301...
    3
    0xc973989268a9a32a9ea038f764050bb8b618b1e65026562de8f198ffe6f56414
    {"amount0":"9175139239284268491089990","amount1":0,"liquidity":"83680362...
    4
    0x99a5e6e6a4486533f74854c865d43148fe321e2b4f7716cca7f7fe381b92ba1f
    {"amount0":0,"amount1":"9299999999999999973538","liquidity":"61290849970...
    5
    0x1102d027ef325a1b69dc21956c38229c7c781cb39dd202bc6fc5607bc84405a5
    {"amount0":"113999999999999999999","amount1":0,"liquidity":"327527866065...
    6
    0x8e6953693662494a82637c417b03e2a0947127e43c512286881dffb0ea7c50a9
    {"amount0":"131262338298398351094727","amount1":"1662224449545081272923"...
    7
    0xbe2d0d4eebfe7d3185724ab739d4cd83fbcc740786c504a362646200500d0907
    {"amount0":"1328234049999999999999999","amount1":0,"liquidity":"62292240...
    8
    0xa770e47ac287a108394f33b84905ce6a992e5712489bbeb5dbfd586b0b8c984e
    {"amount0":0,"amount1":"6395263738157762523177","liquidity":"20132484518...
    9
    0xa0cdcf685122688e598c6bcc02bae94508b40f5075d4de116582030f23a542c2
    {"amount0":"30627323884320649192","amount1":"107579096171168777282","liq...
    10
    0x829bd2f35c6a20961b9040bf1463bd77c6ee4da4de9a51d019d7b1ece59ae52a
    {"amount0":"522000066447283529165477","amount1":0,"liquidity":"341272049...
    11
    0xb7479d2a57704d5dd050c9217659e31afed8a2bd94f4e99d4cdee10c02be02ed
    {"amount0":"512459375714302059936174","amount1":0,"liquidity":"369990221...
    12
    0x2ca5f93359703bc166fe9cc8df9dd9c6032d75d26cb8de596ae3ae1eaef95bdf
    {"amount0":"7357475677188869081634417","amount1":0,"liquidity":"61166998...
    13
    0x64a6422532a29dd01dcfc665e55a59fed46a0751b51ea08d020413c401660955
    {"amount0":370148532,"amount1":"498516248227582247411","liquidity":14669...
    14
    0xc052e134891db719701bc595348a5881048cf741daeb9b369485aa664edf0fa3
    {"amount0":"1343862751621803739829","amount1":"2188824677234862367286530...
    15
    0x1aba91e4ee4dbb1341fdbfb9fa73884b5c1009416be368b542a33fd51475a026
    {"amount0":"1855556308856942713804921","amount1":0,"liquidity":"17341236...
    16
    0xc5d9c6351e8de0ccbf2697932444c6c0d968db5b8cd2429ad01c40c97bbc8838
    {"amount0":"99999999999999999","amount1":"313201032469791213","liquidity...
    17
    0xe42b845466c93950aac718785e577011db71eff13a8b25cfc88fc5e233c13766
    {"amount0":35296,"amount1":"72025074246989800302","liquidity":1594449449...
    18
    0xa5d1a2889df491fec95a026ac9e3d84c29789bd4eca20988e31e75b4a5841144
    {"amount0":"126404631469665164151076","amount1":"393234573882967898","li...
    19
    0x8210a7fca66f96074cbdfaae505a2e1e81f7de59e6164732d346855712e373bb
    {"amount0":"1515187430047898269","amount1":"4921447249607592923","liquid...
    20
    0x57ad330988b15c898039b9467e4a09e6f682e641f59e18bb0de9e09c14daffa6
    {"amount0":"10041553052566930285951908","amount1":"619530242794508184689...
    50
    9KB
    2s