SQL相关问题，请求帮助，谢谢

SELECT FROM (
SELECT m.*, rownum as rnum FROM(
SELECT mm.* FROM (
SELECT FROM PAY_ORDER A ,PAY_ORDER_ENTRY B
WHERE A.CUT_PAY_SIGN ='1'
AND B.ENTRY_TYPE ='02'
AND B.ORDER_ID =A.ORDER_ID
AND B.TRADE_NO = A.ORDER_NO
AND NOT EXISTS (SELECT 1 FROM PAY_ORDER_ENTRY B WHERE B.ORDER_ID =A.ORDER_ID AND B.TRADE_NO = A.ORDER_NO AND B.DEAL_STS !='03')
) mm
WHERE
ORDER BY mm.ORDER_ID DESC
) m
) WHERE rnum >= #startNum# AND rnum <#endNum#

    <!-- 根据实际情况选择分页查询条件 -->
<sql id="PayOrderEntry.findPageForCutPay.andEntry">
    <dynamic prepend="and">
    <isPropertyAvailable property="entryNo">
              <isNotEmpty prepend="AND" property="entryNo">
                  mm.ENTRY_NO = #entryNo#
               </isNotEmpty>
     </isPropertyAvailable>
    <isPropertyAvailable property="orderId">
              <isNotEmpty prepend="AND" property="orderId">
                  mm.ORDER_ID = #orderId#
               </isNotEmpty>
     </isPropertyAvailable>
    <isPropertyAvailable property="entryType">
              <isNotEmpty prepend="AND" property="entryType">
                  mm.ENTRY_TYPE = #entryType#
               </isNotEmpty>
     </isPropertyAvailable>
     <isPropertyAvailable property="channelName">
              <isNotEmpty prepend="AND" property="channelName">
                  mm.CHANNEL_NAME LIKE '%$channelName$%'
               </isNotEmpty>
     </isPropertyAvailable>
     <isPropertyAvailable property="channelNo">
              <isNotEmpty prepend="AND" property="channelNo">
                  mm.CHANNEL_NO = #channelNo#
               </isNotEmpty>
     </isPropertyAvailable>
     <isPropertyAvailable property="uuid">
              <isNotEmpty prepend="AND" property="uuid">
                  mm.UUID = #uuid#
               </isNotEmpty>
     </isPropertyAvailable>
    </dynamic>
</sql>

问题描述不清楚。请仔细描述下。