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=17 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=125 and productid=cache_Products.productid) order by PublishDate desc
Our new model Simone spends her free time writing historical non-fiction and has a pet turtle named Daedalus, and I can't decide which fun fact makes me like her more! Get to know Simone here. ...
MORE
Whether you’ve read his books or seen the cinematic adapations, almost everyone over the age of 21 has (or at least should have) been privy to the mind of Bret Easton Ellis. ...
MORE
It’s the sale to end all sales! From Thursday, January 12, we’re super-sizing markdowns up to 70% off Band of Outsiders , Christopher Kane , Carven , Jean Paul Gaultier , Marios Schwab , Opening Ceremony Collection , Patrik Ervell , ...
MORE
The biggest Happy Birthday to one of my nearest and dearest! Here's to another great year, a great day and all that stuff! The next time I see you, I'm gonna give you the biggest hug you have ever had! Happy belated b-day, Spike!!!!!! Humberto
MORE
First Rihanna totally captured our hearts by wearing the Opening ceremony pointed collar sleeve dress and OC Exclusive Joomi Lim brooch on the cover of her new album, Talk the Talk . ...
MORE
The soft, calm sounds of Cibo Matto were the perfect live accompaniment for United Bamboo 's SS12 collection. Comprised of navy, black, beige and white linens, white and black leathers and custom silk prints, the fabrics felt light, uncomplicated ...
MORE
'The future is unwritten.' Joe Strummer, 1982-2002. Know your rights! Anyone who's walked down 7th Street between Avenues A and B has most likely passed this colorful mural of Joe, the Clash frontman and punk rock legend. ...
MORE
At this point, ties and Father's Day don't have the best relationship–which is totally and completely justified by something that starts with a z and ends with a z . That's right: zzZzzzZZzzz. ...
MORE
"Shop Talk" is a series of atelier tell-alls (or, you know, studio visits) where we sit and chat with some of today's best designers--who also happen to be our neighbors! The latest adventure lands us practically next-door at United ...
MORE
We are hosting a sizzling sample sale just in time for the beginning of summer! Come see us on this sure-to-be glorious June weekend to get 90% off on picks from acne , alexander wang , band of outsiders , cacharel , jeremy scott , opening ceremony ...
MORE
Almost silhouetted by Chelsea’s morning sunlight, the looks of United Bamboo for Fall Winter 2011 were a constant to and fro between what is unassuming and classic indulgence. ...
MORE
Make It Snappy is a photo series showcasing quick snaps from OC & friends as we navigate New York Fashion Week. What: The front row at United Bamboo Where : Studio 450 When : 11:26 am today.
MORE
Meet Wendy, our copper-topped manager at OCNY ! Name: Wendy Dorer Hometown: Ann Arbor, MI Astrological sign: Sagittarius. It’s a dealbreaker when my date wears: Anything neon. ...
MORE
Meet Francesca, who has just recently arrived at OCNY! Name: Francesca Grosso Home state: Florida Astrological sign: Aries Sun, Taurus rising Its a deal breaker when my date wears: Too much cologne Currently obsessed with: My new cherry velvet Dr. ...
MORE
This lovable fuzzball named Theodore not only had all of OCNY's sale associates fighting for his affection, but he also rivaled the adorable cat pin-ups in the spectacular United Bamboo 2011 Cat Calendar ! Name: Theodore Breed: Pomeranian ...
MORE
Meet our newest Opening Ceremony at Ace Hotel sales associate, Lisa. She just arrived from Los Angeles and happily brought the sunshine with her! @font-face { font-family: "Times New Roman"; }@font-face { font-family: "Arial"; }p. ...
MORE
Miho Aoki and Thuy Pham of United Bamboo have perfected the tweaked classic over the past twelve years. The collection the pair showed this morning at the Hostfelt Gallery had a certain nineties minimalism feel to it, with the spare shapes, flat ...
MORE
Meet Nana, the newest addition to our OCNY team! Name: Nana Cho Hometown: Taichung, Taiwan Astrological sign: Aries. It’s a deal breaker when my date wears: Shape-Ups/Crocs. Go-to first date outfit: Oversized tee and skinny jeans. ...
MORE