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

DKNY Exclusively for Opening Ceremony News:

5
  • Tue, February 26, 2013
    When news broke at OC that we were working with DKNY on a capsule collection , the first thing that came to my mind was the Houston Street mural. ... MORE

  • 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
    The week before we shot the 90s rollerblading DKNY Exclusively for OC video at Fast Ashley's in Williamsburg, everyone kept asking me if the models knew how to rollerblade. ... MORE

  • Sun, February 10, 2013
    The DKNY Exclusively for Opening Ceremony collection has arrived, bringing back some of the iconic New York label's freshest streetwear looks from the early 90s. ... MORE
  • Tue, February 5, 2013
    With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in " THIS JUST IN .' " My usual black-spandex-and-white-tee-combo at the gym is nothing to write home about, and leave it to DKNY Exclusively for OC ... MORE

  • Fri, February 1, 2013
    OC meets DKNY for Spring 2013! This season, we team up with the iconic New York label to present a capsule collection of re-issued styles available exclusively at OC. ... MORE


ecommerce web design web development