SELECT *
  FROM (select A.*
          from VW_YS_ZLXMSRF_MZDZBL A, XT_CYZLXM B
         where A.ZLXMID = B.ZLXMID
           AND B.BH0000 = 1
           AND B.ZHXMBZ = '0'
           AND B.YSCYBZ = '0'
           and (sfje00 > 0 or sfje00 = 0 and  zlxmid in (15480))
           and lbbh00 in (1, 2, 5, 7, 8, 9, 10)
           and (A.ZLXMID not in (select X.ZLXMID from XT_ZLXMFF X) or
               A.ZLXMID in (select X.ZLXMID
                               from XT_ZLXMFF X
                              where X.YXBZ00 = '1'
                                and X.YYID00 = '222212'))
         order by pysm00)
 WHERE ROWNUM <= 100