Kat & Bee : GIFTS

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
PREVIOUS NEXT : 1~2 OF 2 ITEMS

Womens News:

5
  • Thu, March 14, 2013
    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

  • Thu, July 5, 2012
    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

  • Thu, June 28, 2012
    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

  • Thu, February 2, 2012
    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


ecommerce web design web development