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=21 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=92 and productid=cache_Products.productid) order by PublishDate desc
Billie Holiday on repeat made Scott Sternberg think 1940s for his Fall collection. The doe-eyed gamine of collections past has grown up and is playing the main dame in a noir film. Boxy shirts, flowy dresses, and slouchy pants drape for a ritzy look that'll have all the wise guys wanting to go steady.
An offshoot of his similarly named menswear label, Scott Sternberg’s Boy. by Band of Outsiders is every effortless prep’s fantasy. Featuring painfully perfect prints, classic silhouettes, and innovatively integrated menswear details, Boy is the sort of brand whose astute aesthetic makes each piece incontestably timeless.