java项目，sql查询的时候，如下代码为什么提示“缺少右括号"？

Question

<select id="select_label" resultMap="XykLabelRecords" 
    parameterClass="java.util.HashMap">
    <![CDATA[select * from (select * from xyk_label_records  where customer_number=#customer_number#  and is_stick =1]]>
    union all
    select * from xyk_label_records  where customer_number=#customer_number#  and is_stick =0
    <dynamic prepend=" and ">
        <isNotEmpty prepend=" and  " property="small">
            <![CDATA[create_time > #small#]]>
        </isNotEmpty>
        <isNotEmpty prepend=" and  " property="large">
            <![CDATA[create_time < #large#]]>
        </isNotEmpty>
    </dynamic>
    )  a order by   a.is_stick desc,a.create_time desc 
</select>

<select id="select_label_count" resultClass="java.lang.String"
    parameterClass="java.util.HashMap">
    
<![CDATA[select  count(*) as count     from(select * from (select * from xyk_label_records  where customer_number=#customer_number#  and is_stick =1]]>
    union all
    select * from xyk_label_records  where customer_number=#customer_number#  and is_stick =0
    <dynamic prepend=" and ">
        <isNotEmpty prepend=" and  " property="small">
            <![CDATA[create_time > #small#]]>
        </isNotEmpty>
        <isNotEmpty prepend=" and  " property="large">
            <![CDATA[create_time < #large#]]>
        </isNotEmpty>
    </dynamic>
    )  a order by   a.is_stick desc,a.create_time desc 
</select>

Answer 1

Answer 2

确实是少一个右括号

<![CDATA[select count(*) as count from(select from (select from ..... ) a order by a.is_stick desc,a.create_time desc