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=221 and productid=cache_Products.productid) order by PublishDate desc
Nothing says Mother's Day like a major montage of our favorite mommy movie moments (can I squeeze one more word starting with M into this sentence? Maybe). ...
MORE
Loulou de la Falaise, known as YSL's muse, worked closely with the designer, greatly influencing his genius creations. The word muse is somewhat of a misnomer, however; in an interview with Italian Vogue , de la Falaise noted, “For me, a ...
MORE
Popsicle sticks stuck to a card that will leave glitter all over the house for the next two months is no longer an acceptable Mother's Day gift. It's time to mom up and get your #1 something fantastic for Mother's Day. ...
MORE
Words like icon and diva come to mind when describing Barbra Streisand. So does flawless . After getting her start as a nightclub singer in her teens, Barbra (then Barbara), quickly became a fixture throughout New York City. ...
MORE
Don't worry if you spaced on Valentine's Day. Today is another major romance-related holiday in Korea, White Day ! In Korean tradition, it's up to the girls to give their guys chocolates and presents on V-Day; on White Day, it's the boys who spoil ...
MORE
Kenzo ’s Fall/Winter show, presented today at the legendary La Samaritaine department store in Paris, was a total aesthetic treat for the senses. ...
MORE
Defina Delettrez 's pieces pretty much defy words. Exhibit A: a collar made from rainbow stripes of rubber connected by silver zigzags inset with crystals in multicolor settings and finished with a single large pearl at the center. ...
MORE
Meet Maggie, new to the OC Ace sales floor! Name: Maggie Thoms Hometown: Chicago, Illinois Astro sign: Cancer Currently obsessed with: Homemade pork ramen and I'm always obsessed with Rosen Munns' Tumblr Last song or movie I downloaded: ...
MORE
Meet Ashley, the new face on the LA sales floor! Name: Ashley Crews-Little Hometown: Savannah, GA Astro sign: Sagittarius Currently obsessed with: The TV show American Horror Story Last song or movie I downloaded: "Souvenir" ...
MORE
Straight from the south, meet Kyle, new to the sales floor at OCNY. Name: Kyle Wukasch Hometown: Memphis, TN Astro sign: Cancer Currently obsessed with: Goner Records Last song I downloaded: Nicolas Jaar "The Ego" ...
MORE
The holiday season is upon us, and this year it's time to HOLIDAY YOUR WAY ! We asked the artist and OC bestie Jeanette Hayes to share her wish list this year. ...
MORE
The holiday season is upon us, and this year it's time to HOLIDAY YOUR WAY ! We asked model, philanthropist, and friend of OC Kyleigh Kuhn to share what's on her wish list this year. ...
MORE
I followed a diminutive creature in a black Alaïa dress and Philip Treacy hat around Design Miami for about ten minutes, thinking it was Lady Gaga. ...
MORE
It's time to Holiday Your Way with OC! We've packed our gift guides with handpicked goodies for everyone on your list. A rainbow of Proenza bags, star-spangled Comme wallets, and some very shiny shoes make our gift guide for girls fail-safe. ...
MORE
Today would have been Isabella Blow's 54th birthday. Sadly, she is no longer here to send well wishes to so instead we honor her in this Fine Wine. Born in Marylebone, London, Isabella moved to New York in 1979 to study Ancient Chinese Art. ...
MORE
Lisa Bonet turns 45 today. And while she’s had three children, two name changes, and one marriage to Lenny Kravitz, she sure shows no signs of aging. Similarly timeless is her style. ...
MORE
Rome is home for Delfina Delettrez . And for her latest collection she let her imagination run wild in the Eternal City. "The collection was inspired by Rome's statues, architecture, and marble," she explains. ...
MORE
Check out what the staff are coveting! "When I first saw DELFINA'S ADDOLORATA COLLAR I was reminded of Frida Kahlo's painting The Two Fridas . ...
MORE
OC's Most Wanted presents our favorite and most coveted items available at OC. Crawling out of Olympia Le Tan's La Caduta Degli Dei clutch are Delfina's gold-plated critters , made immortal in resin and white agate. ...
MORE
Carol and Humberto took Kenzo jungle fever to a new level with an incredible spring collection. During a fitting last week, Humberto described its story as a girl entering the jungle and emerging transformed as a beautiful wild creature. ...
MORE
An apple a day may keep the doctor away, but we all know the power of Emergen-C. Filling the Kenzo runway show with all the citrus zing of a Florida orange grove, Delfina Delettrez 's acrylic Kenzo jewels star slices of real fruit! The pieces, just ...
MORE
Sunday marks the closing of the 2012 Summer Games. By now, the major events have all been won and lost, but the question left hanging in the air: who takes the fashion gold? Let's take a minute to look back at some of the unsung sporting stars of ...
MORE
Once a week in Silver Lake, LA, Ivory and OCLA's Michelangelo teach others about astrology. Now, at the turn of every sign, these two stargazers are here to offer us advice on love, life, sex, and fashion. LEO You gorgeous feline. ...
MORE
If we've caught you unawares it's time to get out from underneath that rock and head to Covent Garden, 'cause OC London is now open for business ! And for those not in London, never fear, the Opening Ceremony London online pop-up shop is here! Click ...
MORE
Even Italy is in on the UK and US fun! To celebrate our Covent Garden store opening, Delfina Delettrez got her nails did! Our favorite jewelry designer di Roma has hand-painted her signature sterling silver finger rings and single finger earrings ...
MORE
Meet Shannan, the latest addition to OCNY sales team. Name : Shannan Elinor Smith Hometown : Los Angeles, CA Astro sign : Gemini Currently obsessed with: Listening to Roy Orbison on vinyl Last movie I downloaded: Running with Scissors ...
MORE
With unparalleled cheekbones and legs like a racehorse, Anjelica Huston was prime for a modeling career at age 18, working with the likes of Richard Avedon and Bob Richardson. Acting was also a natural move. ...
MORE
In a family portrait, taken when she was 19, Frida Kahlo appears dressed as a man. She was badass. Frida is an inspiration because she didn't care what people thought, or at least she didn't let on that she did. ...
MORE
With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in THIS JUST IN . To many people, flares are an early 2000s comeback trend that should be left as that, but I beg to differ. ...
MORE
Meet Maddie, our newest showroom intern from Philly. Name: Maddie Bailis Hometown: Philadelphia Astrological Sign: Sagittarius Currently obsessed with: Gustave Caillebotte and Moroccan cooking Vice : Gum and jars of pickles As a teenager, I ...
MORE
Meet Alison, the latest production intern to join the OC Online team! Name: Alison Turka Hometown: Merion, PA Astrological Sign: Scorpio Currently obsessed with: Long hemlines When I was 13, I was wearing: Juicy Couture Vice: Sleeping too ...
MORE
This is the scariest movie ever made! At least it was to my kid-self. I remember watching Labyrinth , curled up under my covers, squeezing my teddy so hard I’m pretty sure he lost some stuffing that night—and the other thousand nights I ...
MORE
In the latest issue of Acne Paper there is a great interview with the one and only Isabella Fiorella Elettra Giovanna Rossellini (the perfect name for her). ...
MORE
Say hi to Kerri, the new girl at OCLA! Name : Kerri Dumin Hometown: Rosamond, CA Astro sign: Aquarius Currently obsessed with: Skydiving Supernatural power I would like to possess: Mindreading When I was 13, I was wearing: Dickies and ...
MORE
Meet Olga, our newest styling intern from far-off Moscow! Name : Olga Gagarina Hometown : Moscow, Russia Astrological sign : Leo Currently obsessed with: SoulCycle Last song I downloaded: "Jumanji" by Azealia Banks When I was 13, I ...
MORE
Tomorrow we celebrate The Queen's Diamond Jubilee, marking 60 years of her glorious pastel-clad, Corgi-filled reign. Since 1953, Elizabeth has ruled with unshakable British resolve, riding horses through assasination attempts, talking down bedroom ...
MORE
If you combined a science fair with a Victorian wake and thick coat of gold, you might come close to visualizing the creepily beautiful feat of imagination that is Delfina Delettrez 's spring collection. ...
MORE
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
OC's Most Wanted is a new series presenting our favorite and most coveted items available at OC. Spiders have thousands of them, Cyclops had one of them, your school teacher had them in the back of her head, and now you can have two on your ...
MORE
Next Sunday is Mother's Day and, in the immortal words of the Spice Girls, "Mama, we care." Here to help you show your appreciation for the years of unconditional love and affection is our Mommy Dearest Gift Guide . ...
MORE
Happy birthday to the Czech-born stunner Paulina Porizkova! With her icy penetrating stare and flawless jawline, it's no wonder she ruled the fashion world in her day. ...
MORE
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
Carol and Humberto staged another unforgettable fashion moment for Kenzo 's Fall/Winter 2012 show. Friends and family were in full effect to witness fifty models descend five floors of escalators in a rainbow-hued science university in the 5th ...
MORE
Strips of legendary Carrera marble, classic columns, and miniature mosaics conveyed the Roman inspiration behind Delfina Delettrez 's fall collection, presented at the Musée des Arts Décoratifs in Paris. ...
MORE
For our latest online editorial, OC stylist Daria Radlinski, prop stylist Amy Henry, and photographer Jeremy Liebman came together to play their own version of Supermarket Sweep . ...
MORE
Orgy cuff links, a basketball cage, boy-a-licious magazines, subtle colognes, a sexy skate deck, and of course designer condoms (when only the most fashionable will do!)—our men's gift guide for Valentine's Day has everything you need to set ...
MORE
Sixty black diamonds, three ruby tears, and nine-karat gold! It's just over a week until Valentine's Day, but Delfina Delettrez's heart-shaped stunner (made specially for OC) has already got us all worked up—and it's not the only thing... ...
MORE
To celebrate the start of the lunar new year, we raided OC for these red, fiery, and show-stopping finds to bring you all the luck you need in the Year of the Dragon. Gong hei fat choy!
MORE
An inspiration to almost every R&B artist out there these days (Drizzy for one), Aaliyah had her first record contract on lockdown at age twelve. ...
MORE
Humberto wishes Alex a happy one! Happy Birthday, Alex!!! Hope your day is as special and fun as that meal we had at Bellagio Café in Shanghai! xHumberto
MORE
In honor of Gregg Araki's birthday, we asked V Magazine editor and unofficial president of the Araki fan club, Patrik Sandberg , to say a few words on our cinema hero. ...
MORE
It's Christmas time y'all, and you know what that means: boozed-up uncles, awkward mistletoe moments, food comas and...PRESENTS! Spreading the love across the OCNY shop floor, our sales associates have assembled their favorite items to secretly send ...
MORE
Meet our pup-loving OC accessories designer, Zoë! Name: Zoë Wendel Hometown: Miami , FL Astrological sign: Scorpio Currently obsessed with: Dogs (always) Last song I downloaded: "Chi Chi" by Satan's Pilgrims When I was 13, I was ...
MORE
Say hey to our styling intern and Cali girl, Genesee! Name: Genesee Nelson Hometown: Los Angeles, CA Astrological sign: Gemini Currently obsessed with: Babies Last song downloaded: "Lover's Lane" by Hunx and his Punx When I was 13, I was ...
MORE
Happy belated birthday, Olympia ! Cleo Le-Tan sent us some gems for her big sis' b-day card. I guess I met Olympia the day I was born, as she is my older sister and I cannot really imagine a day in my life without her. ...
MORE
Meet Janelle, the newest West Coast native to arrive at OCNY! Name: Janelle Anne Flores Hometown: Los Angeles, CA Last album I downloaded: The Buffalo '66 soundtrack When I was 13, I was wearing: Black capri pants and Target flats What's on my ...
MORE
We are pleased to present our latest OCTV production, La Videoteca! Filmed in an OCTV truck parked outside the Ace Hotel, where our Argentinean-inspired FNO Mercado de carnaval was taking place, this video recaps the night with glitter, ...
MORE
The event itself needs no introduction, but for those caught unawares I will give one anyway. Last night, Opening Ceremony took over the Ace Hotel lobby and closed off Broadway, between 28th and 29th Streets, to host our Mercado de Carnaval – ...
MORE
Please welcome our new gem Ruby, who's come to OCNY from the long white cloud (aka New Zealand). Name: Ruby Page Hometown: Auckland, New Zealand Astrological sign: Sagittarius Currently obsessed with: Pleats Last thing I downloaded: The War on ...
MORE
Buzzing with life-like energy, Delfina Delettrez 's newest collection is straight from a wonderworld where nature meets fairytale meets celestial magic. ...
MORE
It started with the 1980 performance of "I Wanna Be Your Lover" on American Bandstand. Then as we cruised into the 80s, we found ourselves headed "Uptown" in a "Little Red Corvette" where the impossible was ...
MORE
With her amazing sparkly bras, skin-tight pants and killer cumbia hip moves, there was no question that Selena Quintanilla, aka the "Mexican Madonna", was slated to become the next Gloria Estefan. ...
MORE
The Opening Ceremony team is getting ready for the launch of our pop-up shops at Lane Crawford in Hong Kong (April 14) and Beijing (April 16). ...
MORE
Where does one even begin when it comes to Brando? With that famous jawline and the quizzical look that always managed to be piercing and sexy, he nailed the part of the brutish and sexually-charged Stanley Kowalski in Streetcar . ...
MORE
Big hair, expensive cars, supermodels, credit cards. The statuesque and curvy beauties that ruled the 80s will always retain the sexiness and glamour of the decade of excess, and Elle Macpherson is no exception. ...
MORE
Everything about her exuded glamour--the eyelashes, the furs, the diamonds, the mannerisms, the Twiggy thinness when skinny was just becoming the look du jour, and of course, that hair. ...
MORE
Just twenty four years ago, she was born this way! Since the release of her debut album 'The Fame,' Stefani Germanotta (better known as Lady Gaga) has paired with friend of OC Terence Koh , met the Queen of England, been bailed out of the slammer by ...
MORE
Mirth and the macabre go hand-in-hand with any Delfina Delettrez collection. This season, culling together signature touches of menswear, nature, and neurosis, the exceptional designer presents "We-Man": an array of cuffs, crosses, rings, ...
MORE
Delfina Delettrez presented a typically ingenious and whimsical collection in Paris this week. Inspired by a mechanical element from a shoe factory in Florence, the jewelry rotated on a slowly moving bright green display piece. ...
MORE
Yui , our OC Tokyo sales associate always decked out in major jewelry, shows off her personal duds and OC picks! I have been collecting jewelry for the past couple of years. ...
MORE
Bjork's unforgettable swan dress, Roberto Benigni's completely incomprehensible acceptance speech, River Phoenix's first and only Oscar nomination, Uma Thurman turning Prada from an dusty luggage brand to international fashion powerhouse ...
MORE
When it comes to saying I love you to your sweetheart, why should it be only the thought that counts? Spoil her this V-day with our Valentine's Day Gift Guide picks and make her really melt! Shop the Valentine's Day Gift Guide for her now!
MORE
Ever since her first Sports Illustrated cover in 1979, Christie Brinkley has been an emblem of all-American sexiness. In her heyday, the toned and leggy California blonde best known for holding the longest running contract in modeling history with ...
MORE
With her perfectly over-the-top fashion sense (which she proudly says is modeled after the town tramp), bawdy sex appeal, and indisputable talent, Dolly Parton has been dazzling us for over four decades with songs like “Jolene” and ...
MORE
Best known for being the face of Calvin Klein for two decades, Christy Turlington belonged to the pack of glamazon models who dominated the runways, ad campaigns and editorials of the 80s and 90s. ...
MORE
As it becomes a matter of hours until Christmas and our mini-series showcasing our gift guide comes to an end, we thought it would be best to go out with a bang and save the best for last: the Party Heart . ...
MORE
At the intersection of fancy and freakish is the 2011 holiday collection from ever provocative Italian, Delfina Delettrez . Infusing a very classy, very clean look with touches of the occult, the young accessories designer offers crisp cotton ...
MORE
High pompadours, endless champagne teas, a faux-countrysid e retreat - the excesses of Marie-Antoinett e and Louis the XVI have fed fact, fiction, and fashion for the past three centuries. ...
MORE
Jewelry designer Delfina Delettrez lives in a charming apartment in the 6th arrondissement of Paris, on a little square behind the bustle of St. Germain des Près. ...
MORE
Fresh-faced and wide-eyed, Lesley Hornby took the Swinging London scene by storm with her boyish physique and stick-thin gams that earned her the nickname Twiggy . ...
MORE
Considering delfina delettrez 's signature playful macabre mysticism, it's a wonder that she and Dan Tobin Smith hadn't found each other sooner. ...
MORE
Since my younger sister Chrissy has been studying in Rome since January, my family jumped on the opportunity to visit her while she had a few days off for spring break! I of course took advantage of this as a time to explore, take a ton of ...
MORE
Italy's fashion capital, Milan, transforms itself in April when the design world makes their yearly exodus to Salone Internazionale del Mobile: the world's most electrifying design expo where new chairs and coat racks make for riveting dinner ...
MORE
The flexi glass globes that fall from the ceiling of Delfina Delettrez ’s latest presentation are meant to resemble those that, if legend holds true, will descend upon earth in December of 2012 and hatch ET offspring all over our planet. ...
MORE
Last night Opening Ceremony New York was transformed into Delfina Delettrez ’s playground: where marble floors were stacked with pillars displaying a season's worth of skulls, spiders, frogs, crowns, body parts, and enamel. ...
MORE
No one went away empty handed from our party on Fashion’s Night Out , as our guests lined up around the block for the chance to play covergirl in our instant magazine photo shoot. ...
MORE
With a balance of the macabre and the mythical, the pieces in Delfina Delettrez Fendi's collection of jewelry looks like they were picked out of a menacing fairy tale. ...
MORE