Layla Racy : Bottoms

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=23 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=731 and productid=cache_Products.productid) order by PublishDate desc
PREVIOUS NEXT : 1~2 OF 2 ITEMS

Layla Racy News:

5
  • Wed, February 20, 2013
    What a major week for you, Riri! First you drop your collection with River Island at London Fashion Week and now it's your 25th birthday! We are so excited to help launch the collection and can't wait to share more of your flawless style, but in the ... MORE

  • Thu, February 14, 2013
    Designer (and OCNY store associate) Layla Racy  will be in her backyard or Prospect Park when she's not working in her studio. Yes, she has a backyard in New York. But we can't be that mad at her, because it inspires her beautiful designs. ... MORE

  • Fri, November 18, 2011
    Humberto wishes beloved friend of OC Chloë Sevigny the best for her b-day. The Chloë Sevigny for Opening Ceremony Resort 2012 collection launches in less than one month––get excited! Dear Chloë, Another year gone by, another birthday of ... MORE

  • Mon, October 10, 2011
    Layla Racy makes clothes she wants to wear. And a lot of other people want to wear them too, if the rate at which they're flying off our shelves is anything to go by. ... MORE

  • Mon, July 4, 2011
    It's Independence Day! And while Opening Ceremony may be known for having lots of international love, we wanted to take a moment to gush about some of our very favorite made-in-the-USA styles. ... MORE

  • Thu, October 15, 2009
    Layla is the most recent addition to Opening Ceremony's New York Store team. Name: Layla Racy Hometown: Canterbury, CT What are you excited to wear this fall: My new black hightop Keds Style inspiration: Slouchiness Favorite designers at OC: Toga, ... MORE


ecommerce web design web development