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=17 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1482 and productid=cache_Products.productid) order by PublishDate desc
This coat by British designer Sophie Hulme is meant to be kept. Constructed with quality as priority number one, Sophie's pieces pair masculine shapes and traditional finishes with leather details for added edge. Every season she designs a charm to accompany her collection. This spring each piece comes with a delicate golden key.
Double-breasted trench coat with leather sleeves | Button closure | Tie belt | Waist pockets | Ribbed cuffs | Vent at back | Lined | Body: 100% cotton with real leather | Made in the UK.
Sophie Hulme shows that masculine minimalism and feminine flair make a smart pair. The British designer's highly-coveted "armored" leather bags are proof of this perfect combination, as well as her high regard for quality materials. From sequined rucksacks to bomber jackets with bows, tough-guy womenswear makes a simple yet clever statement.