select ProductID,ProductName,ImagePath,Designer,SalePrice,Price, 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 exists (select top 1 1 from mss_index where typeid=201 and productid=cache_Products.productid) order by PublishDate desc
Loulou de la Falaise, known as YSL's muse, worked closely with the designer, greatly influencing his genius creations. The word muse is somewhat of a misnomer, however; in an interview with Italian Vogue , de la Falaise noted, “For me, a ...
MORE
Meet Cherie, the new girl at OCNY! Name: Cherie Camacho Hometown: Prince George County, MD Twitter name: @THEcamacho Astro sign: Cancer Currently obsessed with: Air Force 1s Last song or movie I downloaded: "Strictly 4 My P.A.P.I. ...
MORE
Bernhard Willhelm has been collaborating with Camper for seven seasons! His take on the hiking boot has been a repeat performer, and this season's version (to the left) is a strong contender for our all-time favorite. ...
MORE
Last summer, Bernhard Willhelm relocated his studio to Puerto Vallarta, Mexico, where his team spent two months working on a new collection distracted only by monkeys and mezcal. ...
MORE
OC's Most Wanted is a new series presenting our favorite and most coveted items available at OC. Toffee-apple lenses placed inside a rose gold frame that's as light as a feather, and strong as a board. ...
MORE
It's Paris Fashion Week and we’re nearly as excited to find out what’s playing during the shows as we are to see what’s on the catwalks. We asked some OC friends to hit us with their Fall/Winter 2012 show soundtracks. ...
MORE
For his Fall/Winter 2012 show, Bernhard Willhelm presented an exuberant collection of juicy colors, animal prints, major-impact typography and symbols, and trailing rope. ...
MORE