select ProductID , GroupID,PreOrder,0 as LC,(select top 1 TypeID from mss_Types where TypeID in (select typeid from mss_types where [sign]='DESIGNERS') and TypeID in (select TypeID from mss_Index where ProductID=cache_products.ProductID)) AS DesignerID from cache_Products where (publishdate < getdate() or publishdate is null) and 1=1 and exists (select top 1 1 from mss_index where typeid=2 and productid=cache_Products.productid and cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=873 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1458 and productid=cache_Products.productid) order by PublishDate desc
Outdoor Products was established in Los Angeles in 1973. Through the early 80s it kept America kitted out with its "plain backpacks"—hard-wearing Cordura bags in bright solid colors. Now based in Japan, the reissued Outdoor Products line uses the original 70s logo but channels OP's valued functionality into pieces for the 2010s: padded iPad cases and poppy color-blocked backpacks.
Multicolor backpack | Adjustable shoulder straps | Top handle | Large front zipper pocket | Grey hardware.