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=2 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1578 and productid=cache_Products.productid) order by PublishDate desc
Last season, we introduced Korean brand Goen.J to the US for the first time. (You may have seen Rih rocking the long lace jacket from the fall collection.) Well, this season designer Goen Jung is bringing pretty back once again. ...
MORE
Happy birthday to the face of Nouvelle Vague and OC’s favorite Iowa-born mademoiselle, Jean Seberg! Jean had an effortless and fresh look, particularly when you compare her to other French vixens of the 60s era. ...
MORE
Bomber jackets, meet broderie anglaise . When OC Online's own Joyce Lee returned from Seoul recently with a broderie-sleeve varsity jacket embroidered across the back with "Mademoiselle" (like a Korean Pink Lady), we wanted in. ...
MORE