SELECT * FROM (  SELECT wsid00, ghid00, ghh000, brid00, bcwjmc,zs0000,  t.xmlnr0.getclobval() xmlnr0, sfcz00, jzys00, sjys00, cjrq00, cjsj00, cjr000, cjrxm0, fbrq00, fbsj00,bs0000,tz0000,wszt00, BLXMBH,WSMC00,SFHBWS,WSHBID,WSQYMC,DQDKYS,DKIP00,JSRQ00,JSSJ00,PXRQ00,PXSJ00,SFGD00,  (select brxm00 from bm_brxxb0 where brid00 = t.brid00 and rownum = 1) as brxm00,  (select jzks00 from sf_brxxb0 where ghid00 = t.ghid00 and rownum = 1) as jzks00  FROM Ys_mzblws t  ) where rownum <= 2000 and  1 = 1   and BCWJMC != '0' and  WSZT00 != 3   and  GHH000 in ( 27291460 )  order by CJRQ00,CJSJ00