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=371 and productid=cache_Products.productid) order by PublishDate desc
Today is the birthday of influential and all-around inspirational author, Vladimir Nabokov! Born in 1899 in St. Petersburg, his family fled Russia after the Bolshevik Revolution and landed in England, where he enrolled at the University of Cambridge. ...
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
Happy birthday to the face of Nouvelle Vague and OC’s favorite Iowa-born mademoiselle, Jean Seberg! Jean had an effortless and fresh look, particularly when you compare her to other French vixens of the 60s era. ...
MORE
Before Beverly Hills, 90210 , Dawson’s Creek , The O.C , and Gossip Girl there was Saved by the Bell . For four years (plus the two spin-off series), Zack, Kelly, Lisa, A.C, Jessie, Screech, and Mr. Belding made us laugh, cry, and LUST. ...
MORE
For all of our favorite classic staples–from gingham (which she wore when she wed Jacques Charrier in 1959), to Repetto BB flats (which Rose Repetto created just for her ), to the bikini (which she immortalized in countless photos and ...
MORE
NYC surfwear sweethearts Karen Mulligan and Jillian Demling return this season with another series of instant-hit Pret a Surf swim gear we're gaga for. ...
MORE
It's Independence Day! And while Opening Ceremony may be known for having lots of international love, we wanted to take a moment to gush about some of our very favorite made-in-the-USA styles. ...
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
Wined, dined and adored by the world’s most handsome and powerful men, Marilyn Monroe is the original blonde bombshell. And while her life was plagued by Hollywood Studio strictures and private darkness, her outward persona was that of pure ...
MORE
We're ready for summer to hit! Matty and Megan pick outfits to go with their favorite summertime activities. These pics are for entertainment purposes only -- we do not recommend jumping rope in heels. Photographs by Teena Sahebi
MORE
Happy birthday (tomorrow) to our favorite Aussie pop songstress! Since the late 1980s, we've watched Kylie Minogue evolve from girl-next-door to dancing queen to sex kitten and everything beyond. ...
MORE
Hardly anyone would have predicted that squeaky little Gertie from E.T. would become a Studio 54 regular by age 10 and spiral into the precocious wildchild living she would later chronicle in Little Girl Lost . ...
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
More Broadway Boogie Woogie than Blue Crush , Pret-a-Surf ’s debut collection of swimsuits and rashguards is the surest bet to keep you from looking like a floating glowstick, which, let’s be real, happens a bit too often in surfer-gear. ...
MORE