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=1442 and productid=cache_Products.productid) order by PublishDate desc
It was definitely a family affair at the WILLIAM OKPO Fall/Winter presentation on Monday night. Several OCers, proud as punch, mingled about the room celebrating another awesome presentation by OC alumni Lizzy and Darlene Okpo. ...
MORE
With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in This just in . Isn't it weird when a print becomes so ubiquitous it turns into a neutral? I feel like this is what's happening with camo. ...
MORE
Colloquially known as "vellies," Veldskoen boots (pronounced Vel-skoon ) are worn by just about everyone in Namibia, from bushrangers to university students. ...
MORE