通靈警探(全一冊)

出版社︰ 普天
國際書號(ISBN): 9789863893547
作者: 玄門弟子
出版日期: 2017/6/6
語言: 中文繁體
庫存狀態︰ 沒有庫存,可訂貨
銷售價︰ HK$126.7 HK$114.1(9折)

如需訂貨,送貨時間為7-21天,如有庫存則3-5 天內可送達。

購買數量︰  
   - 或 -   

select count(*) as total from ( select distinct m.ordno from chain c(nolock),m_keroro m(nolock) where c.packno=m.ordno and m.shipterm=^02^ and m.state in (^f04^,^s55^) and c.arrive2day>^0^ and dateadd(day,7,(convert(char(8),c.arrive2day)))>=convert(varchar,getdate(),112) and m.custno=^smjnch0415^ union select distinct m.ordno from chain c(nolock),m_keroro m(nolock) where c.packno=m.ordno and m.shipterm=^12^ and m.state in (^f04^,^s55^) and c.arrive2day>^0^ and dateadd(day,3,(convert(char(8),c.arrive2day)))>=convert(varchar,getdate(),112) and m.custno=^smjnch0415^ union select distinct m.ordno from statehist c(nolock),m_keroro m(nolock) left outer join tblship_statehist t(nolock) on m.ordno=t.ordno where c.ordno=m.ordno and m.ordno<>m.oldordno and c.state=m.state and m.shipterm not in (^02^,^12^) and convert(char(10),c.cdate,121)>=case when m.outno711=^trans^ or m.outno711 like ^n%^ then convert(char(10),getdate()-2,121) else convert(char(10),c.cdate,121) end and m.state in (^f03^,^s50^,^s55^,^i50^) and m.custno=^smjnch0415^ ) as ar

如果您對本書本有什麼問題或經驗,請在此留下您的意見和建議!

您的姓名︰


您的評價︰ 注意︰ 評論內容不支持HTML代碼!

會員評分︰ 劣評            好評

請在下框輸入驗證碼︰



同作者閱讀
HK$126.7 HK$114.1
(9折)