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=209 and productid=cache_Products.productid and cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=148 and productid=cache_Products.productid) order by PublishDate desc
The Rachel Comey woman is ready to catch some rays! Cropped shirts in chartreuse and sleeveless silk dresses in camo salute the sun for spring, while perforated shoes and sandals are fit for any girl running on solar power.
Perforated leather derbies | Lace-up | 0.8" heel | 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.