select distinct
    id,
    transaction_sn,
    member_id,
    original_equity_level,
    modify_equity_level,
    modify_event,
    modify_event_info,
    target_equity_id
from
    biz_member_equity_transaction_history
where 
is_deleted = 'N'
<< and modify_event_info -> '$.payOrderSn' = :payOrderSn and modify_event_info -> '$.modifyType' = 'pay'>>
<<and transaction_sn = :transactionSn>>
<<and member_id = :memberId>>
<<and modify_event = :modifyEvent>>
<<and target_equity_id = :equityId>>