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

Salem News:

5
  • Wed, February 13, 2013
    So as the paps were busy freaking out over Big Sean, Waka Flaka, Perez Hilton, and A$AP Rocky at the Jeremy Scott show, a 7-year-old boy sitting front row totally diverted my attention. ... MORE

  • Tue, January 22, 2013
    On Sunday, MoMA PS1 flung open its doors for an afternoon to celebrate four exciting new shows. On the lower level, a jubilant CONFETTISYSTEM installation featured Nick Anderson and Julie Ho's glimmering creations, while the galleries on the upper ... MORE

  • Mon, January 14, 2013
    Before you spotted the DIS magazine models in white bodysuits stamped with TRIENNIAL , 2015 , and YOUR LOGO HERE ; before you were tempted by an expertly mixed cocktail chilled with a spherical ice cube; and before you set foot in the elevator ... MORE

  • Mon, December 24, 2012
    The holiday season is upon us and this year it's time to HOLIDAY YOUR WAY ! We asked Michelle what she wants, needs, and is gifting this year. ... MORE

  • Wed, November 7, 2012
    Givenchy and Hepburn, Saint Laurent and de la Falaise... the relationship between designer and muse has been integral to fashion history. Our favorite contemporary designers and their influences are no exception. ... MORE

  • Fri, October 19, 2012
    With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in " THIS JUST IN ." This week we explore the arrivals at OC that have made themselves at home at both our 35 Howard Street store, and our men's ... MORE

  • Thu, October 4, 2012
    Silver, platforms, zippers, laces! For OC's latest collaboration with Italian sneaker brand Forfex , we pulled out all the stops to bring you one perfect pair of metallic boots. ... MORE

  • Tue, October 2, 2012
    When I saw Matthew wearing Jeremy Scott's technicolored keyboard head-to-toe outfit––with the matching Longchamp bag––during this year's Pride parade, I knew there was no one better to show us how it's done in Jeremy's ... MORE

  • Tue, July 24, 2012
    Check out what the staff are coveting! "My pick is OC's  MESH STRIPED PLEATED DRESS  because I love a collared dress paired with Chucks. Plus the sheerness makes it interesting. ... MORE

  • Thu, May 31, 2012
    iO Tillett Wright brought her ongoing Self Evident Truths project to The Hole on Tuesday, covering the space with 1,675 uncompromising black-and-white portraits of individuals who identify as "ANYTHING other than straight. ... MORE

  • Tue, March 20, 2012
    Aaron Brown is one half of Focus Creeps, the directorial duo making big moves in the indie music scene after shooting videos for Arctic Monkeys, Wavves, and Girls . ... MORE

  • Fri, March 16, 2012
    Member: Michelle Book: Drawings from the film beginners Price: $35 Why it's so great: Drawings from the Film Beginners allows you to extend the film Beginners beyond the confinements of the screen. ... MORE

  • Tue, September 20, 2011
    Our next installment of the doorman diaries comes from OC shopgirl , OC model , and Paper Nightlife Award nominee, Michelle Salem. ... MORE

  • Thu, August 11, 2011
    Meet OCNY's newest sales associate Michelle, bringing tha Miami noise! Name:  Michelle Salem Hometown: Miami, Florida Astrological sign:  Scorpio Currently obsessed with:  My new neighborhood, Mini-Wheats, and Dior Homme cologne Last ... MORE

  • Mon, April 18, 2011
    Last week's opening reception at LA's Royal/T for FACEMAKER , a multi-dimensional show curated by gallerist and former director of Deitch Projects Kathy Grayson, was quite a face full. ... MORE

  • Wed, October 27, 2010
    The discomfort-inducing drone of a Salem track has proven perplexing to many. What do you call sound that inspires an almost schizophrenic range of feelings--severity, elevation, dejection, deliverance--without deviating much from a consistently ... MORE


ecommerce web design web development