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=545 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1326 and productid=cache_Products.productid) order by PublishDate desc
Don't worry if you spaced on Valentine's Day. Today is another major romance-related holiday in Korea, White Day ! In Korean tradition, it's up to the girls to give their guys chocolates and presents on V-Day; on White Day, it's the boys who spoil ...
MORE
In a family portrait, taken when she was 19, Frida Kahlo appears dressed as a man. She was badass. Frida is an inspiration because she didn't care what people thought, or at least she didn't let on that she did. ...
MORE
With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in THIS JUST IN . Jumpsuits are not the easiest thing to pull off—I’ll admit. When worn by backup dancers and technicians, they work. ...
MORE
Kat & Bee 's first collection, "Momento Mori," is about going big or going home. From her studio in East London, designer Kat Barry hand-makes intricate mishmashes of metal: fat red fimo roses, glittering gold beads, and hunks of ...
MORE