Lena Lumelsky : all categories

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=1211 and productid=cache_Products.productid) order by PublishDate desc
PREVIOUS NEXT : 1~5 OF 5 ITEMS

Lena Lumelsky News:

5
  • Fri, May 3, 2013
    Loulou de la Falaise, known as YSL's muse, worked closely with the designer, greatly influencing his genius creations. The word muse is somewhat of a misnomer, however; in an interview with Italian Vogue , de la Falaise noted, “For me, a ... MORE

  • Wed, August 22, 2012
    There are days when you want to wear flowers and cardigans—because the sun is shining, you've done your laundry, and you've paid your rent on time. But for mornings when you don't feel like Marsha Brady, there's  Lena Lumelsky . ... MORE

  • Wed, November 16, 2011
    When I first saw  Lena Lumelsky's fall collection I was surprised—not only is it a total contrast to spring's "See-Through" collection, but I'd also read that it was inspired by Amish clothing, and harnesses and leather don't ... MORE


ecommerce web design web development