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 cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=16 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=62 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=464 and productid=cache_Products.productid) order by PublishDate desc
Carven's Fall/Winter 2012 shoes are all about the finishing touches. These two-tone leather boots feature a grosgrain ribbon heel-tab, pinked tongues, and deep red stitching around the midsole—all the better to bring out their rich navy pebbled leather.
Pebbled leather lace-up boots | Polished leather toe and sides | Stacked leather sole | Made in Portugal.
With a history of outfitting European royalty, the house of Carven has been a bastion of delicate luxury and expert design for over 60 years. Dedicated to an air of superior elegance—mixed with freedom and irreverence, too—the French label offers refined, adventurous mens and womenswear that allows its wearer's personal style to shine through. In 2009, Givenchy designer Guillaume Henry took the helm, helping Carven to reclaim its seat at the top. (But don't call it a comeback!)