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=21 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=191 and productid=cache_Products.productid) order by PublishDate desc
Did you notice anything different this morning? Like how you didn't have to double over against the cold? Spring is here FOR REALZ. It's time to ditch your coat and bring out the crewnecks and cardigans. Because, guess what, you can. ...
MORE
What a major week for you, Riri! First you drop your collection with River Island at London Fashion Week and now it's your 25th birthday! We are so excited to help launch the collection and can't wait to share more of your flawless style, but in the ...
MORE
The room at the Ostwald Helgason presentation yesterday was packed. The only person missing was Susanne Ostwald (whose flight had been canceled thanks to Nemo) but the show went on. ...
MORE
Philanthropist Frances Lasker Brody is famous for second-guessing Matisse; the wealthy Californian asked the artist to reconsider a mosaic he was creating for her Los Angeles home. ...
MORE
With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in THIS JUST IN . My obsession with all things shiny and sparkly began when I first laid eyes on the OC pre-Fall collection. ...
MORE
With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in THIS JUST IN . I get that wearing head-to-toe black and white is a "thing," but as clean as it looks, it can get boring. ...
MORE
One of my earliest memories is of being trussed up in a tiny piece of tiger-print fabric to play a very fat Mowgli in my sister's home video remake of The Jungle Book . Apparently, we weren't the only ones obsessed with Rudyard Kipling. ...
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
The print on my favorite piece from Ostwald Helgason's presentation on Saturday was a cross between between toile de jouy, camouflage, and a vintage map—complete with tiny ships. ...
MORE
Farrah Fawcett was the girl all the boys wanted and all the girls wanted to be. With a hairdo that was basically "The Rachel" of her generation, the TV commercial model-turned-Charlie's Angel made it to icon status when she famously posed ...
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
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
From rock'n'roll frontwoman to psycho-opera creatrice, Karen O. is one gold lion woman! Check out Carol's birthday wishes and our gifts to Karen below! Happy Birthday Karen! Wish I could be with you today, you're something like a phenomenon, ...
MORE
Before she starred in Fellini's La Dolce Vita (a role she was offered on the spot), recorded a song with Rolling Stones guitarist Brian Jones, inspired Bob Dylan's song "I'll Keep It with Mine", met Andy Warhol, became the Velvet ...
MORE
Because there's nothing better than seeing double, especially when it comes with a theme song that rhymes "family tree" with "sibling synchronicity." Happy birthday, Mowry sisters! Peep our presents below!
MORE
Susanne Ostwald and Ingvar Helgason indulge in some frisky futurism for their Spring/Summer 2011 collection, offering hazy zig-zag prints, ultra cropped tops, and whimsical onesies. ...
MORE
Singer and OC friend Maluca sends birthday love to her girl Robyn, whose big day was yesterday -- but it's never to late to celebrate. Dear RobynYa, I'm here at OC wishing you a very happy, fruitful and experimental birthday. ...
MORE
Every day up until December 23rd, we're featuring a different category from our Holiday Gift Guide, which we created for everyone on your gifting list! Grizzly Bears and Lumber Janes: a little rough and tumble is never out of the question for these ...
MORE
Little did we know that while we were dressing up Erykah Badu, she was dressing down...to nothing. In her new, already controversial video, " Window Seat ," Erykah does her take on last year's MTV Breakthrough Video winner, Matt and ...
MORE