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=21 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1366 and productid=cache_Products.productid) order by PublishDate desc

Hexa By Kuho : Tops

PREVIOUS NEXT : 1~3 OF 3 ITEMS

Hexa By Kuho News:

5
  • Sat, June 15, 2013
    Today, we celebrate the birthday of one of the most-loved TV characters in pop culture, Carrie Bradshaw. Almost 15 years ago, Carrie caught our attention while darting through the busy streets of Manhattan, dressed in that unforgettable tutu ... MORE

  • Wed, June 12, 2013
    Meet Jessi, the latest intern to join OC's art department. Name:  Jessi Johanna Brattengeier Hometown: Austin, TX Astro sign:  Gemini Instagram:   jessijohannab Currently obsessed with:  Tropicalia music, avocados,  ... MORE

  • Mon, May 6, 2013
    If we've learned anything from our year of featuring young and established Korean designers , it's that the Seoul fashion scene is bursting at the seams with unique concepts and trend-setting ideas. ... MORE

  • Tue, December 4, 2012
    Kuho Jung laughs so much you'd never guess he was the Creative Director of Korea's largest fashion powerhouse, Samsung Cheil, which can't be an easy job. He also designs one of its most successful and talked-about brands, Hexa by Kuho . ... MORE

  • Wed, August 22, 2012
    If you were alive during the better part of the 90s, there's no denying the amazing ness of Tori Amos. Flame-haired and fairy-like, the absurdly talented piano-rocker is arguably one of the greatest pianists and vocalists of our time. Seriously. ... MORE

  • Tue, August 21, 2012
    With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in " THIS JUST IN ." Avast ye maties! Here's one I didn't see coming––the Seinfeld puffy shirt is back with a vengeance for Fall 2012. ... MORE

  • Mon, August 20, 2012
    It’s been a big year for OC (our adidas Originals collaboration , the London pop-up shop, the OC Annual , and the 10 year book with Rizzoli), and it’s about to get bigger! Today, we are excited to announce our next featured country, ... MORE

  • Fri, May 11, 2012
    Since his first collection in 1960 that featured the color of poppies (later known as his signature "Valentino red"), Valentino Garavani's designs have embodied pure femininity season after season. ... MORE

  • Fri, March 30, 2012
    Did you have a brain tumor for breakfast? Everyone knows that the 2000s had  Mean Girls , the 1990s Clueless , and in the 1980s––it was all about Heathers . ... MORE

  • Tue, March 27, 2012
    Sometimes a piece comes into the store and I can't stop playing with it (see the Gerlan slime bra in the post below), and this 3-D patterned  Hexa by Kuho  medal dress is one of those pieces. And so are the tasseled heels . ... MORE


ecommerce web design web development