<select id="getMemberByCount" parameterType="java.util.HashMap" resultType="java.lang.Integer">
select
count(*)
from member as m
LEFT JOIN member_info as mi ON mi.member_sid = m.sid
LEFT JOIN member_info_ext as mie ON mie.member_info_sid = mi.sid
<where>
del_flag = 1
<if test="username != null" >
and username LIKE '%' #{username,jdbcType=VARCHAR} '%'
</if>
<if test="mobile != null" >
and mobile LIKE '%' #{mobile,jdbcType=VARCHAR} '%'
</if>
<if test="mailbox != null" >
and email LIKE '%' #{mailbox,jdbcType=VARCHAR} '%'
</if>
</where>
</select>