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=1 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=5 and productid=cache_Products.productid) order by PublishDate desc
These straight leg chinos have a worn in sensibility that will make you feel like you've been wearing them the past five years. Slim fit chinos with silhouette label above right back pocket.
Established: 2005 by Per Andersson
From Göteborg comes the subtly detailed menswear of Velour. Electing to use somber color palettes, creative director Per Andersson looks to clever ornamentation to produce instant classics–ones that not only feel like your favorite flannel or pair of pants, but also improve upon those beloved aesthetics with modern nuance.