Risto : Skirts

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

Risto News:

5
  • Tue, April 23, 2013
    Merpeople are having a moment. ( Eric Ducharme , haters gonna hate.) But my real crazy obsession is Risto Bimbiloski's spring collection. ... MORE

  • Fri, June 10, 2011
    It's sample sale time! We'll be snapping cuties on line all day, so come looking your best! Name: Hye Favorite summer treat: Iced coffee Favorite bubble tea flavor:  Taro Milk Favorite designers at OC:   ALEXANDER WANG  and  OC ... MORE

  • Tue, February 15, 2011
    With a collection that reportedly recalled the days of our youth; school days, sneaking out to parties and snatching outfits from your mom's closet (which I still do), Risto Bimbiloski once again demonstrated today his lauded skill of printmaking. ... MORE

  • Mon, November 1, 2010
    Introducing our brand new OCNY recruit, Becky! Name: Becky Washington Hometown: Phoenix, AZ Worst trend you've ever followed: That whole Catholic school girl look! Most treasured piece of clothing: My bootz! What are you excited to wear this ... MORE

  • Fri, February 12, 2010
    Risto’s Fall-Winter 2010 collection worked with traditional craftsmanship and tech inspired landscape prints to find a place for the modern artisan. ... MORE


ecommerce web design web development