and ro.mer_id = #{merId}
and ro.refund_order_no = #{refundOrderNo}
and ro.order_no = #{orderNo}
and ro.create_time >= #{startTime}
and ro.create_time #{endTime}
and ro.refund_status = #{refundStatus}
and INSTR(u.nickname, #{nickname})
and p.category_id = #{categoryId}
and o.insurance_type = #{insuranceType}
and INSTR(p.name, #{productName})
and INSTR(o.member_name, #{memberName})
and o.pay_type = #{payType}
FROM eb_refund_order ro
left join eb_order o on ro.order_no = o.order_no
left join eb_user u on o.uid = u.id
left join eb_merchant m on o.mer_id = m.id
left join eb_order_detail detail on o.order_no = detail.order_no
left join eb_product p on detail.product_id = p.id