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=16 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=148 and productid=cache_Products.productid) order by PublishDate desc
Rachel Comey's shoes are addictively perfect. Once you start, you can't stop, because every pair would look good with nearly everything else in your wardrobe. Specializing in boyish shapes with feminine details, Rachel brings subtle textures and super soft leathers to lace-up oxfords and ankle boots.
Suede lace-ups | Raw leather midsole | Rubber outsole | Genuine leather | Made in Peru.
Drawing on influences like coastal Maine, Asiatic patterns, and clog-wearers with artistic sensibilities, Rachel Comey strikes a seamless balance between sophistication and adventure. Smart prints and spirited silhouettes keep the Comey brand on every sharp dresser's shortlist.