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=15 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1310 and productid=cache_Products.productid) order by PublishDate desc
The SAG Awards on Sunday night were unexpectedly great, fashion-wise. Now at the mid-point between the Golden Globes and the Oscars, we are officially in high Awards Season—and jacked up on heart-wrenching speeches and best-dressed lists. ...
MORE
With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in " THIS JUST IN .' " At first glance, sheer dresses can come off very wear-it-with-heels-on-Miami-Beach. ...
MORE
Versace safety pins made Liz Hurley in 1994. And for Spring 2013, Versace Versus has brought them back—but minus the thigh-high splits (unlucky, Hugh). This time around, the look is more Camden girl than vamp. ...
MORE
Polly Jean Harvey stormed the boys' club that was indie music during the early 90s, and has been leaving us guessing since. Every album brings a completely new sound and always with a look to match (or clash. ...
MORE
Meet Nathaniel, the new Virgo at OCLA! Name: Nathaniel Santos Hometown: Anaheim, CA Astrological sign: Virgo Currently obsessed with: Comme Des Garcons ' paper doll fall collection, Ezra Miller, In-N-Out burger Last song I downloaded: "One in ...
MORE
Make It Snappy is a photo series showcasing quick snaps from OC & friends Who: Lisa and Carol Where: Norma Kamali's showroom, checking out Norma's Future Vintage collection for Spring/Summer 2013 When: This morning!
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 you haven't made it to our store at 10 Greene Street in New York, here's what you've been missing. When Acne Studios moved out, OC cropped up in sporting style, swapping the denim shelves for swim lanes and diving boards. ...
MORE
With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in ' THIS JUST IN .' So you know we're obsessed with Norma Kamali , right? She's a guru to us in life as much as she is in fashion, and we would ...
MORE
Opening Ceremony London is open for business! To celebrate this royal occasion, we asked some of our favorite Yanks and Brits a few questions about each other's countries and the upcoming Olympics. ...
MORE
&amp;amp;amp;amp;amp;amp;amp;lt;br&amp;amp;amp;amp;amp;amp;amp;gt; Opening Ceremony London is open for business! To celebrate this royal occasion, we asked some of our favorite Yanks and Brits a few questions about each other's ...
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
OK, whoever is in charge of the Olympic uniforms for the States needs to take a leaf from the book of Norma, and recognize that her way is the only way. ...
MORE
Our London store opens July 19th! For the next week, we will be introducing you to all the new faces. First black cab off the rank is Dot, the store manager! Name: Dot Burns Hometown: Cobham Astrological sign: Leo with Sagittarius rising Currently ...
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
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
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. CANCER Warrior you are... ...
MORE
Norma Kamali has dressed everyone from Brooke Shields to Beyoncé, works out daily , and produces her own line of olive oil. She also makes jumpsuits out of parachutes, which settles any doubts about whether or not she is a superhero. ...
MORE
Rather than dropping in on Norma Kamali at her home, Christelle and I figured it was more likely that we would catch her at Physique 57, where she tones and flexes on the daily. ...
MORE
Over these last ten years, OC has made a lot of inspiring friends! In our most recent editorial, photographer Christelle de Castro and I sought out some of our favorite innovators and asked them where they get their creative juices flowing. ...
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
When Norma Kamali sat down to talk to OC at her Wellness Café in uptown New York, neither Gillian nor I was prepared for the semi-religious experience that followed. The iconic American designer radiates health and a guru-like aura. ...
MORE
Make It Snappy is a photo series showcasing quick snaps from OC & friends Who: Christelle, Norma , Daria, and Chantelle What: Post-workout Where: Our new favorite gym, Physique 57 Why: Find out in the next OC online editorial ...
MORE
Like everything Norma Kamali does, the cut-out models at her presentation this morning were larger than life. A forest of spindly-legged giants, including OC-favorite Hyoni , towered above spectators in oversized-houndstooth dresses, swathes of ...
MORE