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=1553 and productid=cache_Products.productid) order by PublishDate desc
The American version of The Girl with the Dragon Tattoo was good, right? To be honest, I didn’t really pay a lot of attention to what was happening on the screen; I was way too distracted by the film’s score. ...
MORE
Meet Kemdi, interning with the OC Showroom. Name: Kemdi Opara Hometown: Ewing, New Jersey Twitter name: @Don_Kemdito Astrological sign: Gemini Last song I downloaded: "Traffic" by Lil Reese ft. ...
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
Korean brand Human Potential has been worn by NU'EST, JJ Project, GLAM, and 2NE1. I don't want to name drop, but the names are so awesome I can't help it. ...
MORE
It’s been a big year for OC (our adidas Originals collaboration , the London pop-up shop, the OC Annual , and the 10 year book with Rizzoli), and it’s about to get bigger! Today, we are excited to announce our next featured country, ...
MORE