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=1331 and productid=cache_Products.productid) order by PublishDate desc
Some say staring into a girl's handbag is like staring into her soul. In this series, we ask friends and family to spill their bags and show us what their daily essentials are. ...
MORE
On a not-so-sunny spring weekend, photographer Kevin Amato and I headed to the Jersey Shore to appreciate the seaside during the final days of the off-season. ...
MORE
Check out what the staff are coveting! "Good things (like me) come in small packages and this teeny tiny DOT BUNNY BRACELET bracelet is no exception"—Julie Check out all of julie's picks | Shop all Hillier
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
Bunnies, bunnies, and more bunnies. Just like her new jewelry line, Hillier , accessories designer and consultant Katie Hillier's London studio is filled with bunnies. ...
MORE
I wish there was a Jessica character from American Pie at my high school when I was growing up. Some sassy girl who verbally throws a bucket of ice cold water over any teenage fascinations and subsequent paths to disillusionment. ...
MORE
“Dotty in Love,” the title of Katie Hillier ’s Spring/Summer 2012 collection, sums up exactly how we feel about the season’s offering of gold bunnies, diamonds, and ladybug spots. ...
MORE