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=24 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=167 and productid=cache_Products.productid) order by PublishDate desc
The latest CDG wallets to grace our pockets come stitched with subtle raised stripes. Rei Kawakubo's wallets never let up: season after season their clever detailing, supple leather, and peerless construction prove they're the cream of the crop.
Stitched leather wallet | Embossed Comme des Garçons logo | Top zipper closure | 100% cowhide | Made in Spain.
Iconic Japanese label Comme des Garçons makes a habit of blurring the lines between masculine and feminine, luxe and lighthearted, serious and sprightly. Blossoming into a multi-faceted company comprised of intricate men's and womenwear, accessories, and perfume, Rei Kawakubo's stunningly idiosyncratic perspective makes its mark on everything the brand offers.