select a.YJDJH0,
       d.bmmc00 bmmc00,
       a.BRXM00,
       a.BRID00,
       a.brxm00 || ' ' || a.xb0000 || ' ' || SF_XT_CSRQTONL(a.CSRQ00, NULL) brxxstr,
       a.ZLXMJC,
       a.KDYSXM,
       a.KDRQ00,
       a.ZXRQ00,
       '文字报告' WZBG00,
       '图像' TXLL00,
       c.BGURL0,
       C.yxurl0,
       C.sfjk00,
       b.jclbid,
       c.jclbmc,
       a.wdwid0,
       a.zyhghh,
       a.sqid00 sqdid0,
       decode(a.mzzybz, '0', '门诊', '1', '住院') mzzybz,
       A.ZLXMID
  from yj_yw0000 a, bm_zlzd00 b, bm_jclb00 c, bm_bmbm00 d,sf_brxxb0 e
 where a.zlxmid = b.zlxmid
   and b.jclbid = c.jclbid(+)
   and a.kdksbh = d.bmbh00(+)
   and a.zyhghh=e.ghh000(+)
   and b.lbbh00 = '3'
   and ((c.BGURL0 is not null) and (C.yxurl0 is not null) or
       (A.ZLXMJC like '%心电图%' or A.ZLXMJC like '%动态血压%' or
       A.zlxmjc like '%脑电图%' or A.zlxmjc like '%肌电图%' or
       A.zlxmjc like '%肺%功能%' or A.zlxmjc like '%脑彩超%' or
       A.zlxmjc like '%颅内段血管彩色多普勒超声%'))
   and (a.CXDJH0 IS NULL or (a.cxdjh0 is not null and e.sfzrzy='Y'))
   AND NOT EXISTS (SELECT 1
          FROM yj_yw0000 x
         where x.zyghid = a.zyghid
           and x.cxdjh0 = a.yjdjh0)
   and a.KDRQ00 >= '20250901'
   and a.KDRQ00 <= '20250926'
   and a.brxm00 like '%李秀云%'
 order by a.KDRQ00 desc, d.bmmc00, a.sqid00 desc