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 exists (select top 1 1 from mss_index where typeid=92 and productid=cache_Products.productid) order by PublishDate desc
The Stripes Suspender Skirt by BOY by Band of Outsiders is high-waisted, skinny-fit, with a pencil cut. The stripes are made of spandex/rubber elastics serged together. Available in Navy/Red/White and Black/White.
Established: 2004 by Scott Sternberg
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.