1       11:01:32  SQL Execute: ORACLE - select distinct b.ZWXM00||'('||decode(instr(LBMC00,'บล'),0,c.LBMC00,substr(c.LBMC00,1,instr(LBMC00,'บล')-1))||')' as GHLBMC,b.ZWXM00,b.XKH000,c.XSXH00,b.YGBH00,a.GHHBID,GHZKMC,CKMC00 from VW_YS_KSGHHB a,BM_YGBM00 b,BM_GHLBB0 c 
where a.GHMZSJ=to_char(sysdate,'YYYYMMDD')  
 and a.GHJSSJ>=to_char((sysdate-1/48),'HH24:mi:ss')
 and a.GHQSSJ<=to_char((sysdate+3/48),'HH24:mi:ss')
and a.GHYSBH=b.YGBH00  and a.GHLBBH=c.LBBH00 and a.GHKSBH=479 order by c.XSXH00,b.XKH000