megsdevsEZ Liquidations Error - compound like events have collateral and debt token wrong way round
    Updated 2024-03-23
    -- demo of error
    -- someone needs to do a dig to see how many protocols/chains are affected
    select l.*, e.decoded_log
    from ethereum.defi.ez_lending_liquidations l
    left join ethereum.core.ez_decoded_event_logs e
    on l.tx_hash = e.tx_hash and l.event_index = e.event_index
    where platform = 'Compound V2'
    limit 10


    -- see in output event log that "seizeTokens" != "AMOUNT_UNADJ" in ez table, instead the collateral "repayAmount" is placed there
    -- The debt and collateral token addresses are also the wrong way round
    -- you can inspect the transactions on etherscan to verify the mistake as well
    QueryRunArchived: QueryRun has been archived