select ProductID , 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 cache_products.GroupID <> 5433) 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=821 and productid=cache_Products.productid) order by PublishDate desc
If Old Hollywood stars clashed with the schoolgirls of Battle Royale, Jennifer Behr would make their battle gear. With leather headbands, studded satin turbans, and mink pompoms, it’s a showdown of cuteness and glamor!
Patent leather headband | Bow detail | Genuine leather | Made in the USA.
Brooklyn-based accessories designer Jennifer Behr almost immediately shot to fame after branching out from Chanel to create her own eponymous label of glamorous, mixed-media headwear pieces. Classic with modern accoutrement, each creation is a perfect mix of precious and pop.