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=907 and productid=cache_Products.productid) order by PublishDate desc
For all of our favorite classic staples–from gingham (which she wore when she wed Jacques Charrier in 1959), to Repetto BB flats (which Rose Repetto created just for her ), to the bikini (which she immortalized in countless photos and ...
MORE
Between reviving Gucci from the dead, starting his own impeccable line, and finally entering into womanswear, we don't even know where to start with Tom Ford. ...
MORE
New to the OC tie rack are Jupe Ties ! Traveling all the way to India, designer Jackie Villevoye finds the finest materials and most dedicated artists to carry out her vision. ...
MORE