六十六頭牛

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^)