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=7 and productid=cache_Products.productid) order by PublishDate desc
The mind boggles when you try to imagine what the inside of Tsumori Chisato 's mind might look like. Here's what I came up with: shooting stars streaming over a tangerine sunset that silhouettes some divine heroine on a unicorn. ...
MORE
You can never own too many stripey T-shirts. Fact. To help you broaden your range this spring, here's a selection of super sweet stripes covering everything from canvas clutches to seersucker caps. ...
MORE
Only after dropping out of school at age 15 and exploring the New York nightclub scene, did David LaChapelle enroll in a North Carolinian arts school and discover his passion for photography. ...
MORE
An artist with a unique insight into the human condition and a filmmaker capable of transforming the mundane into fantasy, Miranda July possesses a captivating talent. ...
MORE
The holiday season is upon us, and this year it's time to HOLIDAY YOUR WAY ! We asked friend of OC Julia Frakes , the supremely stylish fashion writer, what she hopes to see wrapped in a box labeled TO: JULIA underneath the tree. ...
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
A neon light shaped like a steer’s skull was the first clue about where Tsumori Chisato was sending us for Spring/Summer 2013. But chez Tsumori the story is always unheard of. ...
MORE
Check out what the staff are coveting! "I'm always into products, like these COFFEE SCALLOP SUNGLASSES , that don't take themselves too seriously. Tsumori always does a great job of mixing fun prints with cool shapes. ...
MORE
If you were alive during the better part of the 90s, there's no denying the amazing ness of Tori Amos. Flame-haired and fairy-like, the absurdly talented piano-rocker is arguably one of the greatest pianists and vocalists of our time. Seriously. ...
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
The things that must go on inside Tsumori Chisato 's head! This season, her magical universe, which I like to call Tsumoriland, is filled with fur-lined clogs, glitter-coated booties, and tights printed like technicolor cartoon seas! It's a place ...
MORE
If you've ever read Seventeen , you will know that Reese Witherspoon has a heart-shaped face, and that drawing around your reflection in a mirror is the best way to identify your own. ...
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
The sky is blue, the smell of hotdogs is in the air, and we’re setting up camp on the roof until the fireworks. Which means we’ve got all of ten hours to spend painting our faces, BBQing, and making like Miley and partying in the USA! To ...
MORE
When you hear, "Let's go to the beach!" you need to be ready. Like flashlights, tinned food, and blankets in an emergency, the perfect bikini, sunglasses, and towel would, in an ideal world, be packed in a bag by the door. ...
MORE
By now, most of you should be acquainted with The Travel Almanac , a publication focusing on near and far places and the people who travel there. ...
MORE
Our annual OC-exclusive Soludos espadrilles arrived last week, officially marking the start of summer! Picture those, on the feet of a picnicker, as the end-point in a dizzying Eames " Powers of 10 "–style video, then zoom back 4,000 ...
MORE
Blogging some of the most magical manicures in the game—all inspired by her favorite pieces at OC—beauty contributor Taryn (aka MISS LADYFINGER ) is back! Nailing down my summer plans has me attempting to eat healthy while I envision ...
MORE
Matty and Megan, OCLA's FUN-LOVING DUO , are back! The question, "What are you wearing to Coachella?" is posed a lot around this time of year, and with the big festival only a few weeks away, OCLA decided it was about ...
MORE
In a realm usually occupied by long johns, Moon Boots, and fleece, Tsumori Chisato has taken the après-ski look and made it darling for Fall/Winter 2012. ...
MORE
You know that montage in Clueless where Tai awkwardly and indecisively tries to style her sheer shirt with her overalls? ("Do I tie it around my waist, Cher?") I think that's how most people feel when they wear a silk scarf. ...
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
Don't you miss coloring in? And new packs of Crayola markers? And peeling glue off your fingers? Tsumori Chisato ’s resort collection reminds me of all the best bits of art class but without the rogue specks of glitter that used to ...
MORE
With eyes like saucers and unforgettable bangs, Anna Karina was the archetype of French Wave film beauty. Exuding simplicity and timelessness, the Danish-born gamine was a Godard muse, and for good reason. ...
MORE
Catrinas , cacti and lots of color; this lively t-shirt could only be the work of the fanciful Tsumori Chisato ! Inspired by a recent trip to Mexico, Miss Chisato created this soft cotton tee especially for this week's Fashion's Night Out ...
MORE
When TSUMORI CHISATO last visited the OCNY store, we jumped at the opportunity to ask her how she created such whimsical, fantastical designs. ...
MORE
Plucked from the hoards of potential DJs in hopes of cue'ing it up for lady rap group Salt-N-Pepa, Deidra "Dee Dee" Roper was only sixteen at the time that she became the Spinderella we know and love. ...
MORE
Hey, Phoebe. Where've you been? Since Gremlins 2 , we haven't seen too much of you. While you may be a momma now, you'll eternally stay in our minds as the ultimate '80s movie babe from Fast Times at Ridgemont High . ...
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
Oh Brooke, let’s get real girl, age has always been something that has defied you. As a child you were easily, and often controversially, mistaken for an adult and today your looks set you back dozens of years. ...
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
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
From one friend of OC to another: Gia Coppola wishes her aunt Sofia the best for her birthday, which is tomorrow! Dear Sofia, Happy Birthday! Hope you're having a good day. You're the best and coolest aunt a girl could have! xo, Gia
MORE
Let me start by saying, there's no time like springtime to show some leg–believe me, as winter took its sweet time abating, we were missing our minis as much as the next gal. ...
MORE
It's our dear friend Kirsten Dunst's birthday and we wanted to wish her the happiest 29th birthday ever. Susan Miller says, "Your time in the Sun is coming, dear Taurus. You are on the verge of so much goodness. ...
MORE
Her claim to fame was playing Brenda Walsh, the wildchild and queen B of Beverly Hills: 90210 (the character that Alex Wang also named his Brenda bag after!) and subsequently becoming one of Hollywood's most notorious bad girls. ...
MORE
Twenties silhouettes, ruffled Edwardia, huge round sunglasses, and a pinch of glitter: Tsumori Chisato's fall/winter show in Paris was typically whimsical and dreamy. ...
MORE
He pioneered grunge, dated Tobi Vail from Bikini Kill, wed Courtney Love in pajamas on a beach in Hawaii, and wrote "Smells Like Teen Spirit," the ultimate teenage anthem that has long outlived the 1990s. ...
MORE
Mia Farrow is one of those kitty cat actresses who has had nine lives and counting. As the ingenue Hollywood daughter of John Farrow and Maureen O'Sullivan, she charmed audiences on the racy television series Peyton Place . ...
MORE
In New York during the 1960s something was brewing in the Bowery, with Patti Smith leading the charge. But the poet laureate and punk rock priestess, who has been called the Godmother of Punk and the "gothic crow" by Salvador Dali, never ...
MORE
Despite being best known for dating Mick Jagger (with whom she penned 'Sister Morphine') and being one of the most hard-living couples of the Swinging London scene together, Marianne Faithfull is an icon of rock royalty in her own right. ...
MORE
Best known for her playful take on color, pattern, and volume, fashion veteran and OC staple Tsumori Chisato, who started out under the wing of Issey Miyake in the late 1970s, has been gaining more and more street cred since her label has expanded ...
MORE
Get acquainted with Olivia, our new OCNY sales associate, who blew in from the Windy City. Name: Olivia Wendel Hometown: I've lived lots of places, most recently Chicago. ...
MORE
With that signature billowy fit, Tsumori Chisato has been giving us uniquely breezy womenswear for nearly 30 years. Crafting precious pieces that hug and hang in all the right places, the imaginative Japanese designer continues to redefine the idea ...
MORE