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=747 and productid=cache_Products.productid) order by PublishDate desc
Susan Sontag began offering her unique perspective to the public at the fresh age of nine. It was from these self-publishing origins that she moved on to be the prolific literary icon, filmmaker, professor, and political activist that we remember ...
MORE
Pennies are as English as it comes. Nearly every English saying involves either spending one or saving one (my Granny basically only speaks in penny phrases). You counted out pocketfuls at the sweet shop when you were little. ...
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
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
Like something from the Brothers Grimm, the silver roses in German-born designer Husam El Odeh 's spring collection are actually real flowers. Not so long ago they were growing in London gardens, until the designer cycled by and picked them. ...
MORE
Dear Ms. Hill, You've been ruling the world (and our hearts) since 1996, and it's unlikely that'll change anytime soon. Happy birthday! Love, Your friends and fans at OC
MORE
Inspired by reality, plain and simple, London-based designer Husam El Odeh draws influence directly from the world that surrounds him to create accessories that are anything but plain and simple. ...
MORE
With only one day left before the big night, Acne Studio thought it was time to catch up with Husam El Odeh on his latest dreams, obsessions, and, most importantly, his special edition t-shirt for Acne studio Fashion’s Night Out , pictured ...
MORE
This season, Acne and Husam El Odeh add some armor to the Kex Jean - an ultra-slim low-rise recently added to the Acne repetoire. Together they created a series of silver plates made to fit over and around the knee. ...
MORE