【繪本圖書同時於線上線下銷售中;如急需現貨,建議落單前Whatsapp或來訊我們了解狀況,謝謝!】
-14% 六十六頭牛



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=^rebeccalong^ 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=^rebeccalong^ 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.ordnom.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^)

撰寫評論

登錄註冊後再評論

六十六頭牛

  • 出版社: 信誼
  • 產品編號: 9789861615509
  • 作者: 改編自民間歌謠 (文、圖)
  • ISBN: 9789861615509
  • 頁數: 34
  • 語言: 繁體中文
  • 出版年份: 2017
  • 出版日期: 2017/02/01
  • 庫存狀態: 可供預訂(未有現貨)
  • 庫存只供參考,並非實時顯示。如必須購買現貨,歡迎按此Whatsapp與我們查詢。
  • $83
  • $71
  • 積分換購價: 83