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