Proper Attire : OC EXCLUSIVES

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=116 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=318 and productid=cache_Products.productid) order by PublishDate desc
PREVIOUS NEXT : 1~3 OF 3 ITEMS
  • OPENING CEREMONY
    Opening Ceremony for Proper ...
    $6.00
  • Alexander Wang for Proper Attire, ...
    $6.00
  • Jeremy Scott for Proper Attire, ...
    $6.00

Proper Attire News:

5
  • Wed, April 4, 2012
    I wish there was a Jessica character from American Pie at my high school when I was growing up. Some sassy girl who verbally throws a bucket of ice cold water over any teenage fascinations and subsequent paths to disillusionment. ... MORE

  • Thu, February 10, 2011
    We can't wait for Fall, and today's Vena Cava FW11 show is one reason why. Read on for our Q&A with Sophie and Lisa, plus check out these snaps of runway looks and a clip of the final walk! Name three things on your inspiration board. ... MORE

  • Fri, February 19, 2010
    Joining to the ranks of Alexander Wang , Keith Haring Foundation , and ourselves , we’re pleased to present Jeremy Scott as the newest designer to lend themselves to Proper Attire’s line of designer condoms. ... MORE

  • Sat, February 13, 2010
    Sunday, February 14th, Opening Ceremony will open its second location in New York City at the new Ace Hotel this February. the 1500 square foot space has 20 foot ceilings and entrances facing Broadway and the bustling Ace Hotel lobby. ... MORE

  • Tue, February 9, 2010
    In case you thought the Opening Ceremony collaborations could go no further, we have expanded into new and even-more-unexpected terrain: condoms! A few months back when we envisioned our perfect travel shop and all of the essentials it would one day ... MORE


ecommerce web design web development