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=1892 and productid=cache_Products.productid) order by PublishDate desc
Cult brand COS is launching in the US this season with an exclusive pop-up shop at Opening Ceremony! COS has long been one of our favorite labels to pick up on trips to Europe, so we are beyond excited to introduce it to our friends stateside.
These modern round toe lace-up shoes are made from polished patent leather. With lightly cushioned insoles, they have rubber gripped soles.