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=1 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=14 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=364 and productid=cache_Products.productid) order by PublishDate desc
The HENTSCH MAN SS14 collection was, in a word, cool. Held at an outdoor warehouse, the presentation was a welcome, chilled out affair—light years away from the intensity of runway shows. ...
MORE
Happy birthday to our fine friend Catherine Keener ! With roles that include a forty-something seductress in The 40 Year Old Virgin , a worrisome mom in Where the Wild Things Are , and a disinterested love interest in Being John Malkovich ...
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
Surfing and girls. Girls and surfing. Hentsch Man 's spring collection sent me deep, deep into a Beach Boys hole. They literally have about ten songs with the word surfing in the title. ...
MORE
Yesterday, Hentsch Man 's Alexia Hentsch and Max Von Hurter presented a Fall/Winter 2013 collection at their Covent Garden pop-up shop, where they showed their signature subtle tailoring in classic, muted tones (black and white, browns, ...
MORE
As Hentsch Man 's Spring/Summer 2012 collection of coastal classics sails into OC, we took a moment to check in with our bow tie-wearing buddy Alexia , one half of the HM team. ...
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
John Stamos, all we have to say is: Have mercy! Most (if not all) Full House fans couldn't help but have a crush on the ever-so-charming Uncle Jesse. ...
MORE
Matty and Megan, OCLA's fun-loving duo , are back! Get ready for the parties, the fireworks, and the water guns! Matty and Megan picked their favorite red, white, and blue outfits for this weekend. ...
MORE
Dear Ashley and Mary-Kate, Happy birthday to you! As toddlers, you were Michelle Tanner. As tweens, you were Two of a Kind. Today, you're still forces to be reckoned with, but at a whole other level (oh hey CFDAs!). ...
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
David Robert Jones, David Bowie, Ziggie Stardust, Aladdin Sane, the Thin White Duke: in each and every incarnation Bowie managed to create shock waves with both his music and his style. ...
MORE
January 4th is not only the day that NASA landed Spirit on Mars in 2004, but it is also the birthday of he who wrote "Man on the Moon", the song to which we gathered in a circle at Junior prom and happily chanted the night away -- my good ...
MORE