select distinct id,
                member_id,
                transaction_sn,
                modify_event,
                modify_event_info,
                modify_target_id,
                point_change_num,
                is_deleted
from biz_member_point_transaction_history
where is_deleted = 'N'
<<and modify_event_info -> '$.payOrderSn' = :payOrderSn and modify_event_info -> '$.modifyType' = 'pay'>>
<<and member_id = :memberId>>
<<and transaction_sn = :transactionSn>>
<<and modify_event = :modifyEvent>>
<<and modify_target_id = :modifyTargetId>>