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=209 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1552 and productid=cache_Products.productid) order by PublishDate desc
Check out what the staff are coveting! Pick : Telfar bucket hat This piece is perfect for : The beach! I'll be taking mine to Barcelona this summer. ...
MORE
Meet Ilia, new to OCLA! Name : Ilia Ovechkin Astrological sign : Libra Currently obsessed with : B12 shots Last movie I downloaded : River of No Return Supernatural power I would like to possess : Miracle healing When I was 13, I was wearing ...
MORE
Make It Snappy is a photo series showcasing quick snaps from OC & friends. Who: Telfar's pastel perfection ( as chosen by you ) for Fall/Winter 2013 Where: Jack Chiles Gallery When: Last night.
MORE
Does New York Fashion Week not come but twice a year? After Saturday's TELFAR Fall/Winter 2013 presentation in collaboration with DIS at New York Gallery, maybe not. ...
MORE
Givenchy and Hepburn, Saint Laurent and de la Falaise... the relationship between designer and muse has been integral to fashion history. Our favorite contemporary designers and their influences are no exception. ...
MORE
Telfar Clemens' Spring 2013 FORMALE;LIFE collection takes a literal approach to the ubiquitous term ready-to-wear , with a convertible collection that transitions from what Telfar calls "intimate loungewear to formal leisure attire. ...
MORE
"I’ve been really into 42nd Street recently. The style there is off the wall," said Telfar Clemens when I asked him about his current fashion heroes. ...
MORE
With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in " THIS JUST IN ." A little bit of Kenzo from Paris, a little bit of Telfar from New York, and finally a little MVIO and Peace, Love, and ...
MORE
Not to get all Namaste on you guys, but you know when you meet someone and their energy just puts you at ease? That's Noma! We met when Telfar hand picked him to model the exclusive collection for Opening Ceremony, and it's all just OC ...
MORE
Make It Snappy is a photo series showcasing quick snaps from OC & friends as we navigate New York Fashion Week. Who: David Toro and Telfar Clemens What: Telfar EXTREME LAYERS A/W 2011 presentation Where: Eyebeam at W 21st St. ...
MORE
Photos courtesy of Lauren Devine As part of New Museum's exhibition, "Free," DIS Magazine launched their new lecture series with a power point on the scrunchie, guided by artist David Riley. ...
MORE